Rosette Kastime-travel-in-microsoft-fabric.hashnode.dev·Dec 21, 2024Historical Data StorageQuerying Historical Data using Time Travel 1 Time Travel Syntax Use the @ symbol followed by a timestamp to specify the desired time point in your queries. 2 Example Query Select * from SalesData where OrderDate @ '2024-01-01' to query data from Janu...Data Retantion
Sandeep Pawarfabric.guru·Dec 20, 2024QuickTest: Switching Between Fabric Python And PySpark NotebooksFile this under a test I have been wanting to do for some time. If I am exploring some data in a Fabric notebook using PySpark, can I switch between Python and PySpark engines with minimal code changes in an interactive session? The goal is to use th...840 readspysaprk
Sachin Nandanwarwww.azureguru.net·Dec 18, 2024Demystifying roles and access in Microsoft Fabric lake houseIn Microsoft Fabric, SQL analytics endpoint is automatically generated for a Lakehouse. With SQL analytics endpoint a user can view the Lake house data using TSQL. When it comes to lakehouse roles and access the lakehouse security model is not comple...29 readsmicrosoftfabric
Sandeep Pawarfabric.guru·Dec 18, 2024Scan Fabric Workspaces With Scanner API Using Semantic Link LabsIt’s finally here 🎉! Thanks to Michael Kovalsky, one of the most requested & anticipated APIs in now available in Semantic Link Labs (v0.8.10) - the Scanner API. The Scanner API in Fabric Admin REST APIs allows Fabric administrators to retrieve deta...1 like·769 readsscanner api
Nalaka Wanniarachchibidiaries.com·Dec 17, 2024🚀 Supercharge Your Data Migration with the Right Azure VM: A Guide for Massive Data Transfers!Migrating terabytes of data from on-premises servers to the cloud is no small feat. The success of such an operation heavily depends on choosing the right infrastructure. This is where Azure Virtual Machines (VMs) come in, providing the flexibility, ...FabricAzure
Nalaka Wanniarachchibidiaries.com·Dec 17, 2024How Databricks Plays Nicely with All Major Clouds: Azure, AWS, and GCP ✨If you've been working in the data world, you've probably heard the name Databricks thrown around—and for good reason! Built on top of Apache Spark, Databricks is a powerhouse for big data processing, machine learning, and analytics. But here's the m...OtherDatabricks
Sachin Nandanwarwww.azureguru.net·Dec 16, 2024Use GraphQL API in Microsoft Fabric to query Cosmos DBAt the beginning of December 2024 Microsoft released “Microsoft Fabric API for GraphQL™ for Azure Cosmos DB Mirroring.” https://devblogs.microsoft.com/cosmosdb/microsoft-fabric-api-for-graphql-for-azure-cosmos-db-mirroring/ With this feature, you can...microsoftfabric
Nalaka Wanniarachchibidiaries.com·Dec 14, 2024🌟 Integrating Managed Identity(MI) and Service Principal for Secure Data Movement: From Azure SQL to Microsoft Fabric via Key Vault 🔒In the world of Azure, managing secure connections between services is critical for building scalable and secure cloud solutions. 🚀 One key tool to achieve this is Managed Identity (MI). But what is it, and how does it work in the context of Azure D...32 readsFabricAzure
Sandeep Pawarfabric.guru·Dec 11, 2024Upgrade Fabric Workspaces To The Latest GA RuntimeIt’s always a good idea to use the latest GA runtime for the Spark pool in Fabric. Unless you change it manually, the workspace will always use the previously set runtime even if a new version is available. To help identify the runtime that workspace...266 readsspark
Sachin Nandanwarwww.azureguru.net·Dec 11, 2024Integrating Livy API with Microsoft FabricLivy API is an open-source REST API that enables interaction with an Apache Spark cluster. It acts as a lightweight interface that allows developers to submit Spark jobs, manage their execution remotely through a RESTful interface and retrieve result...38 readsmicrosoftfabric