Learn Cloud Datawarehousing - copycoding.com community

Bigquery Simba ODBC Driver: Error interacting with REST API The user does not have bigquery.datasets.create permission in project
npack 13d
When you configure the Simba ODBC drivers for Google bigquery and execute a SQL Query for the first
Is there a way to create objects in snowflake and other users automatically get privileges to modify obj's with schema owner role?
nekkanti009 16d
I know that using role hierarchy we can create on standard role for a schema and that role can be gr
I'm new to snowflake and started learning it. please someone guide me to get through snowpro certification.
nprakash586 24d
It would be great help, if someone guide me where can i find learning material for this.
Need to convert this hh:mm:ss data into seconds. Is there any function available in snowflake ?
AzharuddinK 27d
So i have a requirement to convert the below datetime format to seconds all together (10 hours 29 mi
Deleting Duplicate Rows from a table
AzharuddinK 32d
Can someone help me with snowflake query to identify the entire duplicate rows and just keeping one
Does Snowflake Warehouse needs to be modeled? Is the Dimension modeling still relevant in Snowflake?
dammalapatisree 32d
My organization is migrating from a traditional warehouse and migrating(building from scratch) to Sn
BigQuery ROW_NUMBER Order by Error: Resources exceeded during query execution: The query could not be executed in allotted memory
npack 33d
Error Message: Resources exceeded during query execution: The query could not be executed in the all
CREATE MATERIALIZED VIEW Syntax in Snowflake
npack 52d
Materialized views helps improve performance by pre-calculating and storing the results.
How to create a materialized view with a view definition of flattening nested json
nekkanti009 52d
Hi there - I am trying to create a materialized view to improve performance of a query in snowflake
Update table definition in Snowflake
KRISTIM 55d
Difference between Numeric vs Float datatype in Google Bigquery
dan-irving 68d
Google bigquery offers three datatypes to store numbers / amounts - INT64, FLOAT64 and NUMERIC. As
While setting up Initial Snowflake Environment, single vs multiple Accounts- Architecture Best practices
npack 70d
You decided Snowflake to be your new cloud data warehouse. You are tasked with designing the system.
Identity or Auto Increment columns in Snowflake. How to handle them while migrating
npack 70d
You might have heavily used Identity columns and when you want to migrate your data to Snowflake, Ta
How to get Rowcount or Activitycount inside Snowflake Stored procedure
npack 70d
Stored procedures have complex processing logic. We can put a bunch of sql or procedural commands in
How to Choose the right cloud data warehouse for your company - The Ultimate Checklist
victor 74d
Information is wealth. Today, less than 0.5% of data is actually being used, and businesses lose ove
Understanding Google BigQuery Pricing - The ultimate guide to querying the cloud without burning your wallet
DataFreak 77d
Google big query is the cloud native data warehouse fully managed by Google. Bigquery is fast, effic
How to convert a timestamp/date/datetime to a different timezone in Google BigQuery
dan-irving 87d
Google Bigquery runs on UST Clock. For any data insert or update, Bigquery considers the date or tim
Google Bigquery Partitioning a table - Best practices
victor 87d
Bigquery uses partition keys to prune a table. It helps you reduce the amount of data scanned, which
Bigquery : Too many partitions produced by query, allowed 2000, query produces at least xxx partitions
Mike-Barn 87d
Partitioning allows you to effectively prune a table and also bring down the querying costs in Bigqu
Is there a way to identify tables that were created by cloning in the database ?
AzharuddinK 93d
Want to get a list of tables which were created in the Snowflake database using the clone command.
new to Snowflake
rahul-rkdf09-gmail-com 93d
Hello Guys,
I believe snowflake stores data internally on S3, I heard in one of the videos, anyone happen to have a documentation link for it?
vjcloud 93d
Snowflake pro certification
Sasaljun 95d
Did any one do snowflake pro certification?
Best Practices for Schema / Roles / Grants on Snowflake
thendreks 97d
Does anyone have a list of best practices for creating initial schemas, databases, roles, permission
Loading large volume of data into Snowflake using ODBC / JDBC
npack 103d
We all have our own favorite ETL Tools (SSIS, Informatica, Abinitio, Datastage). While using these t

Cloud Data Warehousing Community 🚀