CREATE EXTERNAL ICEBERG TABLE

Syntax

CREATE EXTERNAL ICEBERG TABLE <table_identifier>
   [{ table_options }];

Jump to

• Table identifier

• Table options

Table identifier

Table identifiers are provided in the following format:

<catalog_name>.<schema_name>.<table_name>

Note that only metastore connection types are accepted for the catalog name.

Valid table names match the following identifier format:

identifier = "([^"]|"")*"|[A-Za-z_][A-Za-z0-9_]*;

Table options

[ COMMENT = '<comment>']
[ OPTIMIZE = { TRUE | FALSE } ]

Jump to

• COMMENT

• OPTIMIZE

COMMENT — editable

Type: text

(Optional) A description or comment regarding this table.

OPTIMIZE — editable

Type: Boolean

Default: false

(Optional) When false, the tables will be not optimized by Upsolver. When true, files are compacted to reduce storage costs and increase query scan performance.

---

Example

Create an external Iceberg table that Upsolver manages for you:

CREATE EXTERNAL ICEBERG TABLE
    default_glue_catalog.my_database.my_external_iceberg_table
    OPTIMIZE = TRUE;