You can't use this until you register with us!

Description

Execute an SQL Query or Script against a Snowflake database.

Purchasing Options

Snowflake SQL Runner - $49.99 / month

Available Actions

Run SQL Script with Date Parameters

Execute an SQL Script with the date range parameters specified.

Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Script to run. Statements are separated by a semicolon.

user_params required

Parameters to use in your SQL Query or Script, if any.


Range
range_start_point required

Datetime stamp where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point

Datetime stamp where the processing of your sequentially sorted data should end. Leave this field blank to process all records with a Datetime stamp after the starting point.

range_end_point_query

SQL Query to use to determine the end point of the data to process. Leave this field blank to process all records with a Datetime stamp after the starting point.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.