Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
southgrad10
Advocate I
Advocate I

Fabric Warehouse Limitations - T-SQL

Hello,

 

I have created a warehouse in Fabric and was surprised to see that I could not drop a column. I understand that there are many limitations per the attached link, but I'm wondering, should we expect to be able to use ALTER TABLE DROP COLUMN in the future?  Is it doable?  Thank you!

 

https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

 

1 ACCEPTED SOLUTION

Hi @southgrad10 
Though the document was created before, we continiously update if there are any changes. Hence the document is upto date. The commands are the same.

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

View solution in original post

6 REPLIES 6
v-nikhilan-msft
Community Support
Community Support

Hi @southgrad10 
Thanks for using Fabric Community.

You're right, currently, Microsoft Fabric doesn't directly support theALTER TABLE DROP COLUMNcommand for data warehouses, as mentioned in the link you shared. There's no official confirmation from our team regarding the availability of this feature.

Here's why:

  • Focus on data immutability: Fabric warehouses prioritize data immutability, meaning data shouldn't be modified after it's loaded. Dropping columns would alter existing data, potentially breaking downstream processes relying on the original schema.
  • Alternative approaches: Microsoft recommends alternative approaches for modifying tables, such as:

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

Thank you for the quick and prompt response, as always.

 

The link that I provided is dated 11/15/2023.  Are the commands listed still the same?  I am just wondering if there is a more up-to-date source for these limitations somewhere else.

 

southgrad10_0-1709727004791.png

 

Hi @southgrad10 
Though the document was created before, we continiously update if there are any changes. Hence the document is upto date. The commands are the same.

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

Hi @southgrad10 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

Thank you!  I always enjoy getting responses from you.  Very helpful!

Hi @southgrad10 
You're very welcome. I'm glad I could be of assistance. Its my pleasure that I could help you.
Hope you have a great day!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors