Forum Discussion
Create lakehouse tables with script
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) )
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)
)
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.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 .
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 .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .R1k91 : It works for me! I need to change some data types (bit -> boolean, datetime2 -> timestamp).
Thanks!
Hi cw88 , Anonymous
Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.
