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…
Query to check Statistics of tables in an Azure SQL Server database
To include the schema in the query to check statistics on a table in Azure SQL Server, you can modify the query as follows: The columns in the query provide…
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…
How does CloudOps support DevOps practices?
CloudOps and DevOps share a common goal: delivering applications and services faster and more reliably. However, they focus on different aspects of the IT lifecycle. Here’s how CloudOps empowers DevOps…
What are the key differences between traditional IT operations and CloudOps?
Traditional IT operations and CloudOps represent two different approaches to managing IT infrastructure and services. Let’s explore the key differences between them in detail with examples: Infrastructure Management: Focus: Automation:…
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…