how to increase character length for a column in a table I am loading from Oracle to Snowflake
timdriscollrl
Registered Posts: 1 ✭
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
Tagged:
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,107 Neuron
Can you please post a screen shot of the part of the flow that's relevant?