Versions Compared

Old Version 28

changes.mady.by.user Anand Vedam

Saved on

compared with

New Version 29

changes.mady.by.user Shilpa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Type

Field Dependency

Description

Label*

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.

Default Value: NA

Example: ELT Execute for SF

SQL Statements*

Fieldset

None.

Use this field set to define your SQL statements, one in each row. Click  to add a new row. You can add as many SQL statements as you need.

SQL Statement Editor*

String/Expression

None.

Enter the SQL statement to run, in this field. The SQL statement must follow the SQL syntax as stipulated by the target database—Snowflake, Redshift, Azure Synapse, Databricks Lakehouse Platform or BigQuery.

  • Alternatively, you can reference the SQL query from the preceding Snap's output and execute it.
    • For example, enter $__sql__ in this field with the expression button '=' enabled to reference the SQL statement, if available, in the inputSQL1 key of the preceding Snap. 


Info
titleSQL Comments are allowed

You can include inline comments and multi-line comments before, inside, or after your statement in this editor. It supports all standard SQL comment syntaxes as listed below:

-- comment text# comment text/* multi-line
comment text */		// comment text


Default Value: NA

Example: drop table base_01_oldcodes;

...