View a markdown version of this page

Browse data and create federated catalogs - Amazon SageMaker Unified Studio

Browse data and create federated catalogs

The Data page in the Domain Management Portal shows the catalogs, databases, and tables in your domain, in the same view that builders see on the Data page of their project. From here, domain administrators can also create a federated catalog from a supported data connection. A federated catalog brings the databases and tables from an external source into AWS Glue Data Catalog, so that you can browse them, query them, and add them to the business catalog without copying the data.

Federated catalogs that you create in the Domain Management Portal belong to the domain's admin project. Members of the admin project can also browse them from the Data page of the admin project in the builder portal. Tables in the new catalog are added to the business catalog on the next ingestion run. After that, you can curate them, publish them, or transfer ownership to another project.

Supported data connections:

  • DocumentDB

  • DynamoDB

  • OpenSearch

  • Redshift

  • Aurora MySQL

  • Aurora PostgreSQL

  • Azure SQL

  • Google BigQuery

  • Microsoft SQL Server

  • MySQL

  • Oracle

  • PostgreSQL

  • Snowflake

  • Teradata Vantage

Browse data

To browse data
  1. Open the Domain Management Portal. For more information, see Manage the catalog.

  2. In the left navigation pane, choose Data.

  3. Expand a catalog to view its databases, then expand a database to view its tables.

  4. Choose a table to view its schema and details.

Create a federated catalog

To create a federated catalog
  1. Open the Domain Management Portal.

  2. In the left navigation pane, choose Data.

  3. Choose Catalogs, or open the Add menu.

  4. Choose Create catalog.

  5. Choose the data connection to create the catalog from.

  6. Enter a name for the catalog.

  7. Choose Create.

The catalog appears on the Data page. Tables in a new catalog are added to the business catalog automatically every 24 hours and appear in Assets. To see this schedule, choose the catalog on the Data page and view its details on the Connection tab.