Ingesting data from SQL Server foreign tables

[DBMIVEN]

I have created a connection to a SQL server DB, and set up a catalog for it. i can now view all the tables, and query them. I want to ingest some of the tables into our ADLS gen 2 that we set up with Unity Catalog. What is the best approach here? LakeFlow Connect? Or can i ingest the data incrementally using auto loader?

[Kaniz_Fatma]

Hi @DBMIVEN, To ingest data from your SQL Server DB into ADLS Gen2 with Unity Catalog, you can use LakeFlow Connect for a managed, streamlined approach with scheduling and monitoring, or Auto Loader for incremental ingestion that processes new files as they arrive. Additionally, you can leverage the COPY INTO command to load data from ADLS Gen2 into Unity Catalog tables, supporting various file formats and both initial and incremental loads. If you need more details on these methods, let me know!