Introducing API for GraphQL and User Data Functions in Microsoft Fabric

on YouTube ↗40m

" summary

Microsoft Fabric now exposes an API-for-GraphQL in public preview that serves data from warehouses, lakehouses and mirrored databases (SQL, Cosmos, Snowflake) with one API call across warehouses, auto-discovered schemas, relationships for joins, views and stored-procedure queries exposed as GraphQL queries/mutations, and Entra ID passthrough auth; plus a private-preview User Data Functions item that runs Python/C# code, integrates with pipelines, supports dependencies and has a VS Code local debug and publish loop for deploying functions back to Fabric.

AI-written summary · about

" chapters (26)

1. 0:00Welcome
2. 1:17Agenda and new Fabric features
3. 2:20Contoso Outdoors scenario
4. 3:01Portal data challenge with GraphQL
5. 4:46What is GraphQL and why use it
6. 5:54GraphQL API in public preview
7. 7:18Creating and testing GraphQL API
8. 9:03Joining data with relationships
9. 10:34Integrating GraphQL with React portal
10. 12:20Views and stored procedures in GraphQL
11. 14:31Multiple data sources in one query
12. 15:57Authentication and security
13. 17:01Updating data with mutations
14. 18:29Key takeaways from demo
15. 20:14User data functions for analytics
16. 21:21Integration with Fabric
17. 22:26User data functions sneak peek
18. 24:17Creating simple user data function
19. 25:22Building complex user data function
20. 27:30Debugging functions with VS Code
21. 29:19Invoking functions from pipelines
22. 30:46Displaying projections in portal
23. 31:33Functions availability and languages
24. 33:15Fabric extension for VS Code
25. 35:01Resources and closing
26. 36:27Q&A

" related talks

• 27mModernize your data integration to enable petabyte scale analytics with Microsoft FabricWee Hyong Tok, Shireen Bahadur · Microsoft Build 2023
• 50mMicrosoft Fabric Data Factory Q&AWee Hyong Tok, Olivia Shea, Nellie Gustafsson, Justyna Lucznik, Shawndell Elfring, Miquella de Boer, Chris Finlan, Cristin Ford, Mark Kromer, Martin Lee, Piero Morano · Microsoft Build 2023
• 19mAccelerate your data potential with FabricSwetha Mannepalli · Microsoft Build 2023
• 51mOne dataset and three use cases with Microsoft FabricPrathyusha(Prathy) Kamasani · SQLBits 2024
• 47mData Mesh vs Data Fabric - in Microsoft FabricMarthe Moengen · SQLBits 2024
• 49mYour first flight with Data Factory in Microsoft FabricKrishnakumar Rukmangathan, Ulrich Christ · SQLBits 2024
• 51mA Deep Dive into Microsoft Fabric Data WarehouseJerry Nixon, Mark Pryce-Maher · SQLBits 2024
• 38mGraphQL: New services and tools for building API-driven appsDavide Mauri, Thomas Gauvin, Adrian Hall · Microsoft Build 2023