Part 3–Loading Data into Azure SQL Data Warehouse

Download this episode

Download Video

Description

In this video, you will explore the different methods for loading data into a Data Warehouse and have a clear understanding of the efficient method to load. You will also understand the role of a "load user" and why it is important to create a dedicated account for loading. You will also learn how to import and export data and integrate Azure SQL Data Warehouse with Azure Data Factory.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      JSAD

      Instead of using AZcopy to copy files to Blob storage. Would using SSIS be better? Wondering if it is probably more maintainable to put everything in an SSIS package?

    • User profile image
      ctestaoneill

      Hi JSAD,

      So sorry for the delayed response.

      You could use SSIS, but you wouldn't be able to take full advantage of the MPP - Massively Parallel Processing capability that Azure SQL Data Warehouse has to offer.

      So If SSIS is really important, why not do all the SSIS work and then output them to files in Azure Blob Storage, and then use Ploybase to load those cleaned files.

      This will be more performant that connect SSIS to Azure Data Warehouse directly, especially when huge volumes of data are involved

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.