Ingesting Data Into Lakehouses

Introduction to Microsoft Fabric

Alex Kuntz

Technical Instructional Designer

Lakehouses recap

• Structured data in Delta Tables
• Unstructured data in raw files (ex. .csv files)
• Use Python notebooks or PowerBI
• Limited SQL functionality

Dataflow and Data Pipelines

Unstructured data

• Direct file upload for unstructured data
• Can convert unstructured data into tables

Unstructured data to tables

Shortcuts

• Pointer to another source of data
  • ex. Warehouse to Lakehouse
• Encourages a single, unified source of data

Shortcut connections

• Shortcuts from data outside of Fabric!
  • AWS S3, Google Cloud Storage, Azure, etc.
• Some permission issues to consider

Let's practice!

Introduction to Microsoft Fabric