Azure Synapse Analytics
PASS Data Community Summit 2021 Slides Please click here for a PDF copy of the slides. Polaris (Serverless SQL Pools…
Synapse Analytics allows the creation of External Tables and Views within a Serverless SQL Pools database and also a Spark…
Microsoft provide an Azure Architecture Centre which contains resources to understand which Azure services are appropriate in certain scenarios and…
When data is stored in Azure Data Lake Gen2, we can use Azure Active Directory and Access Control Lists (ACLs)…
Azure Purview is a Microsoft Data Governance service which enables an organisation to map their data infrastructure including data lineage…
Temporary (temp) tables have been a feature of Microsoft SQL Server (and other database systems) for many years. Temp tables…
Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data…
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and…
When using Serverless SQL Pools to write data to Azure Storage/Data Lake Gen2 using the CREATE EXTERNAL TABLE AS SELECT…
Welcome to Part 4 in the Creating a Logical Data Warehouse with Synapse Serverless SQL Pools series. We are now…