> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/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.

***

## Before You Begin

* Confirm you have an account with access to Lakebase.
* Ensure the Lakebase service account has the following Postgres privileges:
  * `CONNECT` on the database — database visibility
  * `USAGE` on the schemas — schemas visibility
  * `SELECT` on the tables — query data
* Go to Lakebase **Advanced Settings**, enable **Postgres native role login**, and create a native username and password. You will use these credentials in steps 4 and 5 of [Create a Lakebase Service Account](#create-a-lakebase-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.
   <Frame>
     <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-01.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=863f60ace81854509b5f3d01c5885e65" alt="Domo on Lakebase landing page" width="1920" height="869" data-path="images/kb/lakebase-kb-01.png" />
   </Frame>

## Create a Lakebase Integration

Every Lakebase integration requires a Lakebase service account. A single service account can be reused across multiple integrations. Multiple integrations can coexist in the same Domo instance, so use clear, descriptive names.

<Frame>
  <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-03.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=268b78e0658337572892d88e89688dfa" alt="Lakebase integration setup form" width="1920" height="869" data-path="images/kb/lakebase-kb-03.png" />
</Frame>

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** to explain the purpose of the integration and who created it.
   Most users see only the integration name in menus and lists — the description appears only in integration details.
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 — see [Create a Lakebase Service Account](#create-a-lakebase-service-account) below before continuing.
   <Warning>**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.</Warning>
4. Enter the **Lakebase Account Database** — the name of the database that contains your Lakebase tables.
5. Select **Save Integration**.
   <Frame>
     <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-04.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=6515412f4cf2d6a9a96d9a220025db9b" alt="Lakebase service account dropdown" width="1920" height="869" data-path="images/kb/lakebase-kb-04.png" />
   </Frame>

## Create a Lakebase Service Account

To view and manage existing service accounts, go to **Accounts** in Domo. You can create multiple service accounts for the same Lakebase instance.

<Warning>**Important:** When you create a Lakebase service account, you, other account owners, and anyone the account is shared with can use its credentials to access Lakebase and create connected DataSets in Domo. Sensitive values such as passwords, tokens, and keys are not visible to anyone.</Warning>

<Frame>
  <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-05.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=043a208066bee473e069df10df70dc06" alt="New Lakebase Service Account dialog" width="1920" height="869" data-path="images/kb/lakebase-kb-05.png" />
</Frame>

1. Enter a **New Account Name** to identify this service account within Domo.
   Use a clear, distinctive name to avoid confusion with other Lakebase accounts and integrations.
2. Enter the **Lakebase Account Server Hostname** — the server name or IP address of your Lakebase instance.
3. Enter the **Lakebase Account Port** — the port your Lakebase instance uses for incoming connections.
4. Enter the **Lakebase Username** — the native username you created in Lakebase.
5. Enter the **Lakebase Password** — the native password you created in Lakebase.
6. Select **Add Account**.

## 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.

<Frame>
  <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-02.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=4c293bf943392abeff77f5958a142d91" alt="Lakebase cloud integrations page" width="1920" height="869" data-path="images/kb/lakebase-kb-02.png" />
</Frame>

To manage a specific integration, select the **Wrench** icon next to it.

<Frame>
  <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-06.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=1dfb29f03d85fb9036534e1aa7b7461c" alt="Integration management options" width="1920" height="869" data-path="images/kb/lakebase-kb-06.png" />
</Frame>

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](/s/article/4412849158167)
* **Select Tables to Connect** — add or remove Lakebase tables from the integration. See [Connect Tables in Cloud Integrations](/s/article/Connect-Tables-in-Cloud-Integrations) for instructions
* **Delete Integration** — permanently remove the integration

<Frame>
  <img src="https://mintcdn.com/domoinc-openapi-sync-dataflows/aUYJslVwXGLPe2_D/images/kb/lakebase-kb-07.png?fit=max&auto=format&n=aUYJslVwXGLPe2_D&q=85&s=7d7258749e04f23b7e49669fdf5040f0" alt="Integration settings page" width="1920" height="869" data-path="images/kb/lakebase-kb-07.png" />
</Frame>

From this page, you can update integration settings, connect tables, configure data freshness, and share the integration with other users.
