Iceberg REST catalogs

In order to create and work with data lake tables and Apache Iceberg tables within Upsolver, you first need to establish a connection with a metadata store such as Polaris Catalog.

Syntax

CREATE ICEBERG_REST_CATALOG CONNECTION <connection_identifier> 
  URI = '<catalog_URI>'
  CLIENT_PROPERTIES = (<PROPERTY1> = 'value1',<PROPERTY2> = 'value2'...)
  [ COMMENT = '<comment>' ];

Jump to

• URI

• CLIENT_PROPERTIES

• COMMENT

Connection options

URI — editable

Type: text

The catalog URL.

CLIENT_PROPERTIES — editable

The client properties requested by the catalog. Should be passed in this format:

<property_name> = 'property_value'

COMMENT — editable

Type: text

(Optional) A description or comment regarding this connection.

Example

CREATE ICEBERG_REST_CATALOG CONNECTION my_polaris_catalog
  URI = 'https://<account_locator>.snowflakecomputing.com/polaris/api/catalog'
  CLIENT_PROPERTIES = (warehouse = 'my_warehouse',
  credential = 'my_client_id:my_secret', 
  scope='PRINCIPAL_ROLE=ALL')
  COMMENT='polaris production';