Help with more schemas in sql endpoint

[Blzvini]

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?

[HimanshuS-msft]

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

[Don_Miguel]

Hi,

Have you tried this:

Write a cross-database query

Cheers,
M