Create a data interface from a single table

Create a governed data interface on a single source table and publish it to the Data Catalog so consumers can access the data through a stable schema.

Before you begin

Role required: data_product_admin, df_data_steward, delegated_developer, df_data_steward, and delegatedadmin (scope admin)

Procedure

1. Navigate to All > Workflow Data Fabric > Data Workbench.

2. Select Create > Create data interface.

   The data interface wizard opens to the Basic details step.

3. Enter the basic details for the data interface and select Continue.

   • Interface label: Enter a name for the data interface. This label identifies the data interface in the Data Catalog.
   • Unique name: Auto-generated from the data interface label.
   • Application scope: Select the scope in which to create the data interface.
   • On the Select source tables page, select Add.

4. Search for the source table in the Data Catalog and add tables to your selection.

**Note:** The following platform table types are not supported as source tables:

-   Tables with names that begin with `sys_`
-   Child tables

1. Review the list of tables and select Continue.

   Because one table is selected, no combination method is required. The wizard advances to column selection.

2. Select the columns to include in the data interface and select Continue.

   Select only the columns that consumers require. Limiting columns reduces the impact of future schema changes in the source table.

1. Review the target table column mapping and select Create table.

   The Define target table step shows the selected columns with their auto-mapped target names and data types. You can adjust column labels and types before creating the table.

The system creates the data interface table and the underlying Data Fabric Table. The wizard advances to the **Connect and verify** step.

1. Connect and verify the source table.

   1. Select Connect and verify next to the source table.

   2. Select the connector for your source system from the list of available connections.

   3. Select Verify.

      The table shows a Verified status when the connection is confirmed.

1. Select Preview to review sample data from the data interface.

   The preview shows the top 10 live records from the combined output. Verify the columns and data match what consumers expect before continuing.

2. Review the permissions and select Continue.

   For data interfaces built entirely on external source tables, the system automatically configures the required access roles.

   Note: If the data interface includes any ServiceNow tables, this step requires a manual permissions request. Copy the provided email template and send it to the security administrator. The security administrator must add the correct read roles to the composite role generated for the data interface. Select the confirmation check box before continuing.

3. Review the data interface configuration on the Review and finalize page and select Done.

The data interface is published and the overview page opens.

Result

The data interface is published and visible in Data Workbench. After the metadata collector runs, the data interface appears in the Data Catalog where consumers can discover and request access to it.

Note: A delay occurs between publishing a data interface and its appearance in the Data Catalog. The metadata collector must run before the data interface is discoverable. To make the data interface available without waiting for the scheduled run, ask the administrator to run the collector manually from Connect Hub.

What to do next

To package this data interface into a data product, see Create a data product.

Parent Topic:Managing data interfaces