I will optimize slow bigquery and snowflake sql queries to cut costs
Snowflake and BigQuery SQL, dbt pipelines, Power BI and Looker dashboards
About this Gig
Slow dashboards and a growing warehouse bill usually come down to a handful of queries. I'll find them and fix them.
We're Dedolytics, a data and analytics consultancy. We write and tune SQL on Snowflake and BigQuery. Recent work (anonymized): we fixed broken Snowflake pipelines and sped up the slow queries behind a Florida fire rescue department's reporting.
What I do: review your slowest or most expensive queries, rewrite them, and recommend partitioning, clustering and materialization changes. You get the optimized SQL, a short note on each change, and before/after runtime and bytes scanned measured on your own data.
Basic: 1 query tuned. Standard: up to 10 queries plus a cost report. Premium: up to 20 queries, dbt model refactor, cost alerts and a handover call.
Results depend on your data and setup, so I don't promise a fixed % saving. I'll show you exactly what changed.
Please message me before ordering with your warehouse (Snowflake or BigQuery) and roughly how many queries, so I can confirm the right package.
Database type:
Distributed database
•
Relational database
Platform:
BigQuery
•
PostgreSQL
•
Redshift
Expertise:
SQL
•
Big data
•
Performance
•
Query optimization
My Portfolio
FAQ
Which warehouses do you work with?
Mainly Snowflake and BigQuery. Redshift and PostgreSQL on request.
What access do you need?
Read access to the queries (or query history) and the tables involved. A read-only role is enough; I never need your password.
Do you guarantee a cost reduction?
No fixed guarantee. I measure before/after runtime and bytes scanned on your data so you can see the real difference.
Can you work with dbt?
Yes. The Premium package includes refactoring the related dbt models.
