Versions Compared

Key

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

...

Field Name

Field Type

Description

Label*

Default ValueSnowflake - Lookup
Example: Load Lookup Employee Tables

String

Specify 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.

Schema name


Default Value: N/A
Example: schema_demo

String/Expression

Specify the database schema name. In case it is not defined, then the suggestion for the Table Name will retrieve all table names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values.

The values can be passed using the pipeline parameters but not the upstream parameter.

Table name*

 

Default Value: N/A
Example: employees_table

String/Expression

Enter or select the name of the Snowflake SQL table to execute the lookup query.

The values can be passed using the pipeline parameters but not the upstream parameter.

Output fields

Default Value: N/A
Example: ID

String/Expression

Enter or select output field names for the Snowflake SQL SELECT statement.

Lookup conditions*

Use this field set to enter or select the lookup column name.

Value*

Default Value: N/A
Example: $email

String/Expression

Enter or select the JSON path of the lookup column value. The value will be provided by the input data field. 


Lookup column name*

Default Value: N/A
Example: $email

String/Expression

Specify the lookup conditions are created by using the lookup column name and the lookup column value. Each row will build a condition, such aslookupColumn1 = $inputField. Each additional row will be concatenated using a logical AND. All rows together build the lookup condition being used to look up records in the lookup table.

Pass-through on no lookup match

Default ValueDeselected

Checkbox

When there is no lookup matching an input document, the input document will pass through to the output view if this property is checked. Otherwise, it will be written to the error view as an error condition.

Number of Retries

Default Value0
Example: 3

Integer/Expression

Specify the maximum number of retry attempts when the Snap fails to read.

Minimum value: 0

Retry Interval (seconds)

Default value: 1
Example: 3

Integer/Expression

Specifies the minimum number of seconds the Snap must wait before each retry attempt.

Minimum value: 1

Input Date Format

Default ValueContinue to execute the snap with given input Date format
Example: Auto Convert the format to Snowflake default format

Dropdown list

The property has the following two options:

  • Select Continue to execute the snap with the given input Date format if you want the Snap to continue with the current date format. This option is selected by default. 

  • Select Auto Convert the format to Snowflake default format if you want the Snap to convert the provided date format to the default Snowflake date format. To know about the date formats supported by Snowflake, see Snowflake date formats

Handle Timestamp and Date Time Data

Default ValueDefault Date Time format in UTC Time Zone
Example: SnapLogic Date Time format in Regional Time Zone

Dropdown list

Specify how the Snap must handle timestamp and date-time data. The available options are:

  • Default Date Time format in UTC Time Zone: The Snowflake date time data are represented in UTC Time Zone.

  • SnapLogic Date Time format in Regional Time Zone: The Snowflake date time data are represented in the same regional time zone value, as provided in the Snowflake account.

Multiexcerpt include macro
nameTimestamp_recommendation
pageSnowflake - Execute

Manage Queued Queries

Default Value: Continue to execute queued queries when the Pipeline is stopped or if it fails
Example: Cancel queued queries when the Pipeline is stopped or if it fails

Dropdown list

Select this checkbox an option to determine whether the Snap should continue or cancel the execution of the queued Snowflake Execute SQL queries when you stop the Pipelinepipeline.

If you select Cancel queued queries when the pipeline is stopped or if it fails, then the read queries under execution are canceled, whereas the write queries under execution are not canceled. Snowflake internally determines which queries are safe to be canceled and cancels those queries.

Snap Execution

Default Value: Validate & Execute
Example: Execute only

Dropdown list

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

...