Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

Delta Table Column name length

The doc mentions following.

 

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

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?

 

Thank you in advance.

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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:

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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:

     

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