> ## Documentation Index
> Fetch the complete documentation index at: https://www.domo.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Domo on Lakebase
## 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.
## 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.
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](#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**.
After saving, a confirmation screen appears.
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.
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.
(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.
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.
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](/docs/s/article/4412849158167#cloud-integrations-overview).
* **Select tables to connect —** Add or remove Lakebase tables from the integration. See [Connect Tables](/docs/s/article/Connect-Tables-in-Cloud-Integrations#connect-tables-in-cloud-integrations) for instructions.
* **Delete integration —** Permanently remove the integration.
