Lynn Langit PRO
Cloud Architect who codes
~ 45 years old
@lynnlangit
(Microsoft)
@lynnlangit
@lynnlangit
(Google)
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
(AWS)
3 Steps
Works with
@lynnlangit
@lynnlangit
(AWS)
3 Steps
Save 30-90% $/perf
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
Best for 'ad-hoc' SQL queries of data in S3
For aggregate queries
Use Parquet files
@lynnlangit
Elastic relational database
@lynnlangit
(AWS)
@lynnlangit
@lynnlangit
@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
@lynnlangit
@lynnlangit
@lynnlangit
(Google)
@lynnlangit
@lynnlangit
By Lynn Langit
Deck on AWS Athena and more for NDC Sydney Sept 2018