Forum Discussion

SachinNandanwar's avatar
SachinNandanwar
Impactful Individual
2 years ago

Alter Table in Fabric

I am trying to drop a column through SQL endpoints using the ALTER table command but it errors out with a message : "Specific statement is not suported" Please note I am trying to alter a table in...
data engineering
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SachinNandanwar,

Can you please share some more detailed information about these operations? They should help us clarify your scenario and test to troubleshoot.

For example:

Are you directly executed these on the data warehouse Editor or use external tools to connect to the data warehouse?
Any reference on the table from other workflows or features? Did this table add to the semantic model?

Regards,

Xiaoxin Sheng

  • SachinNandanwar's avatar
    SachinNandanwar
    Impactful Individual
    2 years ago

    Hi Anonymous ,

    I am not using any external tools.We have a redudant column on a table which needs to be dropped.Executing  ALTER TABLE...DROP COLUMN is erroring out.

    Now this table is being referenced in the semantic model and we are not sure if dropping the table and recreating it with the necessary columns would break the existing model.


    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi SachinNandanwar,

      OK, I test these operations on my side, and they also be blocked due to the limits. For your scenario, perhaps you can try to remove the not need columns at the 'data ingestion' steps.

      Regards,

      Xiaoxin Sheng

      • SachinNandanwar's avatar
        SachinNandanwar
        Impactful Individual
        2 years ago

        For the time being we would send default values to the column. I came to know that ADD column statement works with the ALTER TABLE but not the DROP column .

        Any tentative timelines when this feature would be available ?