Exercise: Select Tables for Ingestion

Prerequisite: If you have not already done so, please Download the AdventureWorks Sample Database.

Steps:

  1. Right-click on the new data source, AW.
  2. Click Read objects from Data Source
    • This will read the metadata from the data source such as table names, field names, data types, relations, and primary keys.
  3. Expand table nodes to view and select individual fields.
  4. Right-click on table names to Preview the source table and select data by viewing its values.
  5. For this Exercise, click Select All.
  6. In the Business Unit, expand the Tables node to see the newly added tables.

Next