Lynn Langit PRO
Cloud Architect who codes
Domain-specific language
~ 45 years old
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
3 Steps
Works with
@lynnlangit
@lynnlangit
3 Steps
Save 30-90% $/perf
@lynnlangit
@lynnlangit
Item | AWS Athena | GCP Big Query |
---|---|---|
Query | $ 5 / TB scanned | $ 5 / TB scanned |
Store Data | $ 20 / TB** in S3 | $ 20 / TB** in BQ |
* Loading and Exporting data is FREE
** Price per TB per month
@lynnlangit
@lynnlangit
Item | AWS Athena | GCP Big Query |
---|---|---|
Query | ||
Input data | ||
Output data |
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
Best for 'ad-hoc' SQL queries of data in S3
Best for 'frequently-accessed' and 'highly-structured' data stored in S3
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
Use Case | AWS | GCP |
---|---|---|
Ad hoc | S3 Select/ Athena | BigQuery |
Data Warehouse | Redshift Spectrum | BigQuery |
Batch Transform | Glue - PySpark | BigQuery - UDFs |
Streaming | Kinesis Analytics | BigQuery |
Relational | Aurora Serverless | BigQuery |
@lynnlangit
@lynnlangit
By Lynn Langit
Deck on AWS Athena and more for Velocity Con in San Jose June 2018