Forum Discussion

cw88's avatar
cw88
Helper IV
2 years ago
Solved

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 ...
data engineering
  • R1k91's avatar
    R1k91
    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)
)

     

     

     
R1k91's avatar
R1k91
Super User
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)
)

 

 

 
cw88's avatar
cw88
Helper IV
2 years ago

R1k91 : Thanks, i will try it 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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 .

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    R1k91 : It works for me! I need to change some data types (bit -> boolean, datetime2 -> timestamp).

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi cw88 , Anonymous 

      Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.