How to create a schema using Fabric Notebook and change the table schema from existing default 'dbo'

[bexy]

I am able to create a schema in SQL Analytics endpoint and then able to alter the table schema manually using below steps within SQL Analytics endpoint.

CREATE SCHEMA main -- schema creation

ALTER SCHEMA main TRANSFER dbo.table_name -- change schema from dbo to main

But I want to perform this dynamically using Fabric notebook activity as there are many tables. Please help in this.

[v-nikhilan-msft]

Hi @bexy 
Thanks for using Fabric Community.
Currently creating a new schema in Lakehouse using Notebooks is not available in Fabric. You can query and make transformations to the data present in the dbo schema only.

Solved: Failed to create table and schema - Microsoft Fabric Community

Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Feedback Link : Home (microsoft.com)

Hope this helps. Please let me know if you have any further questions.

[v-nikhilan-msft]

Hi @bexy 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

[v-nikhilan-msft · Accepted solution]

Hi @bexy 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks