STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION

Target database: Snowflake

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

OPTION

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

OPTION

STORAGE.EXTERNAL_TABLE_USER_SPEC_PARTITION: true

DDL generated by Agile Data Engine:

SQL

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