m06-bigquery-cost-optimization

Topic-42: Transform BigQuery data before you send them to data platforms

2 min read

Topic-41: How to use the Google Cloud pricing calculator

2 min read

Topic-40: Introduction to Google Cloud pricing calculator

1 min read

Topic-39: Regularly monitor your spending

Topic-38: Set up Quota limits

Topic-37: Set up Budget alerts

Topic-36: Cost impact of LIMIT clause to a SELECT *

1 min read

Topic-35: Avoid using SELECT *

Topic-34: Impact of column size on query cost

1 min read

Topic-33: Query cost depends on columns and not rows

1 min read

Topic-32: Check the size of your query

Topic-31: Preview the table

1 min read

Topic-30: Check the size of the table

1 min read

Topic-29: Avoid mindless data processing

1 min read

Topic-28: Practice data minimization

1 min read

Topic-27: BigQuery Cost Optimization best practices

Topic-26: BigQuery operations that are free of charge

Topic-25: Editions pricing model

Topic-24: Flat-rate pricing model

Topic-23: BigQuery's On-demand pricing model

Topic-22: Long term physical storage

Topic-21: Active physical storage

Topic-20: Long term logical storage

Topic-19: Active Logical Storage

1 min read

Topic-18: Time travel physical bytes

Topic-17: Understanding Time Travel in BigQuery

1 min read

Topic-16: Long term physical bytes

Topic-15: Active physical bytes

1 min read

Topic-14: Total Physical bytes

1 min read

Topic-13: Long term logical bytes