Forum Discussion

JeffGray's avatar
JeffGray
Icon for Advocate I rankAdvocate I
2 years ago

Column added to Lakehouse table as string shows up as wrong type in SQL Endpoint and Power BI

I have a notebook that adds a column to Lakehouse table using:      spark.sql("alter table EKKO add columns (STATU string);")   Seems to work fine, and I can load data into the column  using a m...
data engineering
lakehouse
notebook
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi , JeffGray,

ALTER TABLE command is not supported for tables in Lakehouse.

This may be helpful to you:
Solved: Re: Lakehouse table column names not reflected in ... - Microsoft Fabric Community

 

The SQL analytics endpoint is read-only  that is automatically generated upon creation from a Lakehouse in Microsoft Fabric. 

The Synapse Data Warehouse or Warehouse is a 'traditional' data warehouse and supports the full transactional T-SQL capabilities like an enterprise data warehouse. 

You can click here for more information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JeffGray's avatar
JeffGray
Icon for Advocate I rankAdvocate I
2 years ago

Thanks Ada.  I think your answer is incorrect.  I understand that SqL endpoint is read only, I altering my Lakehouse table with Spark SQL.  The limitations you are quoting refer to warehouse, and even there, the next sentence after the section you reference says that adding nullable columns IS supported... 

"

Limitations

At this time, the following list of commands is NOT currently supported. Don't try to use these commands. Even though they might appear to succeed, they could cause issues to your warehouse.

  • ALTER TABLE ADD/ALTER/DROP COLUMN
    • Currently, only the following subset of ALTER TABLE operations in Warehouse in Microsoft Fabric are supported:
      • ADD nullable columns of supported column data types"