When you add an SQL transformation to the mapping, on the SQL tab, you define the database connection SQL type and query type that the transformation processes.

You can choose to use a parameterized connection in an SQL transformation. You can also override the values defined in a parameter file at runtime.

To use a parameterized connection in an SQL transformation, first create an SQL transformation in a mapping that uses a valid connection. Then, parameterize the connection in the SQL transformation. You can also use an SQL transformation to read from Java or SQL user-defined functions (UDF) in Databricks Delta

You can use an SQL transformation to process SQL statements using a SQL query. You can configure an SQL transformation to process an entered query that you define in the SQL editor. Do not use more than one SQL query in an SQL transformation.

The SQL transformation processes the query and returns the rows. The SQL transformation also returns any errors that occur from the underlying database or if there is an error in the user syntax. You must use the same connection type for the Source transformation and SQL transformation to run the SQL transformation.

For more information about SQL queries, see

Transformations

in the Data Integration documentation.