List all tables within a select statement in Snowflake
I have query in Snowflake that is near a thousand line. Is there a way to easily see what tables are accessed to easily list it? This will need to be done for many files, so if there is a quick & easy way to list all the tables it would be wonderful.
Snowflake Notebook fails with NotebookSqlException: 000710 (02000): Result for query has expired
We are currently evaluating the new Notebook feature for our BI needs. So far, we are loving it, but we experience some issues. Maybe the Snowflake community can help!
What is SIGMA_WRITE into Snowlake Queries History?
please tell me what SIGMA_WRITE is in Snowlake Queries History.
Database roles with access to Account_Usage view in Snowflake
I am trying to share the data of SNOWFLAKE.ACCOUNT_USAGE view with roles that are not ACCOUNTADMIN. I do not want to grant them ACCOUNTADMIN privileges.
So, as per the Snowflake documentation, I tried exploring database roles. As per the Snowflake documentation https://docs.snowflake.com/en/sql-reference/snowflake-db-roles “ACCOUNT_USAGE schemas have four defined SNOWFLAKE database roles, each granted the SELECT privilege on specific views.”
Database roles with access to Account_Usage view in Snowflake
I am trying to share the data of SNOWFLAKE.ACCOUNT_USAGE view with roles that are not ACCOUNTADMIN. I do not want to grant them ACCOUNTADMIN privileges.
So, as per the Snowflake documentation, I tried exploring database roles. As per the Snowflake documentation https://docs.snowflake.com/en/sql-reference/snowflake-db-roles “ACCOUNT_USAGE schemas have four defined SNOWFLAKE database roles, each granted the SELECT privilege on specific views.”
Can’t use a declared variable in Snowflake’s SQL
I’m successfully executing the following script:
Merge rows from source dynamic table to destination static table only if the destination doesn’t have the source row based on a column?
I have a huge dynamic source table that is continually getting populated with new data. In it there’s an ID column whose value can appear over multiple rows over time in the source dynamic table.
Merge rows from source dynamic table to destination static table only if the destination doesn’t have the source row based on a column?
I have a huge dynamic source table that is continually getting populated with new data. In it there’s an ID column whose value can appear over multiple rows over time in the source dynamic table.
Merge rows from source dynamic table to destination static table only if the destination doesn’t have the source row based on a column?
I have a huge dynamic source table that is continually getting populated with new data. In it there’s an ID column whose value can appear over multiple rows over time in the source dynamic table.
Merge rows from source dynamic table to destination static table only if the destination doesn’t have the source row based on a column?
I have a huge dynamic source table that is continually getting populated with new data. In it there’s an ID column whose value can appear over multiple rows over time in the source dynamic table.