Reply
Blzvini
New Member

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?

Blzvini_0-1689259927903.png

 



2 REPLIES 2
HimanshuS-msft
Community Support
Community Support

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
Regular Visitor

Hi,

Have you tried this:

Write a cross-database query

 

Cheers,
M

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)