GCP BigQuery
Vishal Jadhav Following are the most important topics in bigquery. This is also important topics in a perspective of GCP Profession Data Engineer exam. BigQuery basic concepts wildcard tables _table_suffix External Table…
BigQuery
partition and clustering – BigQuery
Table of Contents Toggle Limitations can you create a partition without clustering? Limitations maximum 8000 partitions possible on a single table and upto 4 columns can be used for clustering…
Time travel – BigQuery
Table of Contents Toggle what is time travel in bigquery? Big query time travel – query for extracting data for last 24 hour. what is time travel in bigquery? Using…
What is a federated query in BigQuery?
Federated queries are used to query the data on external sources like Cloud Storage, BigTable, CloudSql, Spreadsheet in google Drive. Federated queries or have queries that access data that isn’t…
Ultimate Guide to BigQuery Slots: Boosting Performance and Managing Costs Efficiently
BigQuery slots are a fundamental aspect of Google Cloud’s BigQuery service, which is a fully managed, serverless, highly scalable, and cost-effective multi-cloud data warehouse. Slots represent the computational power required…
BigQuery – Anonymous dataset
BigQuery writes all query results to a table. The table is either explicitly identified by the user (a destination table), or it is a temporary, cached results table. Temporary, cached…
View vs materialized view – BigQuery
difference between view and Materialized view