Source
ASOF JOIN
An ASOF JOIN operation combines rows from two tables based on timestamp values that follow each other, precede each other, or match exactly. For each row in the first (or left) table, the join finds a single row in the second (or right)…
snow sql
Executes Snowflake query. Use either query, filename or input option. Query to execute can be specified using query option, filename option (all queries from file will be executed) or via stdin by piping output from other command.
Executing SQL statements
To execute an ad - hoc query, run a command similar to the following: snow sql - q "SELECT * FROM FOO" Copy To execute a file containing a SQL query, run a command similar to the following: snow sql - f my_query.sql Copy The snow sql command…
Migrating from SnowSQL to Snowflake CLI
Install Snowflake CLI with your preferred method. Import your connections. Optionally check for suggested changes for your environment variables. Optionally create an alias that maps the snowsql shell command to the snow sql shell command.
Working with Materialized Views
A materialized view is a pre - computed data set derived from a query specification (the SELECT in the view definition) and stored for later use. Because the data is pre - computed, querying a materialized view is faster than executing a query…
Snowsight Dashboard: <USER> will only be able to view query text because they don’t have <ROLE>
ISSUE: We have a Snowsight dashboard whose session context is using a specific role (eg. ROLE1). After sharing the dashboard with a user (eg. USER1) who has been granted the ROLE1, the user is not able to see the dashboard when navigating…
Configure Snowflake Open Catalog to use SSO
Feature — Generally Available Not available in government regions. This topic shows you how to configure Snowflake Open Catalog to use SAML - based SSO.
Configure key pair authentication in Snowflake Open Catalog
With key pair authentication, you can allow a user programmatic access to Open Catalog for various custom roles with permissions on the appropriate catalogs. For example: ANALYST custom role: Can only access catalogA. ENGINEER custom role:…
Using SnowSQL
Opens up a text editor. Useful for writing longer queries.
How to monitor activity from specific IP addresses in your Snowflake account
FAQ: The following views in the SNOWFLAKE.ACCOUNT_USAGE schema can be queried to retrieve information about login events, sessions, queries, and activity in your Snowflake account from specific IP…