Skip to main content
Version: I2022.3.0

Adding Starburst Warehouses

A Starburst data warehouse contains the tables and views that you want to import as fact datasets and dimension datasets into AtScale cubes. It also contains aggregate-table instances that either you or the AtScale engine creates in a database that you specify.

Before you begin​

  • Ensure that your user ID in the Design Center is assigned the Super User role or is assigned the Manage Data Warehouses role permission.
  • Ensure that you know the database to use for aggregate tables to be built in the data warehouse. You should create this database if it is not available; AtScale does not automatically create a database if one does not exist.
  • Ensure that you know the schema to use for aggregate tables to be built in the data warehouse. AtScale creates tables, drops tables, and reads and writes aggregate data to this schema. You should create this schema if it is not available.

Add a Starburst data warehouse​

  1. Go to Settings > Data Warehouses and choose Create Data Warehouse to open the Add a Data Warehouse dialog box.

  2. Select Starburst in Type of Data Warehouse .

  3. Enter a unique name for the data warehouse. AtScale displays this name in the Design Center and uses it in log files.

  4. Enter the name of the External Connection ID. This input will be inherited by the Name value, but can be overridden by enabling the Override generated value slider.

  5. Enter the name of the Database for AtScale to use when creating aggregate tables.

  6. Enter the name of the Aggregate Schema for AtScale to use when creating aggregate tables.

  7. Choose whether to set the data warehouse as read-only:

    • Select the Read-only source option if AtScale will be configured to access this database with credentials that do not have permission to create new tables, or if you need to prevent AtScale from placing any aggregate tables in this data warehouse.
    • If Read-only source is enabled upon editing an existing data warehouse with aggregates present, all existing aggregates stored in this data warehouse will be deactivated.

  8. Choose Save to complete the setup.

Add a Starburst Connection​

After setting up your data warehouse, you must add one or more connections to it before you can run queries:

  1. Expand the Starburst data warehouse, and select Create Connection.
  2. Enter the Name of your Starburst connection.
  3. Enter the Host location of the Starburst server.
  4. For Port, enter the port number to route transmitted data. The default port number is 443.
  5. Enter the Username for connecting to the database.
  6. Enter the user Password for connecting to the database.
  7. If necessary, enter the JDBC flags that are needed for the connection in the Extra JDBC Flags field.
  8. Test the connection.
  9. Choose Save to complete the setup.