Forum Discussion
Advocate IIAdd or remove column in Lakehouse table
Thanks for the reply fabricator1 . Please do let me know if the work around helped you. Do let me know if you have any further questions.
Hi fabricator1
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
fabricator1I didn't have the time to try this procedure. I started on it, and one thing I noticed was that when creating a table using Notebook, the table name can only have small letters. I guess that's normal.
I had created the original table using Dataflows Gen 2, and the table name had capital letters.
Anyway I decided to delete the table and recreate the table using Dataflows Gen 2. For my current purpose, that was okay.
I hope there will be a feature to add or remove columns in a Lakehouse table without having to delete and recreate the table. I created it as an idea: Microsoft Idea- AndyDDC
Most Valuable Professional
Hi fabricator1 , not sure if this helps with your particular scenrio but you could try the column mapping feature which allows you to alter/drop/add columns in a Lakehouse table by following this (it's databricks but it works in Fabric too). It's a one way operation on the table itself and can't be reversed.
Rename and drop columns with Delta Lake column mapping | Databricks on AWS
- fabricator1
Thanks AndyDDC,
This was my original approach, however after I did that I wasn't able to use the table in the SQL Analytics Endpoint and Power BI semantic model.
I guess that's what's mentioned here:
Is it working on your side after making such changes?
