topic Ingesting data from SQL Server foreign tables in Data Engineering https://community.databricks.com/t5/data-engineering/ingesting-data-from-sql-server-foreign-tables/m-p/81811#M36415 <P>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?</P> Mon, 05 Aug 2024 07:07:46 GMT DBMIVEN 2024-08-05T07:07:46Z Ingesting data from SQL Server foreign tables https://community.databricks.com/t5/data-engineering/ingesting-data-from-sql-server-foreign-tables/m-p/81811#M36415 <P>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?</P> Mon, 05 Aug 2024 07:07:46 GMT https://community.databricks.com/t5/data-engineering/ingesting-data-from-sql-server-foreign-tables/m-p/81811#M36415 DBMIVEN 2024-08-05T07:07:46Z