Source connection - Parameter, Allow parameter to be overridden at run time

Source type - Single object, multiple objects, query, and parameter. You can also use a parameter file to override the Snowflake source connections and objects in a mapping from the mapping task.

Allow parameter to be overridden at run time.

Query options - Filter and Join. You can use both simple and advanced filter conditions. You can use join to join related objects based on existing relationships or you can create an advanced relationship.

Database

Schema

Table name

SQL override

Source connection parameter

Source Type - Single, parameter

Format - Delimited, Avro, ORC, Parquet, and JSON

Source Type - File and directory

Folder Path

File Name

Compression Format - Gzip

Source connection, connection parameter

Source Type - Single, parameter

Format - Delimited, Avro, ORC, Parquet, and JSON

Formatting Options

Filesystem Name Override

Source Type - File and directory

Directory Override - Absolute path; Relative path

File Name Override - Source object

Compression Format - Gzip to read flat files