How to Modify Column Type in Existing table in Lakehouse

[Murtaza_Ghafoor]

Modify Command is not available, so how can we modify column type in existing table?

[Anonymous]

Hi @Murtaza_Ghafoor ,

Thanks for the reply from lbendlin .

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

I offer another method for your consideration. You can change the type of columns in Data Wrangler.

First, run this code in notebook to load the data using the Spark API.

df = spark.read.format(“csv”).option(“header”, “true”).load(“Files/orders/2019.csv”)

# df now is a Spark DataFrame containing CSV data from “Files/orders/2019.csv”.

display(df)

After running it select Data Wrangler.

Select schema>>Change Column Type under Data Wrangler.

Select the columns you want to change and the type you want to change, and finally click Apply.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Murtaza_Ghafoor · Accepted solution]

My case is different, I am copying multiple  tables in single  copy activity  and  I found  a solution  as well.

Alter Table_Name alter Column_Name column type constrain.

[AndyDDC]

Hi @Murtaza_Ghafoor  how have you altered the column data type?  If you do this, you will likely break the metadata sync to the Lakehouse SQL Endpoint as altering columns and changing data types is not supported for scenarios where the lakehouse delta tables need to syncronise with the sql endpoint.

[lbendlin]

Edit the Destination Table Column Type when Copying Data to Lakehouse Table, Data Warehouse and SQL ...