Input 

Document

• Min: 1

• Max: 1

• ELT Transform

• ELT Copy

Details of the required view such as view name, names of the columns that are to be included in the view

Output

Document

• Min: 1

• Max: 1

• ELT Copy

• ELT Intersect

A SQL query for the table in the view specified in the Snap.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

• Stop Pipeline Execution: Stops the current pipeline execution if the Snap encounters an error.

• Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

• Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Label*

Default Value: ELT Create View
Example: ELT view query

String

None

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Get preview data

Default Value: Not selected
Example: Selected

Checkbox

None

Select this checkbox to include a preview of the query's output. The Snap performs limited execution and generates a data preview during Pipeline validation.

The number of records displayed in the preview (upon validation) is the smaller of the following:

• Number of records available upon execution of the SQL query generated by the Snap.

• The value set in the Preview Data Count setting (default is 50 records).

Database Name

Default Value: None
Example: Redshift

String/Expression

N/A

The name of the database in which the target/source tables are located. Leave it blank to use the database name specified in the account settings.

If your target database is Databricks Lakehouse Platform (DLP), you can, alternatively, mention the file format type for your table path in this field. For example, DELTA, CSV, JSON, ORC, AVRO. See Table Path Management for DLP section below to understand the Snap's behavior towards table paths.

Schema Name (Not applicable to Databricks Lakehouse Platform)*

Default Value: N/A
Example: PUBLIC

String/Expression

N/A

The name of the database schema. In case it is not defined, then the suggestion for the table name retrieves all tables names of all schema in the specified database (except for DLP) when you click .

Target View Name*

Default Value: N/A
Example: PUBLIC.EMPLOYEES `/mnt/elt/emp`

String/Expression

N/A

The name of the view in which you want to build the SQL queries. In case it is not defined, then the Snap retrieves all view names associated with the specified schema from the suggestions.

Target View Action*

Default Value: N/A
Example: PUBLIC.EMPLOYEES `/mnt/elt/emp`

Dropdown

N/A

Select the action to perform on the target view. Options available are:

• Error if the view already exists: The Snap immediately errors out if the view already exists. Otherwise it will proceed forward in creating the view

• Drop and Create view: The Snap attempts to drop the view that already exists. If there is no such view, it will move forward and create the view

• Do not error if the view already exists: The Snap does not create the view if it already exists, otherwise goes ahead and creates the view

View Column Names

Default Value: Error if the view already exists
Example:  Drop and Create a view

This field set enables you to specify the names of the column to be used. Specify each value in a separate row. Click + to add a new row. You must specify all the columns.

View Column Name

Default Value: N/A
Example: EMP_ID_NEW

String

None

Enter the column name to be used for a view.

Database cannot be blank.

(when seeking the suggested list for Schema Name field)

Suggestions in the Schema Name and Target Table Name fields do not work when you have not specified a valid value for the Database Name field in this Snap.

Specify the target Database Name in this Snap to view and choose from a suggested list in the Schema Name and Target Table Name fields respectively.

Database encountered an error during preview processing

(Target CDW: BigQuery)

This can happen when the target database cannot recognize/interpret the table name.

Ensure that the table name is valid and the table with provided name exists. Using a wildcard in the SQL editor mode, ensure that the table name is enclosed between backticks (`). For example: `scd*`, `mode*`.