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




Description

Execute SQL Steps against a Firebolt database.


Purchasing Options



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 on.

sql_steps required

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

user_params

Parameters to use in your SQL Script, if any. Refer to slide out help for more information.

start_firebolt_engine required

Enable to start up the Firebolt engine prior to running the SQL Script.

stop_firebolt_engine required

Enable to shutdown the Firebolt engine after running the SQL Script.


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_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.


Run SQL Script with Integer Parameters

Execute an SQL Script with the integer range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Script on.

sql_steps required

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

user_params

Parameters to use in your SQL Script, if any. Refer to slide out help for more information.

start_firebolt_engine required

Enable to start up the Firebolt engine prior to running the SQL Script.

stop_firebolt_engine required

Enable to shutdown the Firebolt engine after running the SQL Script.


Range
range_start_point required

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

range_end_point_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

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