Refresh External Table
    • Dark
      Light

    Refresh External Table

    • Dark
      Light

    Article Summary

    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

    PropertySettingDescription
    NameTextA human-readable name for the component.
    DatabaseSelectChoose a database to create the new table in.
    SchemaSelectSelect 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 TableTextThe name of the External Table to be created or used.
    Relative SubpathTextThe 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.