Catalog integration

Use ThoughtSpot’s connection to Alation to import column- and table-level metadata, including column description, table description, column verification status and table verification status, and surface the data in the Search data knowledge cards. To set up or edit a connection to Alation, you must have can manage catalog permission. Once the metadata is imported, all users can see the metadata. Note, the user setting up the catalog connection can also configure which fields they want to display or hide on the column and table level knowledge cards. By default, all selected fields in the catalog connection process will be visible.

This catalog integration is only supported on AWS clusters.
Search Data page showing catalog information
You can only create a connection to a single data catalog at a time. If you connect to Atlan, for example, you cannot simultaneously connect to Alation.

Connect to Alation

  1. Open the Data tab and navigate to Data governance.

  2. In the Alation tile, click Connect.

    Connection to Alation

  3. Enter the following credentials:

    • User name

    • Password

    • Instance URL (for example, https://connector.alationcatalog.com/)

  4. Click Next.

  5. Set a sync schedule to control how often your metadata updates from ThoughtSpot. The default is once a day. You can click the locale to change the sync schedule time zone.

    Create a sync schedule for Alation

  6. Click Next.

  7. Select the fields to import from the following:

    • Table description

    • Column description

    • Table trustcheck

    • Column trustcheck

      Select metadata to sync from Alation to ThoughtSpot

      In this context, trustcheck signifies verification status. While syncing, ThoughtSpot checks for tables that match those already connected to ThoughtSpot and imports only metadata for those tables.
  8. Click Save and sync.

    Once the sync is complete, you see the Last sync field update in the Alation tile. The Sync schedule field displays the frequency with which ThoughtSpot will sync with Alation.

    Alation sync complete

If the sync is taking a while, you can press the "Refresh" button to fetch the latest status.

Edit a connection

You can edit catalog integration with Alation to set off a sync immediately, edit your sync schedule, edit the metadata types imported to ThoughtSpot, or disconnect from Alation.

To edit a connection with Alation:

  1. Navigate to Data > Data governance.

  2. Click the more options icon icon in the top right corner of the Alation tile.

    Options for editing a Catalog sync

  3. Select from the following:

    • Sync now to set off a sync immediately

    • Edit sync schedule to change the cadence of your sync

    • Edit metadata to add or remove metadata fields from your sync

    • Disconnect to disconnect from Alation. If you disconnect from Alation, all metadata fields imported from Alation disappear from ThoughtSpot.

Informational panel display

The informational panel display below the Alation catalog tile allows you to manage the metadata brought in for columns and data sources.

Click Manage columns to decide whether to display the column description and column trustcheck in ThoughtSpot.

Click Manage data sources to decide whether to display the table description and table trustcheck in ThoughtSpot.

Troubleshooting connection or sync failure

If the connection to Alation or the scheduled sync fails for any reason, a View logs field appears next to the Last sync status on the Alation tile in Data governance. You can view and download the log file to better understand why the connection failed.


Was this page helpful?