Data Saturday Stockholm
Data Saturday Stockholm
My slides can be found on SlideShare
Handy links:
Azure Data Factory Naming Conventions - Erwin & BUSINESS ANALYTICS (erwindekreuk.com)
Data Toboggan January 2022 (Video)
Recording of my session during the Data Toboggan January 2022 conference.
Dealing with different roles in Azure Synapse Analytics
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










