~/talk

Top 10 Azure Data Factory Tips & Tricks

Talkat SQLBits 2023 · 2023-03-14..03-18· [databases]
links:none on file
slides:none on file

Twenty concrete ADF practices: save then refresh before publish to avoid overwrites; check object dependencies before changing datasets or linked services; clone data flows to debug breakages; extract failure text via output.errors.message and capture rows via output.dataReads/output.dataWritten; use annotations on triggered runs; prefer parameters/global parameters and expressions to avoid nested activities; factor reusable email/logic into child pipelines; write variables to Blob by using copy activity additional columns. Also note ADF lists ~95 built‑in sources.

AI-written summary · about

  1. 0:00Introduction to tips
  2. 0:24Save changes before publish
  3. 1:28Check dependencies before changes
  4. 4:00Clone objects for troubleshooting
  5. 5:46Access activity outputs dynamically
  6. 10:55Use annotations for triggers
  7. 13:23Leverage parameters and variables
  8. 16:56Use nested expressions in if
  9. 18:00Create child pipelines for reuse
  10. 19:02Write variables to blob storage
  11. 20:27Closing and thanks
~/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.