Skip to main content

SQL Transform Tool

The SQL Transform tool enables you to write and execute custom SQL queries directly within your workflow. It allows seamless access to data from an upstream tool/node using the alias upstream, making it easy to reference input data in your queries.

Before using the SQL Transform tool, ensure that Enable LiveQuery option is turned on:

  1. Navigate to Designer Cloud > Options.

  2. Verify that Enable LiveQuery is enabled.

Using the SQL Transform Tool

  1. Select SQL Transform from the Developer tools menu.

  2. Write your SQL query in the query box on the right side. Use upstream as the table name to reference input data, for example SELECT "column_name" FROM upstream;.

  3. Select the Execute button to run your SQL command.

Tip

Use built-in and custom CDW functions or UDFs to enhance your queries

Limitations

Data manipulation commands (UPDATE, INSERT, etc.) are not supported.

In this section: