Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm writing a Gen2 dataflow to load some data into a Fabric Warehouse. When I create the "destination", the dialogs don't seem to have a place to enter what schema I want the tables created in - it defaults to dbo and I don't see a way to change that. Is it possible to write to schemas other than dbo - and if so how do I specify the proper schema?
Thanks!
Scott
Solved! Go to Solution.
Hi Scott,
You are correct, currently we only support dbo schema. It is in our current plan to add support for specifying a different schema by Q12024.
Here is an idea for this, please vote: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=452b78e0-0300-ef11-a73c-6045bdbe85bd
@v-gchenna-msft is it safe to ALTER SCHEMA in Fabric? For transferring tables to a different schema than DBO after loading it to Warehouse
Hi Scott,
You are correct, currently we only support dbo schema. It is in our current plan to add support for specifying a different schema by Q12024.
Hi @miquelladeboer , haven't seen any updates on this and didn't hear anything at the Fabric conference - any idea how far away supporting schemas in Warehouses is?
Thanks!
Scott
Hi @Scott_Powell, we currently do not have an exact timeline to share, but it is in our plans to support in the future.
Hi @Scott_Powell ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the March 2024 Fabric update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |