Azure Daily 2022 by Gordon

Announcing Data virtualization with Azure SQL Managed Instance – preview

Data virtualization capabilities, now in preview in Azure SQL Managed Instance, enable you to execute Transact-SQL (T-SQL) queries against data from files stored in Azure Data Lake Storage Gen2 or Azure Blob Storage and combine it with relational data stored locally in the managed instance using logical joins. This way you can transparently access external data while keeping it in its original format and location. There is no data duplication or need to run and maintain ETL processes, which means that you can extract and deliver insights faster. Currently supported file formats are Parquet, CSV, and JSON.

Announcing Data virtualization with Azure SQL Managed Instance – preview - Microsoft Tech Community

Comments

Leave a Comment

All fields are required. Your email address will not be published.