Aug 26, 2024
OPENROWSET
function for querying external data without creating a dedicated SQL pool.CREATE EXTERNAL TABLE AS SELECT
(CETAS) to store results back to Data Lake.OPENROWSET
can read data files directly, enabling SQL-like queries.OPENROWSET
does not query subfolders by default.