~/talk

Azure Data Factory patterns and best practices

Talkat SQLBits 2020 · 2020-09-29..10-04· [data-engineering, cloud-infrastructure]
links:none on file
slides:none on file

Azure Data Factory claims real-world throughput (for example 2 petabyte in 11 days at 2–3 GB/s and a customer doing 1 PB per month increments), exposes DIUs and copy parallelism for tuning, and partitions large tables for parallel extract. Mapping Data Flow generates scripts and runs on scale-out Spark with configurable worker/driver cores and TTL to cut warm startup to ~1–2 minutes. Features include template pipelines for SCD/dedupe, CI/CD per environment, CMK + TLS for metadata, managed identity + Key Vault, and private endpoints via ADF-managed VNet.

AI-written summary · about

  1. 0:00Introduction to ADF
  2. 1:33Core ADF capabilities
  3. 4:42Data lake migration pattern
  4. 9:11Hybrid data transfer setup
  5. 12:21Metadata-driven pipelines
  6. 15:42Code-free ETL with data flows
  7. 20:07Data flow configuration demo
  8. 26:22Code-based transformations
  9. 28:58CI/CD and security best practices
  10. 32:02Credential and network security
  11. 38:17Covid-19 data analysis demo
  12. 46:15Roadmap and learning resources
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.