how to increase character length for a column in a table I am loading from Oracle to Snowflake

timdriscollrl

I keep getting the below error when I am trying to load data from oracle to snoowflake using a dataiku sql query recipe.

User character length limit (25) exceeded by string 'Gomez Hidalgo del Castillo' File 'snowflake_stage/snowflake_stage/tmp.FBe55Q5TgEnla6Jj/out-s0-c1.csv.gz', line 2939, character 1 Row 2939, column "MSTR_SALES_ASSOC_SYNC"["LAST_NAME":1] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.

for context the SQL query recipe I am running includes a select * from a certain table in oracle

Turribeach

Can you please post a screen shot of the part of the flow that's relevant?