topic Re: How does AutoLoader works when triggered via Azure Data Factory? in Get Started Discussions

How does AutoLoader works when triggered via Azure Data Factory?

zll_0091 — Wed, 24 Jul 2024 02:47:15 GMT

Hi,

I am currently creating an AutoLoader in databricks and will be using ADF as an orchestrator.

I am quite confused how this will handle my data so please clarify if I misunderstood it.

First, I will run my ADF pipeline which includes an activity to call my AutoLoader notebook. Will it work like below or will it just process all the files in the folder once I run the ADF pipeline?

***I'm using option("includeExistingFiles", False) on my readStream

Re: How does AutoLoader works when triggered via Azure Data Factory?

szymon_dybczak — Wed, 24 Jul 2024 05:50:51 GMT

Auto loader will process files incrementally. Let's say you have a files in existing directory called /input_files

First time you run autoloader, it will read all files in that directory (unless you set an option includeExsistingFiles to false, like you did) and save information about what files has been read to checkpoint location.

Next run will only load new files, because auto loader knows what has been loaded previously thanks to checkpoint

Re: How does AutoLoader works when triggered via Azure Data Factory?

zll_0091 — Wed, 24 Jul 2024 13:17:44 GMT

I see. So even though my stream stops it can still identify the files that was processed using the info in checkpoint location?

Re: How does AutoLoader works when triggered via Azure Data Factory?

szymon_dybczak — Wed, 24 Jul 2024 13:18:57 GMT

Exactly, you got it right 😉