STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN

STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN option defines regular expression pattern string, enclosed in single quotes, specifying the filenames and paths on the external stage to match.

See also:

• EXTERNAL_TABLE

Usage

STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN: String

Default: Empty.

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN

Setting STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN for an External table (e.g. publish.F_TRIP):

STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN: important_files_[0-9]*

DDL generated by Agile Data Engine:

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
PATTERN = 'important_files_[0-9]*'
...;