Skip to content

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


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.


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