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