cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

dbt error: Data too long for column at row 1

611124
New Contributor II

Hi there!

We are experiencing a Databricks error we donโ€™t recognise when we are running one of our event-based dbt models in dbt core (version 1.6.18). The dbt model uses the โ€˜insert_by_periodโ€™ materialisation that is still experimental for version 1.6.18.

The error message states:

 Error during request to server: (conn=4757514) Data too long for column 'session_data' at row 1

We could narrow down the timeframe of the events in which this error occurs but not the error itself, since there is no column called โ€˜session_dataโ€™ . Has anyone encountered the same error before and knows what the issue might be?

We hope that we wonโ€™t get the same error message again once we have upgraded to dbt version 1.9.1, since the โ€˜insert_by_periodโ€™ period wonโ€™t be experimental anymore but it would be good to get to the bottom of this until then.

Thanks!

 

4 REPLIES 4

NandiniN
Databricks Employee
Databricks Employee

This KB https://kb.databricks.com/metastore/data-too-long-for-column documents the cause and solution.

Can you please check the table definition if session_data is an implicit column added.

611124
New Contributor II

Hi there! Thank you for your reply and the link, I'll take a look. 

Unfortunately, session_data isn't an implicit column either.

 

NandiniN
Databricks Employee
Databricks Employee

Can you please try if you are seeing this error with the latest dbt version?

611124
New Contributor II

We are yet to upgrade dbt core to the latest version but will check again once we have done so.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group