Some of my on-run-end hooks are stalling out with ...
# community-support
b
Some of my on-run-end hooks are stalling out with an error: value too long for type character varying (4096). I saw in the chat history that at some point the data type was made configurable (perhaps in 0.4.12) so that very long queries could be stored successfully, but I am unable to find any documentation on how to increase the size of the varchar type. can someone point me in the right direction?
s
Also running into this error myself. Just wanting to follow this thread in case someone posts an answer here.
b
looking at the logs, I think its happening when the end hook is trying to create either the elementary_test_results table or the dbt_tests table. Its possible that one of the tests is creating a sql string that is too large for a 4906 varchar max. how can i configure the max to store more chars?
m
Hey @Samuel Bradbury and @Benjamin Bloch, Any chance you can figure out which column is failing? I'm asking so we can change it from string to long string in the code. As an ad-hoc solution, please find your local file:
packages/elementary/macros/utils/data_types/data_type.sql
And change this part:
Copy code
{% macro default__edr_type_string() %}
    {# Redshift #}
    {% do return("varchar(4096)") %}
{% endmacro %}