Onboard CSV (structured file) data

In this video tutorial, you will be quickly introduced to onboarding CSV (structured file) data from cloud storage.

Steps

1. Ingest Training_CSV data source : Setup Source
   • Connection Type: Cloud Storage
   • Cloud Type: Azure Blob Storage (WASB)
   • Container Name: webreports
   • Account Name: trainingassets
   • Account Key: B6N4/W0hDycyhwjQhBPOHPF8YhAwL8WU+JJXTRqDPGl1wgE8vCca00qu8HAxwgwPHFITu0NxoFPG+uCPiHWkyg==
   • Source Base Path: /
2. File Mappings > Add Table
   • Table Name: webscores
   • Target Table Name: webscores
   • Source Relative Path: /webscores
   • Target Relative Path: /webscores
   • (remaining settings): (review without change)
   • Save & Crawl Schema
3. Configure Tables : webscores (review Details > Edit Schema)
   • Column: productid product_id
   • (remaining settings): (review without change)
   • Save
4. Ingest Data > (Select and ingest webscores table)
   • Job Name: webscores
   • (remaining settings): (review without change)
   • Save as Table Group: (unchecked)
5. Data Catalog > Training_CSV
   • (review status)
   • Select Ingestion Jobs (review status)
6. Catalog data using tags, descriptions, and favoriting