9 thoughts on “Azure Data Factory – Lookup Activity

  1. Hi Mitchell

    Great blog! Is there an email subscription for your blog? I couldn’t find any. Keep up the great work. Thanks!


    • Hey Syed, thanks for the great feedback. This blog needs to be updated and I will be working on making some updates in the next couple weeks and this should make it easier for users to subscribe. Thanks again!

  2. Pingback: Azure Data Factory – If Condition activity – Mitchellsql

  3. Hey Mitchell, thanks for this great post. I have a doubt here.

    1.We are pulling last modified date a file which is stored in a blob using meta data activity. This is clear and now Stored procedure is returning the last Execution Date from my Control Table so are we storing our data from file into a table?

  4. Pingback: Azure Data Factory–Copy Data Activity – Mitchellsql

  5. Pingback: Azure Data Factory–Filter Activity – Mitchellsql

  6. Mitchell, thanks for this wonderful article.
    Any approach will be helpful!
    I receive different files everyday based on last modified date I need to trigger only that particular file to copy data to SQL.

    • Hey Venu,

      If those files are loaded into an Azure Blob Storage account then you can simply use an Event Based Trigger in ADF. This trigger would kick off your data flow anytime a new file is added to your storage account. Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s