Refresh External Table

Dark

Light

This article is specific to the following platforms - Snowflake.

Refresh External Table

Refreshes an external table, re-syncing it with the target data. An external table requires refreshing so that the correct data will be returned when the table is queried. This refresh should always be done before an external table is used, and it is critical when the target data has been changed since the table was last used.

This component is typically used in conjunction with Manage Stages and the Create External Table component.

For additional details and an example of how you would use this component, read the Matillion blog post How Matillion ETL for Snowflake Supports External Tables.

Properties

Property	Setting	Description
Name	Text	A human-readable name for the component.
Database	Select	Choose a database to create the new table in.
Schema	Select	Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.
Target Table	Text	The name of the External Table to be created or used.
Relative Subpath	Text	The directory path to follow to the target data. File names cannot be specified. The path is relative to the storage location given in the External Stage setup.

What's Next

Delete Partition

Table of contents