Azure Synapse Analytics | Data Ingestion Patterns, Polybase

By: Arshad

View Recording

Or Register below by entering your details:-


To raise question, join our telgram channel now.
By Registering You Agree To Our Terms , Condition and Disclaimer.

12 (Enrolled)

You are the 13 technologist to register for Arshad Ali master class.

Azure Synapse Analytics | Data Ingestion Patterns, Polybase

Having right data ingestion framework and patterns are important considerations to have consistent data ready for analytics in timely manner, especially when you are dealing with large data volume and expect your data to grow every day.

In this video, you will learn about different data ingestion patterns and options available with Azure Synapse Analytics - dedicated SQL pool.

Introduction
ELT (Extract Transform and Load) vs ELT (Extract Load and Transform)Show more
Single Gated Bulk Data Load
Parallel Data Load
Parallel Data Load - Polybase
Data Import - with CTAS
Data Export - with CETAS
Parallel Data Load - Copy Command
Demo - Bulk Data Load with bcp
Demo - Bulk Data Load with Polybase
Demo - Data Import (CTAS) vs. Data Export (CETAS)
Demo - Bulk Data Load with Copy Command
Demo - Incremental Data Refresh
Demo - Monitor Data Load Operations

Thank you for watching, in my next video, I am going to talk in detail about multi-layer security architecture available with Azure Synapse and how you can build modern data warehouse with confidence in Azure Synapse. Stay tuned.

View Recording

You can share it with others

Instructed by

Arshad Ali
Principal Architect

Seasoned technical architect with deep experience in architecting and delivering enterprise scale data warehousing, business intelligence, big data and advance analytics solutions for enterprise customers across globe. Engages with strategic customers for digital transformation and business prioritization processes, particularly focused on data platform modernization and data analytics, to enable them to better utilize their data platform assets, and drive new insights and scale from their investment in cloud solutions through a combination of batch or real-time data consumption & processing (Lambda or Kappa architecture), predictive analytics as well as intuitive visualizations that enables users to make smarter, faster decisions.


A technical thought-leader who manages and collaborates with multi-stakeholders ecosystem - customers, engineering, marketing and sales, consulting, partners etc.


Presented in several technical events both internally and externally. Has co-authored a book on big data analytics (Big Data Analytics with Microsoft HDInsight by Sams\Pearson) and has written 200+ technical and performance optimization technique articles on data platform and analytics which have been published on several sites.

Benefits Of Joining Our Events And Sessions
Our Integrated Approach To Open Learning.
Benefits Of Joining Our Events And Sessions
Upcoming Events