SQL Steps are colored blue. They are used to trigger the SQL scripts that are used to prepare data sets.

SQL Steps can draw their scripts from SQL Explorer or from code repositories. 

If a script is drawn from a repository, the step also specifies the Docker image that will be used to create the container environment where the script can be executed.


Contents


Selecting an SQL Query Step

When creating or editing a Workflow, click the 'Plus' icon and choose SQL Query.


Step Configuration

Step Name

The name must be unique within the workflow you are creating.

Only alphanumeric characters, hyphens, underscores and dots (.) are allowed.

The name must start and end with a letter.


Source

The SQL source can be taken from Peak’s SQL Explorer or a repository.


SQL Query

Choose a saved SQL query from the drop-down list.


Dependency

Select any steps that must be completed successfully before this step can run.