Forum Discussion

Blzvini's avatar
Blzvini
New Member
3 years ago

Help with more schemas in sql endpoint

Hello! I'm trying to use more than one schema within my sql endpoint, but I'm not succeeding. Could someone help me? The tables that are created in my notebooks, go straight to [dbo], but I would like to send some to [Stage]. I tried to pass the tables using a query with ALTER SCHEMA but the tables don't load there. These tables are in Delta format!

is it possible to take the Stage path and create the tables within it?

 



data engineering
Data Integration
data science
data warehouse

2 Replies

  • HimanshuS-msft's avatar
    HimanshuS-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Hello @
    Thanks for using the Fabric community.
    Yes thats very much possible . If possible can you share the notebook code .

    I am asuming that you are not passing the schema name in the notebook and so it defaults to dbo . If you add the correct schema in the notebook , its should create the table with the correct schema .


    Thanks
    HImanshu