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




Description

Execute an SQL Query or Script against a Snowflake database.



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_data_offset

Fixed amount to adjust the Next Run Start Point.

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.

process_increment required

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