Articles

• How to INSERT from one nested table into another nested table in BigQuery
• BigQuery SQL to count the number of UNIQUE matching values
• Bigquery : Too many partitions produced by query, allowed 2000, query produces at least xxx partitions
• BigQuery count distinct vs count of group by colx
• BigQuery - DATE_TRUNC on string column
• BigQuery: Subselect not allowed in SELECT clause
• Solved: Biquery CLI error in query string Unrecognized name - when using single quotes in IN CLAUSE
• How to update partition expiration time for a partitioned table in Google Bigquery?
• How to convert string column to Timestamp in BigQuery ?
• Solved: BigQuery - Array cannot have a null element error in writing field ids
• Solved: Bigquery "Invalid schema update. Field version has changed type" error when loading data using autodetect
• Google Bigquery: Failed to parse input string "20170304" using PARSE_DATE Function
• How to solve Unrecognized name error in Google BigQuery
• How to resolve Failed to parse JSON error when loading JSON files into Google BigQuery
• Best SQL Editor for Snowflake
• Unnest first N items in a Google BigQuery Repeated Field
• How to group by hour in Google Bigquery
• Handle all integrity checks in ETL, Snowflake is too Lazy for a reason
• Grant access to database objects in a schema to a Role in Snowflake
• CREATE VIEW syntax in Snowflake
• How to switch to a Warehouse, Database, Schema using SQL query in Snowflake
• How to schedule a shell script using Google Cloud Shell in BigQuery?
• Google BigQuery - how to upsert into tables using MERGE Statement?