Polaris Catalog

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 = '<polaris_catalog_URI>'
  CLIENT_PROPERTIES = (warehouse = '<warehouse_name>', 
  CREDENTIAL = '<client_id>:<secret_key>',
  SCOPE='PRINCIPAL_ROLE:<Principal_role_name>',
  <ANY_ADDITIONAL_PROPERTY> = 'property_vale')
  [ COMMENT = '<comment>' ];

Jump to

• URI

• CLIENT_PROPERTIES

  • CREDENTIAL

  • SCOPE

  • WAREHOUSE

• COMMENT

Connection options

URI — editable

Type: text

The Polaris catalog URL.

This is the endpoint where the platform will connect to access your Polaris data for example: https://<account_locator>.snowflakecomputing.com/polaris/api/catalog

CLIENT_PROPERTIES — editable

Client properties should be passed in this format: <property_name> = 'property_value'.

While credential, scope, and warehouse are mandatory, you can pass any additional properties as necessary.

CREDENTIAL

Type: text

The credentials used to access the catalog in the format '<client_id>:<secret_key>' where:

• client_id - Polaris Client ID. This unique identifier is provided by Polaris and is required for secure authentication.

• secret_key - Polaris Secret Key. This key works with your Client ID to securely authenticate your connection to Polaris.

SCOPE

Type: text

OAuth scope limit for access to Polaris. Use PRINCIPAL_ROLE:ALL if you are unsure.

WAREHOUSE

Type: text

The Polaris catalog name. Note, the catalog name is case sensitive.

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');