Forum Discussion
cw88
2 years agoHelper IV
Create lakehouse tables with script
Hi, i use lakehouse tables as bronze layer, as destination for pipelines with source csv files. This lakehouse tables are the base for views in my warehouse. (create view warehouse.dbo.testview as ...
- 2 years ago
doens't work for you to run a notebook that creates tables?
%%sql CREATE TABLE mytable ( f1 INT, f2 VARCHAR(10) ) CREATE TABLE mytable2 ( f1 INT, f2 VARCHAR(10) ) CREATE TABLE mytable3 ( f1 INT, f2 VARCHAR(10) )
Anonymous
2 years agoNot applicable
Hi cw88 ,
Thanks for using Fabric Community.
As R1k91 said we can create tables in lakehouse using Spark SQL in Fabric Notebooks.
You can also refer this doc for more details -
Working with tables in Microsoft Fabric Lakehouse - Everything you need to know! - Data Mozart (data-mozart.com)
Hope this is helpful. Please let me know incase of further queries.
Anonymous
2 years agoNot applicable
Hello cw88 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .