Learn Cloud Datawarehousing - copycoding.com community

Any idea if snowflake have triggers
Prakash-Mohan 4d
How to count distinct values over multiple columns using SQL
npack 14d
Often we want to count the number of distinct items from this table but the distinct is over multip
Awesome, free Data tools for SQL Developers and Data Engineers
npack 19d
Often we do lot of mundane data tasks in SQL and we are so used to it, that we dont even look for
How to load XML file from s3 to snowflake
karthikv 25d
How to rename a column name in Google Bigquery table - with Examples
npack 26d
Bigquery doesnt support altering table definitions, But it does allow you to replace tables. You ca
Execute Dynamic SQL Queries with EXECUTE IMMEDIATE in Bigquery - with Examples
npack 29d
Construct queries dynamically on the fly and execute them in Bigquery using EXECUTE IMMEDIATE. With
How to find DISTINCT values in a ARRAY in Bigquery
npack 29d
Often, we have array datatypes and want to remove the duplicates (often called as dedup) and find o
Why bitmap index in DWH
rajneesh4u 40d
Could you share sample projects we can download and try hands on
chandra123bm 45d
How to rename a table in Google Bigquery ?
npack 46d
BigQuery does not allow you to rename a table name or a column name. The only option is to take a c
How to do Case Insensitive Sorting (order by) in Google Bigquery
npack 47d
Bigquery is case-specific. There is no option / setting to make it to ignore case while sorting dat
How to do Case Insensitive compare in Google Bigquery ?
npack 47d
Bigquery is casespecific. There is no option / setting to make it to ignore case while doing data c
IDENTITY or AUTO_INCREMENT columns in Google BigQuery
npack 47d
We often use column functions like AUTO_INCREMENT, SERIAL, IDENTITY or sequence, Is there an equiva
How to Export Table Data to a File in Google BigQuery
victor 50d
You can download small datasets into your laptop directly from the WebUI for small tables (usually
Bigquery Table too large to be exported to a single file. Specify a uri including a * to shard export
npack 50d
When trying to export a BigQuery Table from Web UI to Google Storage bucket, You get the below erro
Cannot enable SSL for the connection TLS 1.2 Error in Big Query using Simba ODBC Driver
dan-irving 50d
How to trim and display only 4 digits / decimal places in Bigquery Numeric ?
npack 51d
BigQuery supports a FORMAT() function for formatting strings. This function is similar to the C pri
How to truncate after 4 digits / decimal places in Bigquery Numeric columns ?
npack 51d
There is no Decimal datatype in BigQuery. You will have to use NUMERIC. And there is no way to spec
How to round up to 4 digits after decimal point in Bigquery ?
npack 51d
There is no Decimal datatype in BigQuery. You will have to use NUMERIC. And there is no way to spec
REGEXP_MATCH function equivalent in Google BigQuery SQL
npack 53d
You will get, Error: Function not found: REGEXP_MATCH. The alternative / equivalent to REGEXP_MATCH
Calculating Running Total with OVER Clause in SQL - Bigquery / Snowflake / Teradata
npack 53d
You often come across scenarios where you have to calculate a running total of a quantity. A runnin
Any general guidelines to allocate table space quota to different layers in ETL?
rajneesh4u 53d
DefaultCredentialsError: Setting GOOGLE_APPLICATION_CREDENTIALS for BigQuery Python CLI
npack 54d
When trying to connect to Bigquery from your Python program, you may encounter the below error mess
Find all Table columns, datatype and metadata information in Google BigQuery using Information Schema
npack 54d
We often want to find column names of a table (table metadata) in Bigquery, like the list of all th
How to Add New Columns to a Table in Google BigQuery
npack 54d
If you have to add a new column to a table in Google Bigquery, you can use one of the below methods

Cloud Data Warehousing Community 🚀