Alter External Table
The Alter External Table component enables users to add or remove files from an external table to increase control over an external table's source data. To learn more about the command, read ALTER EXTERNAL TABLE.
The following file types are supported:
- AVRO
- CSV
- JSON
- ORC
- PARQUET
Properties
Name = string
A human-readable name for the component.
Database = drop-down
The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Schema = drop-down
The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Target Table = drop-down
The external table to alter.
Action = drop-down
The alteration action to perform on the files specified in File List.
- Add: Adds the specified file to the external table metadata. This is the default setting.
- Remove: Removes the specified file from the external table metadata.
File List = dual listbox
Select which files to add or remove during the job run.
Note
As of version 1.51.x of Matillion ETL, this property has replaced the similar property, Filename. The fundamental difference is that File List allows for the selection of multiple files to be added or removed, whereas Filename was limited to a single file per component.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ❌ | ❌ | ❌ | ❌ |