Learn Cloud Datawarehousing - copycoding.com community

Difference between Numeric vs Float datatype in Google Bigquery
npack 1d
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 3d
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 3d
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 3d
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
npack 8d
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
npack 11d
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 20d
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 20d
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
npack 20d
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 26d
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 26d
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 27d
Snowflake pro certification
Sasaljun 28d
Did any one do snowflake pro certification?
Best Practices for Schema / Roles / Grants on Snowflake
thendreks 31d
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 36d
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 37d
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 37d
How does snowflake handles large data updates considering a fact multiple virtual warehouses are cre
Types of tables in snowflake
Suresh972 38d
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 41d
There are instances where you want to schedule a query in bigquery and save its results into a table
How to clone a database object along with the existing grants of the underlying table in Snowflake ?
AzharuddinK 41d
I have a requirement where i need to clone tables for backup purposes. Once i create a clone i need
Granting Access to a Role on newly created schema's automatically without manual intervention
nekkanti009 43d
I have a role created in snowflake and would like to grant all privilege on existing schemas in a da
BigQuery error in load operation: Too many total leaf fields: 27500
victor 43d
The Maximum columns per table value that bigquery supports is 10,000 which means that the error mess
Google Bigquery: An internal error occurred and the request could not be completed
victor 43d
Users frequently have reported the below error message:
How to Select Distinct values in Google Bigquery ?
victor 43d
How to run a query to find distinct values:SELECT DISTINCT c
How to use parameterized Views in Snowflake?
dan-irving 43d
Can we use Parameterized Views in Snowflake. Such as pass the table name or database name as paramet

Cloud Data Warehousing Community 🚀