Skip to main content

Domo

Domo is a cloud-based platform designed to provide direct, simplified, real-time access to business data for decision makers across the company with minimal IT involvement.

Supported Authentication Method​

Authenticate to Dremio Cloud by using a personal access token (PAT). To create one, see Creating a Token.

Prerequisite​

Obtain the ID of the project in Dremio Cloud that you want to connect to. For the steps, see Obtaining the ID of a Project.

Creating a Cloud Integration with Dremio Cloud​

  1. Click the Data tab to open the Datasets page.
  2. Click the Federated tab to open the Amplify existing cloud warehouses dialog.
  3. Next to Native integration, click Dremio.
  4. In the Cloud integrations dialog, click Add new integration.
  5. In step 1 of the Connect a Dremio cloud integration wizard, follow these sub-steps:
    1. In the Integration name field, specify a unique name for the integration.
    2. (Optional) In the Integration description field, briefly describe the integration.
    3. Select Dremio Cloud as the connection type.
  6. Click Next.
  7. In step 2 of the wizard, follow these sub-steps:

    1. In the Dremio connection URL field, specify the following connection URL, where PROJECT_ID is the ID of the project that you want to connect to: Connection URL

      jdbc:dremio:direct=sql.dremio.cloud:443;ssl=true;token_type=personal_access_token;PROJECT_ID=<project-ID>

    2. Paste your PAT into the Personal Access Token field.

  8. Click Next.
  9. Select the tables that you want to use with Domo through this integration.
  10. Click Create Datasets.

Datasets are created from the tables, though no data is moved or copied. Datasets in Domo are connections to data in data sources.