Nick Saroki
11/14/2022, 5:37 PM2022-11-14 15:23:23 INFO i.a.w.g.DefaultNormalizationWorker(run):93 - Normalization executed in 13 seconds.
2022-11-14 15:23:23 ERROR i.a.w.g.DefaultNormalizationWorker(run):101 - Normalization Failed.
2022-11-14 15:23:23 INFO i.a.w.g.DefaultNormalizationWorker(run):106 - Normalization summary: io.airbyte.config.NormalizationSummary@68a2f518[startTime=1668439390337,endTime=1668439403632,failures=[io.airbyte.config.FailureReason@fba5e53[failureOrigin=normalization,failureType=system_error,internalMessage=invalid input syntax for type double precision: "",externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@15c237d4[additionalProperties={attemptNumber=0, jobId=3, from_trace_message=true}],stacktrace=AirbyteDbtError:
1 of 1 ERROR creating table model temp_workspace.get_merchant_listings_all_data......................................... [ERROR in 0.16s]
Database Error in model get_merchant_listings_all_data (models/generated/airbyte_tables/temp_workspace/get_merchant_listings_all_data.sql)
invalid input syntax for type double precision: ""
compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/temp_workspace/get_merchant_listings_all_data.sql
It's importing JSON into a temp table, but won't move from there.Nick Saroki
11/14/2022, 6:39 PM"quantity": ""Nick Saroki
11/14/2022, 6:40 PMNick Saroki
11/14/2022, 6:45 PMNick Saroki
11/14/2022, 7:08 PMuser
12/06/2022, 8:25 PMNick Saroki
12/26/2022, 3:12 PMSaj Dider (Airbyte)
12/30/2022, 6:37 PM