- If using Matillion Full SaaS: The component will use the cloud credentials associated with your environment to access resources.
- If using Hybrid SaaS: By default the component will inherit the agent’s execution role (service account role). However, if there are cloud credentials associated to your environment, these will overwrite the role.
Properties
- Snowflake
- Databricks
A human-readable name for the component.
Select a staging area for the data. Staging areas can be created through Snowflake using the CREATE STAGE command. Internal stages can be set up this way to store staged data within Snowflake. Selecting [Custom] will avail the user of properties to specify a custom staging area on Azure Blob Storage. Users can add a fully qualified stage by typing the stage name. This should follow the format
databaseName.schemaName.stageName.To retrieve the intended files, use the file explorer to enter the container path where the Azure storage account is located, or select from the list of storage accounts.This must have the format
AZURE://<StorageAccount>/<path>.Specify a file prefix for unloaded data on the blob container. Each file will be named as the prefix followed by a number denoting which node this was unloaded from. All unloads are parallel, and will use the maximum number of nodes available at the time.
Select the authentication method. Users can choose either:
- Credentials: Uses Azure security credentials.
- Storage Integration: Use a Snowflake storage integration. A storage integration is a Snowflake object that stores a generated identity and access management (IAM) entity for your external cloud storage, along with an optional set of permitted or blocked storage locations (Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage). More information can be found at CREATE STORAGE INTEGRATION.
The Snowflake warehouse used to run the queries. The special value
[Environment Default] uses the warehouse defined in the environment. Read Overview of Warehouses to learn more.The Snowflake database. The special value
[Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.The Snowflake schema. The special value
[Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.Select an existing table. The tables available for selection depend on the chosen schema.
Select a pre-made file format that will automatically set many of the Azure unload component properties. These formats can be created through the Create File Format component. Selecting the [Custom] file format will use the component properties to define the file format.
The unload file format. Choose from CSV, JSON, or PARQUET. Some file types may require additional formatting—this is explained in the Snowflake documentation. Component properties will change to reflect the selected file type.
Select the compression format. Available CSV and JSON formats include:
- BROTLI
- BZ2
- DEFLATE
- gzip
- NONE (no compression)
- RAW_DEFLATE
- ZSTD
- AUTO
- LZO
- NONE (no compression)
- SNAPPY
- CSV
- JSON
Specify a delimiter character to separate records (rows) in the file. Defaults to newline.
\ can also signify a newline. \\r can signify a carriage return.Specify a delimiter character to separate columns. The default character is a comma
,.A [TAB] character can be specified as \.Defaults to auto. Use this property to manually specify a date format. For more information, read the Snowflake documentation.
Defaults to auto. Use this property to manually specify a time format. For more information, read the Snowflake documentation.
Defaults to auto. Use this property to manually specify a timestamp format. For more information, read the Snowflake documentation.
Specify a single character to be used as the escape character for field values that are enclosed. Default is
NONE.Specify a single character to be used as the escape character for unenclosed field values only. Accepts common escape sequences, octal values, or hex values. Also accepts a value of NONE (default). Default is
\.If a character is specified in the “Escape” field, it will override this field.If you have set a value in the property Field Optionally Enclosed, all fields will become enclosed, rendering the Escape Unenclosed Field property redundant, in which case it will be ignored.A character that is used to enclose strings. Can be single quote (’) or double quote (”) or NONE (default). Note that the character chosen can be escaped by that same character.
Specify one or more strings (one string per row of the table) to convert to NULL values. When one of these strings is encountered in the file, it is replaced with a SQL NULL value for that field in the loaded table. Click + to add a string.
(JSON and PARQUET only) Removes trailing and leading whitespace from the input data.
When “True”, overwrite existing data (if the target file already exists) instead of generating an error. Default setting is “False”.
When True, the unload operation will work in serial rather than parallel. This results in a slower unload but a single, complete file.The default setting is False.When True, no file extension is used in the output filename (regardless of the file type, and regardless of whether the file is compressed).When False, a filename prefix must be included in the path.
The maximum size (in bytes) of each file generated.The default is 16000000 (16 MB). The maximum size is 5000000000 (5 GB).For more information, see the Snowflake documentation.
When “True”, write column names as headers at the top of the unloaded files. Default is “False”.