Learn Cloud Datawarehousing - copycoding.com community

How to Upload a CSV file to Bigquery Table using the Web User Interface
npack 8h
You can directly load a CSV file from your Laptop / Desktop / GCS Bucket directly into a Bigquery t
How to find the number of occurences of a string in a string column in Bigquery
npack 8h
How to find how many times "Jazz" appears in "JazzbuzzJazz" string in Bigquery using SQL. The outpu
Bigquery Error: No matching signature for function CONCAT for argument types. Supported signatures: CONCAT
npack 9h
How do i select bottom n rows in snowflake
Gattu-Bhavani 19h
Bigquery error - Subquery of type IN must have only one output column
npack 19d
Bigquery allows only one column as part of the subqueries. If you have more than one column, for ex
Google Cloud Professional Data Engineer Certification Exam - Study guide and Practice tests
npack 19d
I cleared the Professional Data Engineer Certification recently and the question topics are fresh i
Aws RDS to snowflake incremental load
Zohaib 24d
What can I use for incremental load from AWS RDS to snowflake and then load the changed data into f
Snowflake Trial Account
snowflake-user 30d
Does Snowflake lets you create a second trial account using the same credentials as the first trial
Any idea if snowflake have triggers
Prakash-Mohan 43d
How to count distinct values over multiple columns using SQL
npack 53d
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 58d
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 64d
How to rename a column name in Google Bigquery table - with Examples
npack 65d
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 68d
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 68d
Often, we have array datatypes and want to remove the duplicates (often called as dedup) and find o
Why bitmap index in DWH
rajneesh4u 79d
Could you share sample projects we can download and try hands on
chandra123bm 84d
How to rename a table in Google Bigquery ?
npack 84d
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 86d
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 86d
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 86d
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 89d
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 89d
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 89d
How to trim and display only 4 digits / decimal places in Bigquery Numeric ?
npack 90d
BigQuery supports a FORMAT() function for formatting strings. This function is similar to the C pri

Cloud Data Warehousing Community 🚀