Skip to main content

​
Intro

With Cloud Integrations, you can query and visualize Lakebase data directly in Domo without copying or duplicating data. This article explains how to set up and manage a Lakebase integration in Domo.

​
Prerequisites

  • Confirm you have an account with access to Lakebase.
  • Ensure the Postgres user you will use for the Lakebase service account has the following Postgres privileges:
    • CONNECT — on the database—database visibility
    • USAGE — on the schemas—schema visibility
    • SELECT — on the tables—query data
  • If you plan to use Username & Password authentication: In Lakebase, go to Advanced Settings, enable Postgres native role login, and create a native username and password. Use these credentials when creating the service account.

​
Access the Lakebase Integrations Page

  1. Navigate to Data Warehouse.
  2. Select Connect Data.
  3. From the Cloud Integrations list, select Lakebase. The Domo on Lakebase page appears.
Domo on Lakebase landing page

​
Create a Lakebase Integration

Every Lakebase integration requires a service account. You can reuse one service account across multiple integrations and run multiple integrations in the same Domo instance—use clear, descriptive names to tell them apart.
Lakebase integration setup form
  1. Enter a Name for the integration. This label identifies it within Domo—it doesn’t need to match any Lakebase names and can be changed later.
  2. (Optional) Enter a Description. The description appears only in integration details—most views show only the name.
  3. In the Lakebase service account field, select an existing service account, or select Add account… to create a new one. If you select Add account…, the New Lakebase Service Account dialog appears—complete the steps in Create a Lakebase service account below, then return here and continue with step 4.
    Important: If you change the service account later, DataSets and DataFlows may need remapping, and access to previously connected tables may change if the new account has different privileges.
  4. In the Lakebase account database field, enter the name of the database that contains your Lakebase tables. You can find this in your Lakebase catalog or database settings.
  5. Select Save integration.
Lakebase service account dropdown
After saving, a confirmation screen appears.
Integration created successfully
Select Proceed to Integration Overview to start connecting tables and configuring the integration.

​
Create a Lakebase Service Account

Important: Anyone with access to this service account—including other account owners, Domo admins, and users you share it with—can use its credentials to access Lakebase and create connected DataSets in Domo. Passwords, tokens, and keys are never visible.
  1. In the New account name field, enter a name to identify this service account within Domo. Use a clear, distinctive name to avoid confusion with other Lakebase accounts and integrations.
  2. In the Lakebase account server hostname field, enter the server name or IP address of your Lakebase instance.
  3. In the Lakebase account port field, enter the port your Lakebase instance uses for incoming connections.
  4. From the Connect with dropdown, select your authentication method:
    • Username & Password — Authenticate using a native Postgres username and password. Requires Postgres native role login to be enabled in Lakebase Advanced Settings.
    • M2M OAuth — Authenticate using Databricks machine-to-machine OAuth credentials.
    New Lakebase Service Account dialog — M2M OAuth selected
  5. Enter the credentials for your selected method. (Conditional) If you selected Username & Password: a. In the Lakebase username field, enter the native username you created in Lakebase. b. In the Lakebase password field, enter the native password you created in Lakebase.
    New Lakebase Service Account dialog — Username & Password
    (Conditional) If you selected M2M OAuth: a. In the Databricks workspace hostname field, enter the hostname of your Databricks workspace. b. In the Client ID field, enter the application ID of the Databricks service principal. c. In the Client Secret field, enter the OAuth secret for the service principal.
    M2M OAuth credential fields
  6. Select Create Account. The service account is saved and available in the Lakebase service account dropdown when creating an integration.
To view and manage existing service accounts, go to Data Warehouse > Connect Data > Cloud Integrations > Lakebase.

​
Manage Existing Integrations

Select Manage Integrations from the Domo on Lakebase page to view existing integrations. The Lakebase Cloud Integrations page lists each integration’s name, number of connected tables, configuration type, and your access level. You can also select + Add New Integration from this page.
Lakebase cloud integrations page
To manage a specific integration, select the wrench icon next to it. Available options vary based on your access level:
  • Edit integration — Update the integration’s name, description, service account, or database settings. From the integration settings page, you can also connect tables, configure data freshness, and share the integration with other users. For details on data freshness and account sharing, see Cloud Integrations Overview.
  • Select tables to connect — Add or remove Lakebase tables from the integration. See Connect Tables for instructions.
  • Delete integration — Permanently remove the integration.
Integration settings page