Running free-form SQL queries on clean room tables
You can enable consumers to run free - form SQL queries on selected datasets in a clean room using either the clean room API or UI. Free - form queries in the clean rooms API You can configure a clean room to allow collaborators to query…
Snowflake SQL API reference
To submit one or more SQL statements for execution, send a POST request to /api/v2/statements. You can specify that the statement should be executed asynchronously. Request syntax POST /api/v2/statements (request body) Copy Query…
SnowConvert AI - Transact SQL - Built-in functionsSystem functions
@@DBTS *to be defined @@LANGID *to be defined @@LANGUAGE *to be defined @@LOCK_TIMEOUT *to be defined @@MAX_CONNECTIONS *to be defined @@MAX_PRECISION *to be defined @@NESTLEVEL *to be defined @@OPTIONS *to be defined @@REMSERVER *to be…
Executing Multiple SQL Statements in a Stored Procedure
Accept a string parameter that is a SQL statement designed to generate rows of SQL statements to execute.Execute the input SQL statement to generate a list of SQL statements to run.Run all statements identified by the “SQL_COMMAND”…
Executing SQL statements
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 can execute multiple statements, in which case multiple result sets are returned.
Constructing SQL at runtime
A stored procedure or application can accept user input and then use that input in a SQL statement. For example, a table might store information about sales orders. An application or stored procedure might accept an order ID as input and…
Custom clean room template reference
There are two general types of templates: Analysis templates, which evaluate to a SELECT statement (or a set of SELECT operations). Activation templates, which evaluate to a SELECT statement nested inside a CREATE TABLE statement, and…
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.
Load and query sample data using SQL
Use a role to get access to functionality from granted privileges. Use a warehouse to access resources. Create a database and schema. Create a table. Load data into the table. Query the data in the table.
How to Easily Load XML with SQL Pt 2
Picking up where we left off with Part 1, with the XML data loaded, you can query the data in a fully relational manner, expressing queries with robust ANSI SQL. We can then easily issue SQL queries to gain insight into the data without…
Source