What is Mirroring in Fabric?
Why use Mirroring in Fabric? How to enable Mirroring in my tenant? Platform Near real-time replication Microsoft Fabric mirrored databases from Azure Cosmos DB Yes Microsoft Fabric mirrored databases from…
Data Factory in Microsoft Fabric
In short, Data Factory makes it easy to handle data, whether you’re a beginner or an expert, and it brings your data quickly to where you need it for analysis.…
What is difference between Azure Data Factory and Data Factory in Microsoft Fabric
Difference between Azure Data Factory and Data Factory in Microsoft Fabric Some different features concepts of Data Factory in Fabric compared to Azure Data Factory. Azure Data Factory Data Factory…
What is Copilot in Microsoft Fabric?
How to Enable Copilot? Copilot for Data Science and Data Engineering Copilot for Data Factory Copilot for Power BI How Copilot work in Fabric? Available regions Geographic area where your…
Data Factory limitations in Microsoft Fabric
There are certain limitations to the current Data Factory in Microsoft Fabric features. Data pipeline limitations in Microsoft Fabric Data pipeline resource limits The following table describes the resource limitations…
T-SQL in Microsoft Fabric
T-SQL surface area T-SQL Limitations in Microsoft Fabric At this time, the following list of commands is NOT currently supported. Data types in Warehouse Warehouse supports a subset of T-SQL…
How to Write a cross-database query in Microsoft Fabric
Using three-part naming to reference the databases/tables, you can join multiple databases. Using three-part naming to reference the database and tables, you can insert data from one database to another.…
How to Ingest data into your Warehouse using data pipelines
Create a data pipeline How to Ingest data into your Warehouse using the COPY statement Create a table Ingest Parquet data using the COPY statement Ingest CSV data using the…
What is data warehousing in Microsoft Fabric?
Virtual warehouses with cross database querying Data Warehousing experiences in Microsoft Fabric It has two distinct data warehousing experiences in Microsoft Fabric: the SQL analytics endpoint of the Lakehouse and…
What is the SQL analytics endpoint for a Lakehouse?
SQL analytics endpoint read-only mode The SQL analytics endpoint operates in read-only mode over lakehouse delta tables. You can only read data from delta tables using the SQL analytics endpoint.…
Different ways to load data into Microsoft Fabric Lakehouse
There are several ways to load data into your Lakehouse from the explorer page: How to Use a notebook to load data into your Lakehouse? Load data with an Apache…
How to Explore the data in your lakehouse with a notebook
Open or create a notebook from a lakehouse Open a lakehouse from an existing or new notebook Switch lakehouses and set a default You can add multiple lakehouses to the…
What is OneLake shortcuts in Microsoft Fabric?
What are Shortcuts? Where all we can create shortcuts? Creation of Shortcuts in a Lakehouse Creation of Shortcuts in a KQL database From Where can I access shortcuts? Any Fabric…
What is lakehouse in Microsoft Fabric?
What is Lakehouse? Note : The Lakehouse creates a serving layer by automatically generating a SQL analytics endpoint and a default semantic model during creation. How to Interact with the…
What is OneLake in Microsoft Fabric
OneLake is a single, unified, logical data lake for your whole organization. Like OneDrive, OneLake comes automatically with every Microsoft Fabric tenant and is designed to be the single place…
What is Workspace identity in Microsoft Fabric?
In simple terms, a Fabric workspace identity is like a special account that is automatically created and managed by Fabric. This account is linked to a Fabric workspace. Workspaces with…
What is Workspace in Microsoft Fabric?
What is Workspace? Workspaces are places to collaborate with colleagues to create collections of items such as lakehouses, warehouses, and reports. How to Work with workspaces Some useful tips about working…
Some Microsoft Fabric terminology
Definitions of terms used in Microsoft Fabric, including terms specific to Synapse Data Warehouse, Synapse Data Engineering, Synapse Data Science, Synapse Real-Time Analytics, Data Factory, and Power BI. General Terms…
How Microsoft Fabric Works?
Microsoft Fabric has SaaS foundation This integration provides the following advantages: Components of Microsoft Fabric Fabric includes industry-leading experiences in the following categories for an end-to-end analytical need. Data Engineering –…
Introduction to Microsoft Fabric
What is Microsoft Fabric? Microsoft Fabric isn’t a single service but rather a unified platform within Azure Data Services. It essentially brings together various data tools and functionalities under one…