Lynn Langit
Cloud Architect who codes
@lynnlangit
@lynnlangit
~ 45 years old
@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
@lynnlangit
Use Case | AWS | GCP |
---|---|---|
Ad hoc | S3 Select/ Athena | BigQuery |
Warehouse | Redshift Spectrum | BigQuery |
Transforms | Glue - PySpark | DataFusion/Dataflow |
Streaming | Kinesis Analytics | Pub/Sub -> BigQuery |
Relational | Aurora Serverless | BigQuery |
@lynnlangit
@lynnlangit
@lynnlangit
@lynnlangit
(Google)
@lynnlangit
@lynnlangit
@lynnlangit
By Lynn Langit
Deck on Serverless SQL Patterns for Serverless Minnesota May 2019