SQL Server in Microsoft Fabric? Use CETaS to move data!

SQL Server has been a topic of interest in the context of Microsoft Fabric, with numerous inquiries. Bob Ward has proposed a solution to this, utilizing CETaS and OneLake shortcut capabilities to transition SQL data into Fabric. Consequently, this data can be utilized in Power BI. An updated list with unmentioned references include:

• Azure Synapse Link for SQL: A feature facilitating almost immediate analysis over SQL Server 20222 operational data. It supports analytics, business intelligence, and machine learning on operational data with minimum impact on source databases, thanks to a new change feed technology.
• Object Storage Integration: SQL Server 2022 has introduced object storage integration which allows SQL Server to integrate with S3-compatible object storage and Azure Storage. This includes back up to URL and Data Lake Virtualization, integrating PolyBase with S3-compatible object storage and support for querying parquet files using T-SQL.

Diving Deeper into the Topic

A deeper understanding of the solutions provided by Bob Ward entails appreciating CETaS' role and OneLake's shortcuts. The ability to utilize Azure Synapse Link for SQL for quick analytics over operational data is transformative. This minimizes the impact on source databases and empowers users with business analytics and machine learning capabilities. Moreover, SQL server 2022's object storage integration with S3-compatible object storage and Azure Storage broadens its application and utilisation for its users. It not only incorporates backup to URL but also introduces a new approach to data storage management through Data Lake Virtualization.

Learn about SQL Server in Microsoft Fabric? Use CETaS to move data!

SQL Server is a popular database management system from Microsoft. It can be used in Microsoft Fabric to move data using CETaS and OneLake. SQL Server 2022 brings new features such as Azure Synapse Link for SQL, Object Storage Integration and Data Virtualization. Azure Synapse Link for SQL provides near real-time analytics over operational data with minimum impact on source databases. Object Storage Integration allows backup to URL and integrates PolyBase with S3-compatible object storage. Data Virtualization integrates PolyBase with Hadoop, Azure Data Lake Store, and Azure Blob Storage. Additionally, SQL Server 2022 provides support for querying parquet files with T-SQL.

SQL Server in Microsoft Fabric also offers other features such as Azure Synapse Analytics, which is a cloud-based analytics platform that helps organizations analyze data from a variety of sources. Additionally, it provides advanced analytics capabilities such as machine learning, data wrangling, and data visualization. Additionally, SQL Server in Microsoft Fabric provides support for Power BI, which is a cloud-based business analytics service that enables organizations to analyze data and share insights.

Overall, SQL Server is an important part of Microsoft Fabric and provides a variety of features to help organizations move data, analyze data, and share insights. With SQL Server 2022, organizations can make use of new features such as Azure Synapse Link for SQL, Object Storage Integration and Data Virtualization. Additionally, SQL Server provides support for Azure Synapse Analytics, Power BI, and other advanced analytics capabilities.

More links on about SQL Server in Microsoft Fabric? Use CETaS to move data!

CETAS with Synapse SQL - Azure

Mar 28, 2023 — When using serverless SQL pool, CETAS is used to create an external table and export query results to Azure Storage Blob or Azure Data Lake ...

Move and transform data with dataflow and data pipelines

May 23, 2023 — Step 1: Create a dataflow ... Choose your Fabric enabled workspace, and then select New. Then select Dataflow Gen2. Screenshot showing where to ...

WITH common_table_expression (Transact-SQL)

May 23, 2023 — A view that contains a recursive common table expression can't be used to update data. Cursors may be defined on queries using CTEs. The CTE is ...

CREATE EXTERNAL TABLE AS SELECT (CETAS) ...

May 18, 2023 — CREATE EXTERNAL TABLE AS SELECT (CETAS) creates an external table and then exports, in parallel, the results of a T-SQL SELECT statement.

Connectivity to data warehousing - Microsoft Fabric

Jun 8, 2023 — Microsoft Microsoft Fabric supports connectivity to the Warehouse or SQL Endpoint using ODBC. Make sure you're running the latest ODBC Driver ...

Azure SQL—General availability updates for late-April 2023

Apr 26, 2023 — SQL Managed Instance now supports CETAS (“Create External Table As Select”) functionality. This feature allows users to export data from local ...

How to use CETAS on serverless SQL pool to improve ...

Jul 19, 2022 — Serverless SQL pool has a very cool way to handle CREATE EXTERNAL TABLE AS SELECT (CETAS). I mean, you can use a serverless SQL pool to ...

Part 2 of 4 – Creating a Dimensional Model

In this scenario we will use the CETAS statement to create an External Table to load the source CSV data and save into the Parquet file format. We are using the ...

Serverless SQL – Azure Synapse Analytics & Microsoft Fabric

Using CETAS in Serverless SQL Pools to write results to Azure Data Lake Gen2 ... Getting Started with Microsoft Fabric: Enabling 60-Day Trial and Analysing ...

Keywords

1. SQL Server 2022 2. Azure Synapse Link 3. Object Storage Integration 4. Data Virtualization 5. Power BI Integration