Use data loading best practices in Azure Synapse Analytics

Intermediate
Data Engineer
Synapse Analytics

Learn the best practices you need to adopt to load data into a data warehouse in Azure Synapse Analytics.

Learning objectives

In this module, you will:

  • Understand data loading design goals
  • Explain loading methods into Azure Synapse Analytics
  • Manage source data files
  • Manage singleton updates
  • Set-up dedicated data loading accounts
  • Manage concurrent access to Azure Synapse Analytics
  • Implement Workload Management
  • Simplify ingestion with the Copy Activity

Prerequisites

  • Before taking this module, it is recommended that you complete Data Fundamentals.