Source
Custom instructions in Cortex Analyst
Custom instructions let you have greater control over SQL generation. Using natural language, you can tell Cortex Analyst exactly how to generate SQL queries from within your semantic model YAML file.
Listing manifest reference
Creating Snowflake listings programmatically requires a manifest, written in YAML (https://yaml.org/spec/).
Error when trying to add data product to the listing using a custom role: "Failed to create secure share. Please try again. SQL access control error: Insufficient privileges to operate on account <account locator>".
ISSUE: - ACCOUNTADMIN role is able to add data product to the listing created by them. - Custom role is able to create the listing but is not able to add the data product to the listing created by them.
How to utilize current user function with email-formatted user names
ISSUE: The system function CURRENT_USER when used in a security policy may not work as expected if user names are in email format (include embedded @). Error may be of the form: "SQL compilation error: Object does not exist, or operation…
Organization listing manifest reference
As a provider, you can use organizational listings to share data products securely within your organization. A manifest, written in YAML (https://yaml.org/spec/), is required to create organization listings programmatically.
Custom budgets
Custom budgets let you monitor compute costs for a custom group of objects.
Custom attributes in the Internal Marketplace
Custom attributes allow organizations to centrally define standardized metadata fields that all providers can use when publishing internal data products in the Internal Marketplace. These attributes function as configurable fields that…
Oracle - PL/SQL to Javascript
This is a translation reference to convert PL/SQL statements to snowflake JavaScript Collections & Records NoteSome parts in the output code are omitted for clarity reasons.
Oracle - PL/SQL to Javascript
This is a translation reference to convert PL/SQL statements to snowflake JavaScript Collections & Records NoteSome parts in the output code are omitted for clarity reasons.