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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
smpa01
Super User
Super User

Delta Table Column name length

The doc mentions following.

 

smpa01_0-1722912703510.png

But I have been able to create delta tables with columns that are 63 characters in length. Some examples below

smpa01_1-1722912917323.png

smpa01_2-1722913024946.png

Can someone form MS please confirm. Is there really any restricition on the length of the column, if yes, whay am I able to create these columns in the delta table with these names?

 

smpa01_4-1722913143823.png

Thank you in advance.

 

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hi @smpa01 

 

Based on my testing, the maximum length of a column name is actually 128 characters. If the length of the column name is greater than 128 characters, the following error message is returned when loading to a delta table:

vjingzhanmsft_0-1722929351813.png

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

1 REPLY 1
v-jingzhan-msft
Community Support
Community Support

Hi @smpa01 

 

Based on my testing, the maximum length of a column name is actually 128 characters. If the length of the column name is greater than 128 characters, the following error message is returned when loading to a delta table:

vjingzhanmsft_0-1722929351813.png

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.