In my latest video blog I discuss and demonstrate some of the ways to connect to external data in Azure Synapse if there isn’t a need to import the data to the database or you want to do some ad-hoc analysis. I also talk about using COPY and CTAS statements if the requirement is to import the data after all. Check it out here
Tag Archives: Data Warehouse
The Modern Data Warehouse in Azure Part 5 – Master Data Management Tools
In this vLog I describe some of the leading Master Data Management (MDM) tools in Azure, a necessary part of any Data Warehouse deployment, but often overlooked.
The Modern Data Warehouse in Azure Part 4: The Serving Layer
In this video blog post I covered the serving layer step of building your Modern Data Warehouse in Azure. There are certainly some decisions to be made around how you want to structure your schema as you get it ready for presentation with whatever your business intelligence tool of choice, for this example I used Power BI, so I discuss some of the areas you should focus on:
- What is your schema type? Snowflake or Star, or something else?
- Where should you serve up the data? SQL Server, Synapse, ADLS, Databricks, or Something Else?
- What are your Service level agreements for the business? What are your data processing times?
- Can you save cost by using an option that’s less compute heavy?