Search

Amazon Redshift Connectors

Amazon Redshift Connectors

Back Next

SQL query

SQL query

You can configure an SQL transformation to process an entered query that you define in the SQL editor. The SQL transformation processes the query and returns the rows. The SQL transformation also returns any errors that occur from the underlying database or the user syntax.

You can process an entered query to call a stored procedure that returns a value or no values.

The following image shows an entered query in a SQL transformation:

Select the SQL Type as SQL Query and select the Query Type as Entered Query.

Consider the following rules and guidelines for SQL queries:

You cannot use the saved query type in an SQL transformation.

You can specify only a single query in an entered query. Do not specify multiple queries.

Do not use the COMMIT, ROLLBACK, and EXPLAIN PLAN statements in an entered query.

For more information about SQL queries, see

Transformations

in the Data Integration documentation.

SQL transformation

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.