Tabular

This quickstart guide shows you how to create a connection to Tabular.

Create a connection to your Tabular warehouse

The following instructions demonstrate how to create a basic connection to Tabular.

Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.

Here’s the code for creating a connection to Tabular:

// Syntax
CREATE TABULAR CONNECTION <TABULAR_CONNECTION_NAME>
    TOKEN = '<CREDENTIALS>'
    WAREHOUSE = '<WAREHOUSE_NAME>'
    DEFAULT_STORAGE_CONNECTION = my_s3_storage_connection
    DEFAULT_STORAGE_LOCATION = 's3://upsolver-demo/my_tabular_catalog_table_files/';
    
// Example
CREATE TABULAR CONNECTION my_tabular_connection
    TOKEN = 'my_credentials'
    WAREHOUSE = 'Orders Warehouse'
    DEFAULT_STORAGE_CONNECTION = my_s3_storage_connection
    DEFAULT_STORAGE_LOCATION = 's3://upsolver-demo/my_tabular_catalog_table_files/';

This code creates a Tabular connection name my_tabular_connection, and instructs Upsolver to use the Orders Warehouse.


Learn more

Please see the SQL command reference for Tabular for the full list of connection options, and examples.

Last updated