External Tables vs Views…Which to Use and Why?
Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data...
Month: July 2021
Azure Storage Folder Filtering using the Filepath Function
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and...
10 Billion Rows: Parquet File Size and Distribution When using CETAS
When using Serverless SQL Pools to write data to Azure Storage/Data Lake Gen2 using the CREATE EXTERNAL TABLE AS SELECT...
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 4 of 4 – Connecting Power BI to the Dimensional Model
Welcome to Part 4 in the Creating a Logical Data Warehouse with Synapse Serverless SQL Pools series. We are now...
