Forum Discussion
Spark SQL to Delta Table
Hey Guys,
I have a short question.
Is it possible to save a table in delta format in MS Fabric with notebooks in Spark SQL?
Thanks for help!
Best Regards
Tim
Hello Anonymous,
thanks for the links you sent me. This is what I was looking for.
%%sql
CREATE TABLE salestable
(
Orderid INT NOT NULL,
OrderDate TIMESTAMP NOT NULL,
CustomerName STRING,
SalesTotal FLOAT NOT NULL
)
USING DELTAI put this here so others with the same problem can find it here directly.
Many thanks and Best Regards
Tim
2 Replies
Hi HarderT ,
As far as I concerned, it is possible to save a table in delta format in MS Fabric with notebooks in Spark SQL. You can use the method of the Spark DataFrame API to specify the format as “delta” and the destination as the Tables section of the lakehouse. For example, if you have a DataFrame called that you want to save as a delta table named , you can use the following code:writedfmy_table
df.write.mode("overwrite").format("delta").partitionBy("Year","Quarter").save("Tables/" + table_name)This will create a delta table in the lakehouse that you can query with SQL or Spark.
Work with Delta Lake tables in Microsoft Fabric - Training | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous,
thanks for the links you sent me. This is what I was looking for.
%%sql
CREATE TABLE salestable
(
Orderid INT NOT NULL,
OrderDate TIMESTAMP NOT NULL,
CustomerName STRING,
SalesTotal FLOAT NOT NULL
)
USING DELTAI put this here so others with the same problem can find it here directly.
Many thanks and Best Regards
Tim
