STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION

STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION option defines whether external table is having automatic partitioning (false) or manually specified partitioning (true).

See also:

• EXTERNAL_TABLE

Usage

STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION: Boolean

Default: false

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION

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

STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION: true

DDL generated by Agile Data Engine:

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
PARTITION_TYPE = USER_SPECIFIED
...;