STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN

Target database: Snowflake

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

OPTION

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):

OPTION

STORAGE.EXTERNAL_TABLE_FILENAME_PATTERN: important_files_[0-9]*

DDL generated by Agile Data Engine:

SQL

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