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
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.
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?