How to save a T-SQL Query as Table in Microsoft Fabric

Introduction

In this tutorial, we will explain step-by-step how to save a T-SQL query as table in Microsoft Fabric.

Goal

Step 1: Open Data Warehouse Experience

We have already signed in into Fabric and opened the Data Warehouse Experience. We have selected the workspace "dlnerds_workspace".

Here you can see the Data Warehouse Experience.

Step 2: Open Data Warehouse Explorer

Open the warehouse from which you want to query data. We open the warehouse "dlnerds_warehouse".

Step 3: Open SQL Query

Open the SQL Query that you want to save as view. We have already created the SQL query "dlnerds_select_female_student". If you want to know how to create a SQL query check out the following post:

How to query Data from a Fabric Warehouse with T-SQL

Introduction In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse using T-SQL. Goal Data should be queried from a table in the warehouse with T-SQL. Data We consider the table student that is stored in the warehouse “dlnerds_warehouse”. Step 1: Open Data Warehouse

Deep Learning Nerds | The ultimate Learning Platform for AI and Data ScienceData Analyst

You can find all your SQL queries on the left-hand side under "Queries". We open the SQL query "dlnerds_select_female_student".

Step 4: Run SQL Query

Click on "Run" to execute the query.

Once the query has been executed, the results appear below in the Results section.

Step 5: Save SQL Query as table

Now, let's save the SQL query as table. In order to do this, select the text the SQL statement and click on "Save as table".