https://community.fabric.microsoft.com/t5/Data-Engineering/Delta-Table-Column-name-length/m-p/4083452#M3451 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/24978">@smpa01</a>&nbsp;</P> <P>&nbsp;</P> <P>Based on my testing, the maximum length of a column name is actually <STRONG>128</STRONG> 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:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vjingzhanmsft_0-1722929351813.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145621i0297DA4D8BB6FD27/image-size/large?v=v2&amp;px=999" role="button" title="vjingzhanmsft_0-1722929351813.png" alt="vjingzhanmsft_0-1722929351813.png" /></span></P> <P>&nbsp;</P> <P>Best Regards,<BR />Jing<BR /><EM>If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos! </EM></P> Tue, 06 Aug 2024 07:34:52 GMT Anonymous 2024-08-06T07:34:52Z https://community.fabric.microsoft.com/t5/Data-Engineering/Delta-Table-Column-name-length/m-p/4082869#M3450 <P>The&nbsp;<A href="https://learn.microsoft.com/en-us/fabric/data-engineering/load-to-tables" target="_self">doc</A> mentions following.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_0-1722912703510.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145403iC706FB26F98BC19A/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_0-1722912703510.png" alt="smpa01_0-1722912703510.png" /></span></P> <P>But I have been able to create delta tables with columns that are 63 characters in length. Some examples below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_1-1722912917323.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145408i552CEF86E0E51DD7/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_1-1722912917323.png" alt="smpa01_1-1722912917323.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_2-1722913024946.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145410i9E7D29A293DFF5AB/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_2-1722913024946.png" alt="smpa01_2-1722913024946.png" /></span></P> <P>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?</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_4-1722913143823.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145414i2D04AC8D53116EA8/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_4-1722913143823.png" alt="smpa01_4-1722913143823.png" /></span></P> <P>Thank you in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 06 Aug 2024 03:08:04 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Delta-Table-Column-name-length/m-p/4082869#M3450 smpa01 2024-08-06T03:08:04Z https://community.fabric.microsoft.com/t5/Data-Engineering/Delta-Table-Column-name-length/m-p/4083452#M3451 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/24978">@smpa01</a>&nbsp;</P> <P>&nbsp;</P> <P>Based on my testing, the maximum length of a column name is actually <STRONG>128</STRONG> 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:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vjingzhanmsft_0-1722929351813.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1145621i0297DA4D8BB6FD27/image-size/large?v=v2&amp;px=999" role="button" title="vjingzhanmsft_0-1722929351813.png" alt="vjingzhanmsft_0-1722929351813.png" /></span></P> <P>&nbsp;</P> <P>Best Regards,<BR />Jing<BR /><EM>If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos! </EM></P> Tue, 06 Aug 2024 07:34:52 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Delta-Table-Column-name-length/m-p/4083452#M3451 Anonymous 2024-08-06T07:34:52Z