Azure Purview March Updates
Azure Purview updates
Announcements
Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.
March updates
Support for SAP Business Warehouse (Preview)
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/register-scan-sap-bw
Dynamic lineage extraction from Azure SQL Databases (Preview)
Documentation:
Video:
Certify assets in the Azure Purview data catalog
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-certify-assets
Ability to delete child terms when parent term is deleted
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-create-import-export-glossary
Connect to and manage an on-premises SQL server instance in Azure Purview
Documentation:
https://docs.microsoft.com/en-us/azure/purview/register-scan-on-premises-sql-server
Approval workflow for business terms (Preview)
Before you can start Authoring your workflows make sure you the correct user to the role assignment Workflow administrators, if you haven't done that correctly the option will be greyed out.
Blogpost:
Approval workflow for business glossary
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-business-terms-approval
Self-service data access workflows for hybrid data estates (Preview)
Documentation:
https://docs.microsoft.com/en-us/azure/purview/how-to-workflow-self-service-data-access-hybrid
Azure integration runtime supports scanning more source types
Azure Purview now supports scanning Snowflake, Salesforce, PostgreSQL, MySQL, Cassandra and Looker using managed Azure integration runtime.
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/manage-integration-runtimes
Localization
Azure Purview is localized in 18 languages. To change the language used, go to the Settings from the top bar and select the desired language from the dropdown.
Blogpost:
Documentation:
https://docs.microsoft.com/en-us/azure/purview/use-azure-purview-studio#localization
SQLBITS 2022
SQL BITS 2022
Volunteer
This year I volunteered for the first time. That means being at the site early every day at 7:30 AM. After we have had the briefing, each volunteer can take up his task. For me, these tasks mainly consisted of monitoring and moderating various sessions, so that the speaker can focus on his sessions and that any questions from the Virtual attendees could be passed on to the speaker. In addition to monitoring this session, you serve as a source of information and an example for visitors and you are part of the Orange Family.
Sessions
On Friday it was finally time to present my own sessions. I started the day with my session on:
Lake Database with Database Template and Mapping Data with Azure Synapse Analytics
Microsoft asked me to present me this session during SQL Bits in the Cloud Scale Analytics solution area.
Once again thank you Tony and Wee Hyong for inviting me.
The room was well filled and there were quite a few questions, which is always very nice as a speaker.
One of the questions I didn't have the answer on was:
If you use Power BI on a Lake Database, will the data be read via the Synapse SQL Serverless Pool or directly from the Data Lake.
Reply:
The data is read via the Synapse SQL Serverless Pool and the costs are also charged for this.
A good question that I hadn't thought about beforehand.
My slides can be found on SlideShare
Data Governance with Azure Purview - Ask the Experts
In this session, everyone had the opportunity to ask Victoria, Wolfgang, and me for all of their questions about Azure Purview. During the session we were helped by Richard, who moderated all the questions. We had received a decent set of questions in advance and also during the session many questions were asked by both the Virtual attendees and the in Person. All in all we have given good answers, got some great feedback. It was the first time that we did an Ask the Expert session and we said to each other that we should definitely do this more often.
Final Word
The Friday evening was traditionally closed with a theme party and some can empathize with that. I've seen the craziest costumes pass by.
Saturday I attended sessions all day. We ended the day with the some and drinks in an Italian restaurant.
Sunday was the day of departure, testing and checking in. I can look back on this event tired and satisfied. Once again a big compliment to the organisation, volunteers and speakers for organizing this fantastic event. See you next year.
And Sponsors thank you for making this event happening. Thank you
Speaking at SQL BITS 2022
SQL BITS 2022
Not 1 but 2 sessions
This year I will not present 1 session but 2 sessions.
Data Governance with Azure Purview - Ask the Experts
In this session you have to chance to ask any question on data governance for your business using Azure Purview.
We have a panel of 3 MVPs, Victoria, Wolfgang and myself. Richard we help us out with moderating the session.
If you have an urgent question, feel free to ask it via this form https://forms.office.com/r/dTP38LnmsJ
Of course you can also ask your question live during our session on Friday 11 March from 14:10-15:00. You will find us in room 04.
Looking forward to you all
Lake Database with Database Template and Mapping Data with Azure Synapse Analytics
Microsoft asked me to present a session during SQL Bits in the Cloud Scale Analytics solution area.
Of course I wanted to do that, it is an honor to be asked to do so. Once again thank you Tony and Wee Hyong for inviting me.
In this session I will take a closer look at Database Template in Azure Synapse Analytics
Database templates in Azure Synapse Analytics are blueprints which can be used by organizations to plan, architect and design solutions.
How can we use these Database Templates in a day-to-day business, in order to speed up to automate this process? Map data tool can help us with that. The map data tool can generate a mapping data flow without having to start from a blank canvas. In this presentation, you will see how this all works in a step-by-step demo-based session.
The session is on Friday 11 March from 12:00-12:50 and will be like the above session in Room 04
Do you want to know more which sessions Microsoft is delivering: Ready for SQLBits 2022? - Microsoft Tech Community
Oh yeah, Thursday 10 March, 9:00 am, the keynote will start, which is being led by Bob Ward, along with Buck Woody, Anna Hoffman, Patrick LeBlanc, Evangeline White, and Pedro Lopes, to show you, from SQL Server on-prem to Azure Data in the cloud, the latest and greatest data platform on earth! You better not miss this one, promises to be a nice keynote.
My first Virtual session in 2022 for Dataminds
DataMinds
This Tuesday I've joined the DataMinds user Group to talk about Azure Purview.
Azure Purview
It was the first session of the year for both me and DataMinds. Some great questions during the session, thank you for that.
You can find my slides below on Slideshare:
In case you have any questions left please feel free to ask them via the comment or Socials










