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

Description

Used for running queries on a MySQL database. Can output results in JSON or CSV format to S3 or SFTP. Uses the task execution system to keep track of ranges and batches.

Purchasing Options

everything plan - $0.0 / day

Available Actions

Run SQL Steps with date params

Execute sql steps as stored in the tracking database

Variables

target_db required

Database where you want to run the script on.


sql_steps required

Single step to be run. Treated as one statement regardless of ;


user_params

If in your sql you use any parameters then you need to create a parameter list here. To use ranges visit ...



Run SQL Steps with int params

Execute sql steps as stored in the tracking database

Variables

target_db required

Database where you want to run the script on.


sql_steps required

Single step to be run. Treated as one statement regardless of ;


user_params

If in your sql you use any parameters then you need to create a parameter list here. To use ranges visit ...



Export data with date params

Export data from MySql database to a target location

Variables

target_db required

Database where you want to run the script on.


sql_steps required

Single step to be run. Treated as one statement regardless of ;



user_params

If in your sql you use any parameters then you need to create a parameter list here. To use ranges visit ...





file_path required

File Path to a location where data files will be exported, not including filename



Export data with int params

Export data from MySql database to a target location

Variables

target_db required

Database where you want to run the script on.


sql_steps required

Single step to be run. Treated as one statement regardless of ;


user_params

If in your sql you use any parameters then you need to create a parameter list here. To use ranges visit ...






file_path required

File Path to a location where data files will be exported, not including filename