2022-05-18 18:23:38 INFO i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.36.11-alpha 2022-05-18 18:23:38 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/69/0/logs.log 2022-05-18 18:23:38 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.36.11-alpha 2022-05-18 18:23:38 INFO i.a.w.DefaultReplicationWorker(run):104 - start sync worker. job id: 69 attempt id: 0 2022-05-18 18:23:38 INFO i.a.w.DefaultReplicationWorker(run):116 - configured sync modes: {null.events=full_refresh - overwrite} 2022-05-18 18:23:38 INFO i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination... 2022-05-18 18:23:38 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-bigquery-denormalized:1.1.6 exists... 2022-05-18 18:23:39 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-bigquery-denormalized:1.1.6 was found locally. 2022-05-18 18:23:39 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 69 2022-05-18 18:23:39 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/69/0 --log-driver none --name destination-bigquery-denormalized-write-69-0-okptu --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/destination-bigquery-denormalized:1.1.6 -e WORKER_JOB_ATTEMPT=0 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.36.11-alpha -e WORKER_JOB_ID=69 airbyte/destination-bigquery-denormalized:1.1.6 write --config destination_config.json --catalog destination_catalog.json 2022-05-18 18:23:39 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-timely:dev0.1 exists... 2022-05-18 18:23:39 destination > WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested 2022-05-18 18:23:39 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-timely:dev0.1 was found locally. 2022-05-18 18:23:39 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 69 2022-05-18 18:23:39 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/69/0 --log-driver none --name source-timely-read-69-0-flgwj --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/source-timely:dev0.1 -e WORKER_JOB_ATTEMPT=0 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.36.11-alpha -e WORKER_JOB_ID=69 airbyte/source-timely:dev0.1 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-05-18 18:23:39 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):339 - Destination output thread started. 2022-05-18 18:23:39 INFO i.a.w.DefaultReplicationWorker(run):158 - Waiting for source and destination threads to complete. 2022-05-18 18:23:39 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):279 - Replication thread started. 2022-05-18 18:23:41 source > Starting syncing SourceTimelyIntegration 2022-05-18 18:23:41 source > Syncing stream: events 2022-05-18 18:23:42 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-05-18 18:23:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-05-18 18:23:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-05-18 18:23:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-05-18 18:23:42 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-05-18 18:23:42 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDenormalizedDestination 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-05-18 18:23:46 destination > 2022-05-18 18:23:46 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 INFO i.a.i.d.b.BigQueryUtils(getLoadingMethod):306 - Selected loading method is set to: STANDARD 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 WARN i.a.i.d.b.BigQueryDestination(getConsumer):194 - The "standard" upload mode is not performant, and is not recommended for production. Please use the GCS upload mode if you are syncing a large amount of data. 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 INFO i.a.i.d.b.f.DefaultBigQueryDenormalizedRecordFormatter(formatAllOfAndAnyOfFields):68 - getSchemaFields : {"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"to":{"type":["null","string"]},"day":{"type":["null","string"]},"uid":{"type":["null","string"]},"cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"from":{"type":["null","string"]},"note":{"type":["null","string"]},"user":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"avatar":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"large":{"type":["null","string"]},"medium":{"type":["null","string"]},"timeline":{"type":["null","string"]},"large_retina":{"type":["null","string"]},"medium_retina":{"type":["null","string"]}}}},"updated_at":{"type":["null","string"]}}}},"draft":{"type":["null","boolean"]},"billed":{"type":["null","boolean"]},"locked":{"type":["null","boolean"]},"manage":{"type":["null","boolean"]},"deleted":{"type":["null","boolean"]},"project":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"color":{"type":["null","string"]},"active":{"type":["null","boolean"]},"budget":{"type":["null","integer"]},"client":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"active":{"type":["null","boolean"]},"updated_at":{"type":["null","string"]},"external_id":{"type":["null","string"]}}},"labels":{"type":["null","array"]},"billable":{"type":["null","boolean"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"rate_type":{"type":["null","string"]},"account_id":{"type":["null","integer"]},"updated_at":{"type":["null","integer"]},"budget_type":{"type":["null","string"]},"external_id":{"type":["null","string"]},"budget_scope":{"type":["null","string"]},"enable_labels":{"type":["null","string"]},"budget_percent":{"type":["null","number"]},"has_recurrence":{"type":["null","boolean"]},"required_notes":{"type":["null","boolean"]},"budget_progress":{"type":["null","number"]},"required_labels":{"type":["null","boolean"]},"budget_expired_on":{"type":["null","string"]},"invoice_by_budget":{"type":["null","boolean"]},"budget_calculation":{"type":["null","string"]},"hour_rate_in_cents":{"type":["null","number"]},"required_label_ids":{"type":["null","array"]}}},"billable":{"type":["null","boolean"]},"duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]},"correctedHours":{"type":["null","integer"]}}}},"sequence":{"type":["null","integer"]},"user_ids":{"type":["null","array"]},"billed_at":{"type":["null","string"]},"entry_ids":{"type":["null","array"]},"estimated":{"type":["null","string"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"created_at":{"type":["null","integer"]},"created_id":{"type":["null","integer"]},"invoice_id":{"type":["null","string"]},"timestamps":{"type":["null","array"]},"updater_id":{"type":["null","integer"]},"external_id":{"type":["null","integer"]},"forecast_id":{"type":["null","string"]},"timer_state":{"type":["null","string"]},"created_from":{"type":["null","string"]},"updated_from":{"type":["null","string"]},"locked_reason":{"type":["null","string"]},"suggestion_id":{"type":["null","integer"]},"estimated_cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"timer_started_on":{"type":["null","integer"]},"timer_stopped_on":{"type":["null","integer"]},"estimated_duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]}}}},"hour_rate_in_cents":{"type":["null","integer"]}}} namingResolver io.airbyte.integrations.destination.bigquery.BigQuerySQLNameTransformer@e27ba81 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 INFO i.a.i.d.b.f.DefaultBigQueryDenormalizedRecordFormatter(formatAllOfAndAnyOfFields):68 - getSchemaFields : {"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"to":{"type":["null","string"]},"day":{"type":["null","string"]},"uid":{"type":["null","string"]},"cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"from":{"type":["null","string"]},"note":{"type":["null","string"]},"user":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"avatar":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"large":{"type":["null","string"]},"medium":{"type":["null","string"]},"timeline":{"type":["null","string"]},"large_retina":{"type":["null","string"]},"medium_retina":{"type":["null","string"]}}}},"updated_at":{"type":["null","string"]}}}},"draft":{"type":["null","boolean"]},"billed":{"type":["null","boolean"]},"locked":{"type":["null","boolean"]},"manage":{"type":["null","boolean"]},"deleted":{"type":["null","boolean"]},"project":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"color":{"type":["null","string"]},"active":{"type":["null","boolean"]},"budget":{"type":["null","integer"]},"client":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"active":{"type":["null","boolean"]},"updated_at":{"type":["null","string"]},"external_id":{"type":["null","string"]}}},"labels":{"type":["null","array"]},"billable":{"type":["null","boolean"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"rate_type":{"type":["null","string"]},"account_id":{"type":["null","integer"]},"updated_at":{"type":["null","integer"]},"budget_type":{"type":["null","string"]},"external_id":{"type":["null","string"]},"budget_scope":{"type":["null","string"]},"enable_labels":{"type":["null","string"]},"budget_percent":{"type":["null","number"]},"has_recurrence":{"type":["null","boolean"]},"required_notes":{"type":["null","boolean"]},"budget_progress":{"type":["null","number"]},"required_labels":{"type":["null","boolean"]},"budget_expired_on":{"type":["null","string"]},"invoice_by_budget":{"type":["null","boolean"]},"budget_calculation":{"type":["null","string"]},"hour_rate_in_cents":{"type":["null","number"]},"required_label_ids":{"type":["null","array"]}}},"billable":{"type":["null","boolean"]},"duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]},"correctedHours":{"type":["null","integer"]}}}},"sequence":{"type":["null","integer"]},"user_ids":{"type":["null","array"]},"billed_at":{"type":["null","string"]},"entry_ids":{"type":["null","array"]},"estimated":{"type":["null","string"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"created_at":{"type":["null","integer"]},"created_id":{"type":["null","integer"]},"invoice_id":{"type":["null","string"]},"timestamps":{"type":["null","array"]},"updater_id":{"type":["null","integer"]},"external_id":{"type":["null","integer"]},"forecast_id":{"type":["null","string"]},"timer_state":{"type":["null","string"]},"created_from":{"type":["null","string"]},"updated_from":{"type":["null","string"]},"locked_reason":{"type":["null","string"]},"suggestion_id":{"type":["null","integer"]},"estimated_cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"timer_started_on":{"type":["null","integer"]},"timer_stopped_on":{"type":["null","integer"]},"estimated_duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]}}}},"hour_rate_in_cents":{"type":["null","integer"]}}} namingResolver io.airbyte.integrations.destination.bigquery.BigQuerySQLNameTransformer@e27ba81 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 INFO i.a.i.d.b.BigQueryUtils(getLoadingMethod):306 - Selected loading method is set to: STANDARD 2022-05-18 18:23:47 destination > 2022-05-18 18:23:47 INFO i.a.i.d.b.f.DefaultBigQueryDenormalizedRecordFormatter(getSchemaFields):222 - getSchemaFields : {"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"to":{"type":["null","string"]},"day":{"type":["null","string"]},"uid":{"type":["null","string"]},"cost":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}}}},"from":{"type":["null","string"]},"note":{"type":["null","string"]},"user":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"avatar":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"large":{"type":["null","string"]},"medium":{"type":["null","string"]},"timeline":{"type":["null","string"]},"large_retina":{"type":["null","string"]},"medium_retina":{"type":["null","string"]}}}}}},"updated_at":{"type":["null","string"]}}}}}},"draft":{"type":["null","boolean"]},"billed":{"type":["null","boolean"]},"locked":{"type":["null","boolean"]},"manage":{"type":["null","boolean"]},"deleted":{"type":["null","boolean"]},"project":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"color":{"type":["null","string"]},"active":{"type":["null","boolean"]},"budget":{"type":["null","integer"]},"client":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"active":{"type":["null","boolean"]},"updated_at":{"type":["null","string"]},"external_id":{"type":["null","string"]}}},"labels":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"billable":{"type":["null","boolean"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"rate_type":{"type":["null","string"]},"account_id":{"type":["null","integer"]},"updated_at":{"type":["null","integer"]},"budget_type":{"type":["null","string"]},"external_id":{"type":["null","string"]},"budget_scope":{"type":["null","string"]},"enable_labels":{"type":["null","string"]},"budget_percent":{"type":["null","number"]},"has_recurrence":{"type":["null","boolean"]},"required_notes":{"type":["null","boolean"]},"budget_progress":{"type":["null","number"]},"required_labels":{"type":["null","boolean"]},"budget_expired_on":{"type":["null","string"]},"invoice_by_budget":{"type":["null","boolean"]},"budget_calculation":{"type":["null","string"]},"hour_rate_in_cents":{"type":["null","number"]},"required_label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}}}},"billable":{"type":["null","boolean"]},"duration":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]},"correctedHours":{"type":["null","integer"]}}}}}},"sequence":{"type":["null","integer"]},"user_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"billed_at":{"type":["null","string"]},"entry_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"estimated":{"type":["null","string"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"created_at":{"type":["null","integer"]},"created_id":{"type":["null","integer"]},"invoice_id":{"type":["null","string"]},"timestamps":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"updater_id":{"type":["null","integer"]},"external_id":{"type":["null","integer"]},"forecast_id":{"type":["null","string"]},"timer_state":{"type":["null","string"]},"created_from":{"type":["null","string"]},"updated_from":{"type":["null","string"]},"locked_reason":{"type":["null","string"]},"suggestion_id":{"type":["null","integer"]},"estimated_cost":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}}}},"timer_started_on":{"type":["null","integer"]},"timer_stopped_on":{"type":["null","integer"]},"estimated_duration":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]}}}}}},"hour_rate_in_cents":{"type":["null","integer"]}}} namingResolver io.airbyte.integrations.destination.bigquery.BigQuerySQLNameTransformer@e27ba81 2022-05-18 18:23:48 destination > 2022-05-18 18:23:48 INFO i.a.i.d.b.f.DefaultBigQueryDenormalizedRecordFormatter(getBigQuerySchema):217 - Airbyte Schema is transformed from {"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"to":{"type":["null","string"]},"day":{"type":["null","string"]},"uid":{"type":["null","string"]},"cost":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}}}},"from":{"type":["null","string"]},"note":{"type":["null","string"]},"user":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"avatar":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"large":{"type":["null","string"]},"medium":{"type":["null","string"]},"timeline":{"type":["null","string"]},"large_retina":{"type":["null","string"]},"medium_retina":{"type":["null","string"]}}}}}},"updated_at":{"type":["null","string"]}}}}}},"draft":{"type":["null","boolean"]},"billed":{"type":["null","boolean"]},"locked":{"type":["null","boolean"]},"manage":{"type":["null","boolean"]},"deleted":{"type":["null","boolean"]},"project":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"color":{"type":["null","string"]},"active":{"type":["null","boolean"]},"budget":{"type":["null","integer"]},"client":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"active":{"type":["null","boolean"]},"updated_at":{"type":["null","string"]},"external_id":{"type":["null","string"]}}},"labels":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"billable":{"type":["null","boolean"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"rate_type":{"type":["null","string"]},"account_id":{"type":["null","integer"]},"updated_at":{"type":["null","integer"]},"budget_type":{"type":["null","string"]},"external_id":{"type":["null","string"]},"budget_scope":{"type":["null","string"]},"enable_labels":{"type":["null","string"]},"budget_percent":{"type":["null","number"]},"has_recurrence":{"type":["null","boolean"]},"required_notes":{"type":["null","boolean"]},"budget_progress":{"type":["null","number"]},"required_labels":{"type":["null","boolean"]},"budget_expired_on":{"type":["null","string"]},"invoice_by_budget":{"type":["null","boolean"]},"budget_calculation":{"type":["null","string"]},"hour_rate_in_cents":{"type":["null","number"]},"required_label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}}}},"billable":{"type":["null","boolean"]},"duration":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]},"correctedHours":{"type":["null","integer"]}}}}}},"sequence":{"type":["null","integer"]},"user_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"billed_at":{"type":["null","string"]},"entry_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"estimated":{"type":["null","string"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"created_at":{"type":["null","integer"]},"created_id":{"type":["null","integer"]},"invoice_id":{"type":["null","string"]},"timestamps":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["string"]}}}},"updater_id":{"type":["null","integer"]},"external_id":{"type":["null","integer"]},"forecast_id":{"type":["null","string"]},"timer_state":{"type":["null","string"]},"created_from":{"type":["null","string"]},"updated_from":{"type":["null","string"]},"locked_reason":{"type":["null","string"]},"suggestion_id":{"type":["null","integer"]},"estimated_cost":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}}}},"timer_started_on":{"type":["null","integer"]},"timer_stopped_on":{"type":["null","integer"]},"estimated_duration":{"type":["object"],"properties":{"big_query_array":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]}}}}}},"hour_rate_in_cents":{"type":["null","integer"]}}} to [Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]. 2022-05-18 18:23:53 destination > 2022-05-18 18:23:53 INFO i.a.i.d.b.BigQueryUtils(createPartitionedTable):131 - Partitioned table created successfully: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, tableId=_airbyte_tmp_zzb_events}} 2022-05-18 18:24:08 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 1000 (2 MB) 2022-05-18 18:24:13 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 2000 (5 MB) 2022-05-18 18:24:17 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 3000 (8 MB) 2022-05-18 18:24:21 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 4000 (11 MB) 2022-05-18 18:24:25 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 5000 (14 MB) 2022-05-18 18:24:28 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 6000 (16 MB) 2022-05-18 18:24:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 7000 (19 MB) 2022-05-18 18:24:33 source > Read 7337 records from events stream 2022-05-18 18:24:33 source > Finished syncing events 2022-05-18 18:24:33 source > SourceTimelyIntegration runtimes: Syncing stream events 0:00:49.495577 2022-05-18 18:24:33 source > Finished syncing SourceTimelyIntegration 2022-05-18 18:24:33 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):305 - Total records read: 7337 (20 MB) 2022-05-18 18:24:33 INFO i.a.w.DefaultReplicationWorker(run):163 - One of source or destination thread complete. Waiting on the other. 2022-05-18 18:24:34 destination > 2022-05-18 18:24:34 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-05-18 18:24:34 destination > 2022-05-18 18:24:34 INFO i.a.i.d.b.BigQueryRecordConsumer(close):58 - Started closing all connections 2022-05-18 18:24:34 destination > 2022-05-18 18:24:34 WARN i.a.i.d.b.f.BigQueryRecordFormatter(lambda$printAndCleanFieldFails$0):70 - Field(s) fail with error Ignoring field as it is not defined in catalog. Fields : hours, amount, minutes, formatted, total_minutes, fractional, avatar, total_hours, hour_id, seconds, total_seconds, updated_at, name, creator_id, from, id, to, entry_id, email 2022-05-18 18:24:34 destination > 2022-05-18 18:24:34 INFO i.a.i.d.b.u.AbstractBigQueryUploader(close):78 - Closing connector: AbstractBigQueryUploader{table=events, tmpTable=_airbyte_tmp_zzb_events, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryDenormalizedRecordFormatter} 2022-05-18 18:24:46 destination > 2022-05-18 18:24:46 INFO i.a.i.d.b.BigQueryUtils(waitForJobFinish):327 - Waiting for job finish Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}. Status: JobStatus{state=RUNNING, error=null, executionErrors=null} 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 ERROR i.a.i.d.b.BigQueryUtils(waitForJobFinish):332 - Error is happened during execution for job: Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}, 2022-05-18 18:24:50 destination > For more details see Big Query Error collection: BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details.}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON processing encountered too many errors, giving up. Rows: 727; errors: 1; max bad: 0; error percent: 0}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 1279386: JSON object specified for non-record field: timestamps.big_query_array}: 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 ERROR i.a.i.d.b.u.AbstractBigQueryUploader(close):87 - Failed to close AbstractBigQueryUploader{table=events, tmpTable=_airbyte_tmp_zzb_events, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryDenormalizedRecordFormatter} writer, 2022-05-18 18:24:50 destination > details: Error is happened during execution for job: Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}, 2022-05-18 18:24:50 destination > For more details see Big Query Error collection: BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details.}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON processing encountered too many errors, giving up. Rows: 727; errors: 1; max bad: 0; error percent: 0}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 1279386: JSON object specified for non-record field: timestamps.big_query_array}: 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 INFO i.a.i.d.b.h.LoggerHelper(printHeapMemoryConsumption):28 - Initial Memory (xms) mb = 124 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 INFO i.a.i.d.b.h.LoggerHelper(printHeapMemoryConsumption):29 - Max Memory (xmx) : mb = 5892 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 ERROR i.a.i.d.b.BigQueryRecordConsumer(lambda$close$0):65 - Exception while closing uploader AbstractBigQueryUploader{table=events, tmpTable=_airbyte_tmp_zzb_events, syncMode=WRITE_TRUNCATE, writer=class io.airbyte.integrations.destination.bigquery.writer.BigQueryTableWriter, recordFormatter=class io.airbyte.integrations.destination.bigquery.formatter.DefaultBigQueryDenormalizedRecordFormatter} 2022-05-18 18:24:50 destination > java.lang.RuntimeException: com.google.cloud.bigquery.BigQueryException: Error is happened during execution for job: Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}, 2022-05-18 18:24:50 destination > For more details see Big Query Error collection: BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details.}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON processing encountered too many errors, giving up. Rows: 727; errors: 1; max bad: 0; error percent: 0}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 1279386: JSON object specified for non-record field: timestamps.big_query_array}: 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.uploader.AbstractBigQueryUploader.close(AbstractBigQueryUploader.java:89) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryRecordConsumer.lambda$close$0(BigQueryRecordConsumer.java:62) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at java.util.HashMap$Values.forEach(HashMap.java:1065) ~[?:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryRecordConsumer.close(BigQueryRecordConsumer.java:60) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.lambda$close$0(FailureTrackingAirbyteMessageConsumer.java:67) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) [io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.close(FailureTrackingAirbyteMessageConsumer.java:67) [io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:166) [io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107) [io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryDenormalizedDestination.main(BigQueryDenormalizedDestination.java:72) [io.airbyte.airbyte-integrations.connectors-destination-bigquery-denormalized-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > Caused by: com.google.cloud.bigquery.BigQueryException: Error is happened during execution for job: Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}, 2022-05-18 18:24:50 destination > For more details see Big Query Error collection: BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details.}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON processing encountered too many errors, giving up. Rows: 727; errors: 1; max bad: 0; error percent: 0}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 1279386: JSON object specified for non-record field: timestamps.big_query_array}: 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryUtils.waitForJobFinish(BigQueryUtils.java:333) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.uploader.BigQueryDirectUploader.uploadData(BigQueryDirectUploader.java:27) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.uploader.AbstractBigQueryUploader.close(AbstractBigQueryUploader.java:82) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > ... 9 more 2022-05-18 18:24:50 destination > Caused by: com.google.cloud.bigquery.BigQueryException: Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details. 2022-05-18 18:24:50 destination > at com.google.cloud.bigquery.Job.reload(Job.java:411) ~[google-cloud-bigquery-1.133.1.jar:1.133.1] 2022-05-18 18:24:50 destination > at com.google.cloud.bigquery.Job.waitFor(Job.java:248) ~[google-cloud-bigquery-1.133.1.jar:1.133.1] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryUtils.waitForJobFinish(BigQueryUtils.java:328) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.uploader.BigQueryDirectUploader.uploadData(BigQueryDirectUploader.java:27) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.uploader.AbstractBigQueryUploader.close(AbstractBigQueryUploader.java:82) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > ... 9 more 2022-05-18 18:24:50 destination > 2022-05-18 18:24:50 ERROR i.a.i.b.AirbyteExceptionHandler(uncaughtException):26 - Something went wrong in the connector. See the logs for more details. 2022-05-18 18:24:50 destination > java.lang.RuntimeException: Exceptions thrown while closing consumer: java.lang.RuntimeException: com.google.cloud.bigquery.BigQueryException: Error is happened during execution for job: Job{job=JobId{project=pliancy-data-development, job=6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, location=US}, status=JobStatus{state=RUNNING, error=null, executionErrors=null}, statistics=LoadStatistics{creationTime=1652898286445, endTime=null, startTime=1652898286721, numChildJobs=null, parentJobId=null, scriptStatistics=null, reservationUsage=null, inputBytes=null, inputFiles=null, outputBytes=null, outputRows=null, badRecords=null}, userEmail=airbyte@pliancy-data-development.iam.gserviceaccount.com, etag=NDGA/V+P/5xvUTn1w1BgSQ==, generatedId=pliancy-data-development:US.6d06de4c-9605-4d5f-8da1-0428c4fa4f7f, selfLink=https://www.googleapis.com/bigquery/v2/projects/pliancy-data-development/jobs/6d06de4c-9605-4d5f-8da1-0428c4fa4f7f?location=US, configuration=LoadJobConfiguration{type=LOAD, destinationTable=GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=poke_api, projectId=pliancy-data-development, tableId=_airbyte_tmp_zzb_events}}, decimalTargetTypes=null, destinationEncryptionConfiguration=null, createDisposition=CREATE_IF_NEEDED, writeDisposition=null, formatOptions=FormatOptions{format=NEWLINE_DELIMITED_JSON}, nullMarker=null, maxBadRecords=null, schema=Schema{fields=[Field{name=id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=to, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=day, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=uid, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=note, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=user, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=draft, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=billed, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=manage, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=deleted, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=project, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billable, type=BOOLEAN, mode=NULLABLE, description=null, policyTags=null}, Field{name=duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=sequence, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=user_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=billed_at, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=entry_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=estimated, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=hour_rate, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=label_ids, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=created_at, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=invoice_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timestamps, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=updater_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=external_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=forecast_id, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_state, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=created_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=updated_from, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=locked_reason, type=STRING, mode=NULLABLE, description=null, policyTags=null}, Field{name=suggestion_id, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_cost, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=timer_started_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=timer_stopped_on, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=estimated_duration, type=RECORD, mode=null, description=null, policyTags=null}, Field{name=hour_rate_in_cents, type=INTEGER, mode=NULLABLE, description=null, policyTags=null}, Field{name=_airbyte_ab_id, type=STRING, mode=null, description=null, policyTags=null}, Field{name=_airbyte_emitted_at, type=TIMESTAMP, mode=null, description=null, policyTags=null}]}, ignoreUnknownValue=null, sourceUris=null, schemaUpdateOptions=null, autodetect=null, timePartitioning=null, clustering=null, useAvroLogicalTypes=null, labels=null, jobTimeoutMs=null, rangePartitioning=null, hivePartitioningOptions=null}}, 2022-05-18 18:24:50 destination > For more details see Big Query Error collection: BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON table encountered too many errors, giving up. Rows: 727; errors: 1. Please look into the errors[] collection for more details.}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON processing encountered too many errors, giving up. Rows: 727; errors: 1; max bad: 0; error percent: 0}, 2022-05-18 18:24:50 destination > BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 1279386: JSON object specified for non-record field: timestamps.big_query_array}: 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryRecordConsumer.close(BigQueryRecordConsumer.java:69) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.lambda$close$0(FailureTrackingAirbyteMessageConsumer.java:67) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.FailureTrackingAirbyteMessageConsumer.close(FailureTrackingAirbyteMessageConsumer.java:67) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:166) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107) ~[io.airbyte.airbyte-integrations.bases-base-java-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 destination > at io.airbyte.integrations.destination.bigquery.BigQueryDenormalizedDestination.main(BigQueryDenormalizedDestination.java:72) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-denormalized-0.38.3-alpha.jar:?] 2022-05-18 18:24:50 INFO i.a.w.DefaultReplicationWorker(run):165 - Source and destination threads complete. 2022-05-18 18:24:50 INFO i.a.w.DefaultReplicationWorker(run):228 - sync summary: io.airbyte.config.ReplicationAttemptSummary@3a888c3a[status=completed,recordsSynced=7337,bytesSynced=21439249,startTime=1652898218804,endTime=1652898290867,totalStats=io.airbyte.config.SyncStats@5609ebbf[recordsEmitted=7337,bytesEmitted=21439249,stateMessagesEmitted=0,recordsCommitted=7337],streamStats=[io.airbyte.config.StreamSyncStats@a4aeb07[streamName=events,stats=io.airbyte.config.SyncStats@38997caf[recordsEmitted=7337,bytesEmitted=21439249,stateMessagesEmitted=,recordsCommitted=7337]]]] 2022-05-18 18:24:50 INFO i.a.w.DefaultReplicationWorker(run):250 - Source did not output any state messages 2022-05-18 18:24:50 WARN i.a.w.DefaultReplicationWorker(run):258 - State capture: No new state, falling back on input state: io.airbyte.config.State@468eceda[state={}] 2022-05-18 18:24:50 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-05-18 18:24:50 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):155 - sync summary: io.airbyte.config.StandardSyncOutput@2f04b569[standardSyncSummary=io.airbyte.config.StandardSyncSummary@6a063eed[status=completed,recordsSynced=7337,bytesSynced=21439249,startTime=1652898218804,endTime=1652898290867,totalStats=io.airbyte.config.SyncStats@5609ebbf[recordsEmitted=7337,bytesEmitted=21439249,stateMessagesEmitted=0,recordsCommitted=7337],streamStats=[io.airbyte.config.StreamSyncStats@a4aeb07[streamName=events,stats=io.airbyte.config.SyncStats@38997caf[recordsEmitted=7337,bytesEmitted=21439249,stateMessagesEmitted=,recordsCommitted=7337]]]],normalizationSummary=,state=io.airbyte.config.State@468eceda[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@294929a2[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@5b2635d9[stream=io.airbyte.protocol.models.AirbyteStream@51837c29[name=events,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","integer"]},"to":{"type":["null","string"]},"day":{"type":["null","string"]},"uid":{"type":["null","string"]},"cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"from":{"type":["null","string"]},"note":{"type":["null","string"]},"user":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"avatar":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"large":{"type":["null","string"]},"medium":{"type":["null","string"]},"timeline":{"type":["null","string"]},"large_retina":{"type":["null","string"]},"medium_retina":{"type":["null","string"]}}}},"updated_at":{"type":["null","string"]}}}},"draft":{"type":["null","boolean"]},"billed":{"type":["null","boolean"]},"locked":{"type":["null","boolean"]},"manage":{"type":["null","boolean"]},"deleted":{"type":["null","boolean"]},"project":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"color":{"type":["null","string"]},"active":{"type":["null","boolean"]},"budget":{"type":["null","integer"]},"client":{"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"active":{"type":["null","boolean"]},"updated_at":{"type":["null","string"]},"external_id":{"type":["null","string"]}}},"labels":{"type":["null","array"]},"billable":{"type":["null","boolean"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"rate_type":{"type":["null","string"]},"account_id":{"type":["null","integer"]},"updated_at":{"type":["null","integer"]},"budget_type":{"type":["null","string"]},"external_id":{"type":["null","string"]},"budget_scope":{"type":["null","string"]},"enable_labels":{"type":["null","string"]},"budget_percent":{"type":["null","number"]},"has_recurrence":{"type":["null","boolean"]},"required_notes":{"type":["null","boolean"]},"budget_progress":{"type":["null","number"]},"required_labels":{"type":["null","boolean"]},"budget_expired_on":{"type":["null","string"]},"invoice_by_budget":{"type":["null","boolean"]},"budget_calculation":{"type":["null","string"]},"hour_rate_in_cents":{"type":["null","number"]},"required_label_ids":{"type":["null","array"]}}},"billable":{"type":["null","boolean"]},"duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]},"correctedHours":{"type":["null","integer"]}}}},"sequence":{"type":["null","integer"]},"user_ids":{"type":["null","array"]},"billed_at":{"type":["null","string"]},"entry_ids":{"type":["null","array"]},"estimated":{"type":["null","string"]},"hour_rate":{"type":["null","string"]},"label_ids":{"type":["null","array"]},"created_at":{"type":["null","integer"]},"created_id":{"type":["null","integer"]},"invoice_id":{"type":["null","string"]},"timestamps":{"type":["null","array"]},"updater_id":{"type":["null","integer"]},"external_id":{"type":["null","integer"]},"forecast_id":{"type":["null","string"]},"timer_state":{"type":["null","string"]},"created_from":{"type":["null","string"]},"updated_from":{"type":["null","string"]},"locked_reason":{"type":["null","string"]},"suggestion_id":{"type":["null","integer"]},"estimated_cost":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"formatted":{"type":["null","string"]},"fractional":{"type":["null","integer"]}}}},"timer_started_on":{"type":["null","integer"]},"timer_stopped_on":{"type":["null","integer"]},"estimated_duration":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"hours":{"type":["null","integer"]},"minutes":{"type":["null","integer"]},"seconds":{"type":["null","integer"]},"formatted":{"type":["null","string"]},"total_hours":{"type":["null","number"]},"total_minutes":{"type":["null","integer"]},"total_seconds":{"type":["null","integer"]}}}},"hour_rate_in_cents":{"type":["null","integer"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=poke_api,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-05-18 18:24:50 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):236 - Stopping temporal heartbeating... 2022-05-18 18:24:51 INFO i.a.c.p.ConfigRepository(updateConnectionState):774 - Updating connection 47e84b3e-80a0-458e-a89c-6ee003376de7 state: io.airbyte.config.State@77bf0ef3[state={}]