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
Connection options
URI
— editable
URI
— editableType: text
The catalog URL.
CLIENT_PROPERTIES — editable
CLIENT_PROPERTIES — editable
The client properties requested by the catalog. Should be passed in this format:
<property_name> = 'property_value'
COMMENT
— editable
COMMENT
— editableType: 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';
Last updated