Query and Cost Optimisation

Reduce costs and run queries faster for Snowflake, Databricks, BigQuery, Redshift, Athena & More

A comprehensive guide for data engineers to optimise their data compute cost and performance at scale

Filter by

Engine type
Optimization Types
Optimization Level
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Databricks

Query Optimization
Z-ordering, Delta Cache, broadcast joins, AQE, Auto Loader, CDF, auto compaction, serverless SQL.
Read more
Advanced
Databricks

BigQuery

Cost Optimization
Includes materialized views, smart partitioning, result caching, sampling, query guards, autoscali..
Read more
Beginner
BigQuery

Microsoft Fabric

Cost Optimization
Optimize Fabric: monitor yardsticks, Power BI aggregations, Delta layout, materialization, caching..
Read more
Advanced
Microsoft Fabric

Databricks

Cost Optimization
Includes auto-scaling warehouses, optimizing Delta layout, cluster pools, right-sized spot cluster..
Read more
Beginner
Databricks

ClickHouse

Cost Optimization
Includes materialized views, intelligent sampling and dictionary lookups, optimized batch sizes...
Read more
Beginner
ClickHouse

Snowflake

Query Optimization
Speed Snowflake by right-sizing and MCWs, exploiting result cache with stable SQL, modeling credit..
Read more
Snowflake

AWS Athena

Cost Optimization
Reduce Athena costs by enforcing result reuse, setting workgroup limits, partition projection, co...
Read more
AWS Athena

Snowflake

Cost Optimization
Reduce Snowflake costs by throttling dashboard refreshes, leveraging 24-hour result cache with st..
Read more
Beginner
Snowflake
This optimisation hub is coming soon
Available at
BlogEventsDocs
Terms and ConditionsPrivacy PolicyCookie Policy
© 2025 e6data Inc. All rights reserved.