Learn Cloud Datawarehousing - copycoding.com community

Deleting Duplicate Rows from a table
AzharuddinK 3d
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 4d
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 4d
Error Message: Resources exceeded during query execution: The query could not be executed in the all
CREATE MATERIALIZED VIEW Syntax in Snowflake
npack 23d
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 24d
Hi there - I am trying to create a materialized view to improve performance of a query in snowflake
Update table definition in Snowflake
KRISTIM 26d
Difference between Numeric vs Float datatype in Google Bigquery
dan-irving 39d
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 41d
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 41d
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 41d
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 46d
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 49d
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 58d
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 58d
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 58d
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 64d
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 64d
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 65d
Snowflake pro certification
Sasaljun 66d
Did any one do snowflake pro certification?
Best Practices for Schema / Roles / Grants on Snowflake
thendreks 69d
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 74d
We all have our own favorite ETL Tools (SSIS, Informatica, Abinitio, Datastage). While using these t
Grant a DBA Role, all the required privileges across schemas without granting sysadmin or account admin access in Snowflake?
nekkanti009 75d
Is there a way to grant development privileges to one role (Role_Dev) in a snowflake database with w
How does snowflake handles large data updates with data pointers and concurrent reads ?
vjcloud 75d
How does snowflake handles large data updates considering a fact multiple virtual warehouses are cre
Types of tables in snowflake
Suresh972 76d
Can some one briefly explain the types of tables???? The differences
How to set up a destination table for a scheduled query in Google Bigquery
npack 79d
There are instances where you want to schedule a query in bigquery and save its results into a table

Cloud Data Warehousing Community 🚀