Forum Discussion
Fabric
Hi all,,,
I am trying to read the necessesary data from customer tables in fabric sql end point. as a part of it i am creating views and now i have to update some columns as per the requirement.
I am unable to update my views and it says that i cant create temp table in sql endpoint in fabric. SO now how do i update my columns?
Kin
Hi JYOCH ,
As the following official documentation refers, the SQL analytics endpoint in Microsoft Fabric operates in read-only mode over lakehouse delta tables. This means you can only read data from delta tables using the SQL analytics endpoint. They can save functions, views, and set SQL object-level security. To modify data in Lakehouse delta tables, you have to switch to lakehouse mode and use Apache Spark.
What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
To modify data in Lakehouse delta tables, it is necessary to switch to lakehouse mode and utilize Apache Spark.
Given this, you might find the following alternatives useful:
- Directly modify the underlying tables instead of using a view. The ALTER TABLE statement can be used to add or modify columns in a table.
- Create a new view that includes the updated columns. The CREATE VIEW statement can be used to create a new view based on the existing tables, and the updated columns can be included in the SELECT statement.
Best Regards
1 Reply
Hi JYOCH ,
As the following official documentation refers, the SQL analytics endpoint in Microsoft Fabric operates in read-only mode over lakehouse delta tables. This means you can only read data from delta tables using the SQL analytics endpoint. They can save functions, views, and set SQL object-level security. To modify data in Lakehouse delta tables, you have to switch to lakehouse mode and use Apache Spark.
What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
To modify data in Lakehouse delta tables, it is necessary to switch to lakehouse mode and utilize Apache Spark.
Given this, you might find the following alternatives useful:
- Directly modify the underlying tables instead of using a view. The ALTER TABLE statement can be used to add or modify columns in a table.
- Create a new view that includes the updated columns. The CREATE VIEW statement can be used to create a new view based on the existing tables, and the updated columns can be included in the SELECT statement.
Best Regards