Querying external data in Azure Blob/Data lake Storage Azure SQL Managed Instance Private Preview Guide Thank you for your interest in data virtualization capabilities of Azure SQL Managed Instance! The feature is now publicly available. Please check the documentation for more details.
in Parquet and CSV format, stored in Azure Data Lake Storage v2 or Azure Blob Storage, and to combine it in queries with locally stored relational data. In terms of the syntax, the feature resembles SQL Server’s PolyBase capabilities, currently limited to read-only access to files.
Domain:
Source:
Link to this page:
1 Querying external data in Azure Blob/Data lake Storage Azure SQL Managed Instance Private Preview Guide Thank you for your interest in data virtualization capabilities of Azure SQL Managed Instance! The feature is now publicly available. Please check the documentation for more details.
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has LOCATION='/topfolder/' . When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned? Options: A. File2.csv and File3.csv only