Learn Cloud Datawarehousing - copycoding.com community

List all tables, database, schema in entire Snowflake account
IronBat89 1d
I tried with below approach to find list of all schema in entire account but its not returning all
Create Primary Key command syntax in Snowflake
npack 2d
You can create a Primary key on a Snowflake Table. But, they are not enforced. However, constraints
Create Foreign Key command syntax in Snowflake
npack 2d
You can create the foreign key while creating tables on the Snowflake cloud data warehouse. But, fo
Insert LAST_QUERY_ID value while inserting data in a table via stored proc in Snowflake
snowflake-user77 4d
Hi All,
Data Warehousing 101 free web-book: Refresh and strengthen your data warehouse knowledge
npack 7d
Free Web-book with clear explanations on Data Warehousing Concepts. Have packed my 10+ years of work
Manage Grants privilege to a role at Database Level
nekkanti009 8d
Hello there - I was just looking if there is a way we can grant "Manage Grants" Privilege to a role
Snowflake Training
vgunda2 19d
Any institute or individual in India or any location that offers snowflake training?
Microsoft Power BI to instantiate a Snowflake session and access Snowflake using single sign-on (SSO)
karthikv 21d
Can you guys explain the above query.I cannot understand in snowflake documentation.Give me some exa
How to set an Alert on Snowflake storage utilization
karthikv 26d
Suppose If the table has been truncated.We can restore the table using time travel.In that case Time
How to find list of Schemas in Snowflake
npack 27d
You can use the below query to get the list of all the Schemas in Snowflake:
Undersized Warehouse/cluster that are incurring too much query time in Snowflake
karthikv 28d
How to identify undersized virtual warehouse or cluster in snowflake.
A role is automatically getting DML privileges for tables under a schema even though the current and future privileges are revoked
nekkanti009 32d
There is a role (XYZ) whose select/insert/delete/update/truncate privileges were revoked for both c
How to import /integrate SQL Server database BACPAC dump file into Snowflake.
anu09sha 32d
File has an extension of .bacpac and currently it is stored in AWS S3 bucket.
How to migrate from Teradata to Snowflake?
moyeenbasha 33d
Hi all, We have one requirement where we have to migrate the existing Teradata to Snowflake, below i
How to find the List of databases in Snowflake
npack 35d
You can use the below query to get the list of all the databases in Snowflake:
How can we convert Informatica Mapping to Snowsql queries.
anu09sha 36d
We have a requirement where we are migrating to Snowflake datawarehousing, so our project is a need
Bigquery Simba ODBC Driver: Error interacting with REST API The user does not have bigquery.datasets.create permission in project
npack 63d
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 66d
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 74d
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 77d
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 82d
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 83d
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 83d
Error Message: Resources exceeded during query execution: The query could not be executed in the all
CREATE MATERIALIZED VIEW Syntax in Snowflake
npack 102d
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 103d
Hi there - I am trying to create a materialized view to improve performance of a query in snowflake

Cloud Data Warehousing Community 🚀