Querying a semantic view
Preview Feature — Open Available to all accounts. Privileges required to query a semantic view If you are using a role that does not own the semantic view, you must be granted the SELECT privilege on that semantic view to query that…
How to Register in the Snowflake Community
Go to https://community.snowflake.com/CommunitiesSelfReg, the page should look like this: Enter an email of your choice. If you have an existing Snowflake account, we recommend using the same email.
Approximate credit used by individual users in reader accounts
ISSUE: Fetch consolidated credit consumption details for individual users of all reader accounts from provider account.
Cortex Analyst Verified Query Repository
The Cortex Analyst Verified Query Repository (VQR) can help improve the accuracy and trustworthiness of results by providing a collection of questions and corresponding SQL queries to answer them.
Number of Micro-partitions on a table changes with warehouse size
FAQ: The total number of Micro - partitions for the same set of data is affected by warehouse size. As the warehouse size increases the number of micro - partitions also increases.
How To: Comment or uncomment multiple lines in the SQL Worksheet
Press CMD + / (Mac) or CTRL + / (Windows). The highlighted lines are commented out.
How to convert your input data to UTF- 8 before sending it to Snowflake
Snowflake supports three binary formats or encoding schemes: hex, base64, and UTF - 8. Snowflake requires that incoming data files use this encoding. Attempting to load files into Snowflake tables that do not comply with these can result…
DIV0 and DIV0NULL: Change to results exceeding the output scale
Before the change: DIV0 and DIV0NULL truncate the result to 0.555555, while the division operator rounds up the result to 0.555556.
Auto-Clusterting Jobs failing with error: (507003) Please check if the proper privileges and ownership is set up for the table
CAUSE: The issue occurs when the OWNER of the table doesn't have USAGE or OWNERSHIP privilege on the Schema and Database that contain the table.
SnowConvert: Teradata SQL to Snowflake Scripting (Procedures)
Teradata’s ABORT and ROLLBACK statements are replaced by a ROLLBACK statement in Snowflake Scripting. For more information on Teradata ABORT and for ROLLBACK.