SESSION Details

EDW Automation in Synapse SQL Pools

Star schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ?

In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.

Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.

Feedback Link - https://sqlb.it/?7062

Starts: 14:40 12th Mar 2022
Ends: 15:30 12th Mar 2022

Q&As

Short Description
- DW Automation and Design Best Practices
Other technologies
- ADF and SQL Dedicated Pools

Slidedeck Link

EDW Automation.pptx

Speakers

Bob Duffy

Tags

AzureData IntegratorIntelligence and AnalyticsDevelopingModellingSynapse AnalyticsIntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.