Leverage Copy Job to copy in the latest file in Data Factory

[@MrSparkefrostie]

I like that the process is a bit easier compared to our adf process, the options that appear missing is an upsert over a complex index (we have changing data) and the process runs on schedule oranually, our run on a blob storage even so just after the file is dropped

[@ankittripathi8305]

Wow, just wonderful as usual, such an awesome preview.

[@Zupee]

Looks great!
I wish there was a Query option at 3:06.
I'd definitely switch all my pipelines over to this since I'm pulling on-prem data into the lake house then warehouse in fabric.
Could do SQL Views as tables on the on-prem side I suppose then pull them in.

[@WellsWellss]

I would like to see it with SQL server. Thanks

[@germanareta7267]

Great video. Thanks !!!

[@axelk77]

Cool stuff! Of course, we also want to see it with an SQL server.

[@AshishSingh-tw2vd]

Great video sir👍😊
I really like your videos ❤
Love from India 🇮🇳

[@mdhruv1]

This is awesome. Suppose I have xlsx files landing in an sftp folder could I use this for loading it into a folder in the files section of the lakes house as xlsx use a notebook to transform the files

[@praprotnikm]

I'd like to see a demo for copy data from sql server CDC if its possible?

[@FineTuningAnalysis]

Do you know if this puts a strain the production source database if it is a Azure SQL Server for example?

[@douglascory]

Waiting for this to work with On premises data sources

[@tiagorente]

Can you load try loading data from a relational database (e.g., Azure SQL Database) to a Fabric SQL database with PK/FK constraints in the destination tables?

[@Fernando_Calero]

Q: Are you a Python convert then?