Welcome to the 3rd and final part in this blog series in which we're looking at how Azure Synapse Analytics Serverless SQL Pools deals with changing schemas in CSV (delimited),…
Welcome to part 2 in this blog series in which we're looking at what happens when schema changes are made in source data lake files which is then queried by…
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage. A common pattern is to move data from source systems…
In part one we looked at a process in which a pre-aggregated dataset can be created by Azure Synapse Analytics Serverless SQL Pools and saved to an Azure Data Lake…
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is automatically updated as new data is added to its source…
In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh, and DirectQuery (real-time) modes in a single table. We look…
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along with an External Table, allows us to cast structure over…
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the November 2021 Synapse Analytics update). When querying external data, Serverless…
Temporary (temp) tables have been a feature of Microsoft SQL Server (and other database systems) for many years. Temp tables are supported within Azure Synapse Analytics in both Dedicated SQL…
Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data in Azure Storage, Azure Data Lake Gen1 & 2, Cosmos…
Andy