Creating a Logical Data Warehouse in Azure Synapse Analytics Serverless SQL Pools Technical Demo

Описание к видео Creating a Logical Data Warehouse in Azure Synapse Analytics Serverless SQL Pools Technical Demo

In this video we'll go through the process of creating a simple Logical Data Warehouse using Azure Synapse Analytics Serverless SQL Pools including creating Dimensions and Facts.

For more Azure Synapse Analytics Serverless SQL Pools blogs please visit www.serverlesssql.com.

Chapters:
00:00 Introduction
00:29 Create new Database and connections to Azure Data Lake
02:26 Create Views to query source CSV data
07:14 Select from Views to query source data
07:55 Create Dimensions and Facts in Parquet file format
13:00 Query Dimensions and Facts with aggregate SQL queries

Branding by GPJ Studio https://www.garethpjones.com/

Комментарии

Информация по комментариям в разработке

Похожие видео