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

Introduction

In this tutorial, we will explain step-by-step how to save a T-SQL query as view 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: Save SQL Query as view

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