2021-12-15 14:06:08 INFO () WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.33.9-alpha
2021-12-15 14:06:08 INFO () TemporalAttemptExecution(get):116 - Executing worker wrapper. Airbyte version: 0.33.9-alpha
2021-12-15 14:06:08 WARN () Databases(createPostgresDatabaseWithRetry):41 - Waiting for database to become available...
2021-12-15 14:06:08 INFO () JobsDatabaseInstance(lambda$static$2):25 - Testing if jobs database is ready...
2021-12-15 14:06:08 INFO () Databases(createPostgresDatabaseWithRetry):58 - Database available!
2021-12-15 14:06:08 INFO () DefaultReplicationWorker(run):99 - start sync worker. job id: 18 attempt id: 2
2021-12-15 14:06:08 INFO () DefaultReplicationWorker(run):108 - configured sync modes: {null.accounts=full_refresh - overwrite, null.shortcuts=full_refresh - overwrite, null.agents=incremental - append, null.bans=incremental - append, null.departments=full_refresh - overwrite, null.roles=full_refresh - overwrite, null.goals=full_refresh - overwrite, null.chats=incremental - append, null.skills=full_refresh - overwrite, null.routing_settings=full_refresh - overwrite}
2021-12-15 14:06:08 INFO () DefaultAirbyteDestination(start):64 - Running destination...
2021-12-15 14:06:08 INFO () LineGobbler(voidCall):82 - Checking if airbyte/destination-bigquery:0.5.0 exists...
2021-12-15 14:06:08 INFO () LineGobbler(voidCall):82 - airbyte/destination-bigquery:0.5.0 was found locally.
2021-12-15 14:06:08 INFO () DockerProcessFactory(create):127 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/18/2 --network host --log-driver none airbyte/destination-bigquery:0.5.0 write --config destination_config.json --catalog destination_catalog.json
2021-12-15 14:06:08 INFO () LineGobbler(voidCall):82 - Checking if airbyte/source-zendesk-chat:0.1.5 exists...
2021-12-15 14:06:08 INFO () LineGobbler(voidCall):82 - airbyte/source-zendesk-chat:0.1.5 was found locally.
2021-12-15 14:06:08 INFO () DockerProcessFactory(create):127 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/18/2 --network host --log-driver none airbyte/source-zendesk-chat:0.1.5 read --config source_config.json --catalog source_catalog.json
2021-12-15 14:06:08 INFO () DefaultReplicationWorker(run):136 - Waiting for source thread to join.
2021-12-15 14:06:08 INFO () DefaultReplicationWorker(lambda$getDestinationOutputRunnable$3):243 - Destination output thread started.
2021-12-15 14:06:08 INFO () DefaultReplicationWorker(lambda$getReplicationRunnable$2):207 - Replication thread started.
[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Starting syncing SourceZendeskChat
[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Syncing stream: accounts 
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [32mINFO[m i.a.i.d.b.BigQueryDestination(main):334 - {} - starting destination: class io.airbyte.integrations.destination.bigquery.BigQueryDestination
[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Read 1 records from accounts stream
[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Finished syncing SourceZendeskChat
[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - SourceZendeskChat runtimes:

[34msource[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Syncing stream: agents 
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [32mINFO[m i.a.i.b.IntegrationRunner(run):76 - {} - Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [32mINFO[m i.a.i.b.IntegrationCliParser(parseOptions):115 - {} - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json}
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [32mINFO[m i.a.i.b.IntegrationRunner(run):80 - {} - Command: WRITE
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [32mINFO[m i.a.i.b.IntegrationRunner(run):81 - {} - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'}
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [33mWARN[m 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
[35mdestination[0m - 2021-12-15 14:06:09 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:09 [33mWARN[m 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
[35mdestination[0m - 2021-12-15 14:06:10 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:10 [32mINFO[m i.a.i.d.b.BigQueryDestination(getLoadingMethod):309 - {} - Selected loading method is set to: STANDARD
[35mdestination[0m - 2021-12-15 14:06:10 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:10 [32mINFO[m i.a.i.d.b.BigQueryDestination(isKeepFilesInGcs):322 - {} - All tmp files will be removed from GCS when replication is finished
[35mdestination[0m - 2021-12-15 14:06:11 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:11 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_hrr_zendesk_accounts}} created successfully
[35mdestination[0m - 2021-12-15 14:06:11 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:11 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_skt_zendesk_agents}} created successfully
[35mdestination[0m - 2021-12-15 14:06:12 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:12 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_uzj_zendesk_bans}} created successfully
[35mdestination[0m - 2021-12-15 14:06:12 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:12 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_mzj_zendesk_chats}} created successfully
[35mdestination[0m - 2021-12-15 14:06:12 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:12 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_xsb_zendesk_departments}} created successfully
[35mdestination[0m - 2021-12-15 14:06:13 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:13 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_chv_zendesk_goals}} created successfully
[35mdestination[0m - 2021-12-15 14:06:13 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:13 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_din_zendesk_roles}} created successfully
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Setting state of agents stream to {'id': 1909667858145}
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Read 622 records from agents stream
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Finished syncing SourceZendeskChat
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - SourceZendeskChat runtimes:

[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Syncing stream: bans 
[35mdestination[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:14 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_yqo_zendesk_routing_settings}} created successfully
[35mdestination[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:14 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_eze_zendesk_shortcuts}} created successfully
[34msource[0m - 2021-12-15 14:06:14 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - Encountered an exception while reading stream SourceZendeskChat
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 108, in read
    internal_config=internal_config,
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 141, in _read_stream
    for record in record_iterator:
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/abstract_source.py", line 185, in _read_incremental
    for record_counter, record_data in enumerate(records, start=1):
  File "/usr/local/lib/python3.7/site-packages/airbyte_cdk/sources/streams/http/http.py", line 354, in read_records
    yield from self.parse_response(response, stream_state=stream_state, stream_slice=stream_slice)
  File "/airbyte/integration_code/source_zendesk_chat/streams.py", line 50, in parse_response
    stream_data = self.get_stream_data(response_data)
  File "/airbyte/integration_code/source_zendesk_chat/streams.py", line 240, in get_stream_data
    bans = sorted(bans, key=lambda x: pendulum.parse(x["created_at"]))
  File "/airbyte/integration_code/source_zendesk_chat/streams.py", line 240, in <lambda>
    bans = sorted(bans, key=lambda x: pendulum.parse(x["created_at"]))
  File "/usr/local/lib/python3.7/site-packages/pendulum/parser.py", line 71, in parse
    return Parser(**options).parse(text)
  File "/usr/local/lib/python3.7/site-packages/pendulum/parser.py", line 27, in parse
    parsed = super(Parser, self).parse(text)
  File "/usr/local/lib/python3.7/site-packages/pendulum/parsing/parser.py", line 277, in parse
    return self.normalize(self._parse(text))
  File "/usr/local/lib/python3.7/site-packages/pendulum/parsing/parser.py", line 322, in _parse
    parsed = self.parse_common(text)
  File "/usr/local/lib/python3.7/site-packages/pendulum/parsing/parser.py", line 84, in parse_common
    m = self.COMMON.match(text)
TypeError: expected string or bytes-like object
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Finished syncing SourceZendeskChat
[34msource[0m - 2021-12-15 14:06:14 INFO () DefaultAirbyteStreamFactory(internalLog):97 - SourceZendeskChat runtimes:

[34msource[0m - 2021-12-15 14:06:14 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - expected string or bytes-like object
2021-12-15 14:06:14 INFO () DefaultReplicationWorker(run):138 - Source thread complete.
2021-12-15 14:06:14 INFO () DefaultReplicationWorker(run):139 - Waiting for destination thread to join.
[35mdestination[0m - 2021-12-15 14:06:15 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:15 [32mINFO[m i.a.i.d.b.BigQueryUtils(createPartitionedTable):110 - {} - Partitioned Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_anp_zendesk_skills}} created successfully
[35mdestination[0m - 2021-12-15 14:06:15 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:15 [32mINFO[m i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):60 - {} - Airbyte message consumer: succeeded.
[35mdestination[0m - 2021-12-15 14:06:15 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:15 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(close):163 - {} - Started closing all connections
[35mdestination[0m - 2021-12-15 14:06:16 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:16 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(closeNormalBigqueryStreams):278 - {} - Waiting for jobs to be finished/closed
[35mdestination[0m - 2021-12-15 14:06:20 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:20 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(closeNormalBigqueryStreams):295 - {} - Replication finished with no explicit errors. Copying data from tmp tables to permanent
[35mdestination[0m - 2021-12-15 14:06:22 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:22 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_hrr_zendesk_accounts}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_accounts}}
[35mdestination[0m - 2021-12-15 14:06:27 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:27 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_mzj_zendesk_chats}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_chats}}
[35mdestination[0m - 2021-12-15 14:06:29 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:29 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_chv_zendesk_goals}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_goals}}
[35mdestination[0m - 2021-12-15 14:06:32 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:32 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_skt_zendesk_agents}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_agents}}
[35mdestination[0m - 2021-12-15 14:06:35 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:35 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_uzj_zendesk_bans}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_bans}}
[35mdestination[0m - 2021-12-15 14:06:37 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:37 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_din_zendesk_roles}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_roles}}
[35mdestination[0m - 2021-12-15 14:06:40 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:40 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_xsb_zendesk_departments}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_departments}}
[35mdestination[0m - 2021-12-15 14:06:43 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:43 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_yqo_zendesk_routing_settings}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_routing_settings}}
[35mdestination[0m - 2021-12-15 14:06:44 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:44 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_anp_zendesk_skills}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_skills}}
[35mdestination[0m - 2021-12-15 14:06:47 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:47 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(copyTable):363 - {} - successfully copied table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_tmp_eze_zendesk_shortcuts}} to table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=dsc_sandbox, tableId=_airbyte_raw_zendesk_shortcuts}}
2021-12-15 14:06:47 INFO () DefaultReplicationWorker(lambda$getDestinationOutputRunnable$3):248 - state in DefaultReplicationWorker from Destination: io.airbyte.protocol.models.AirbyteMessage@41548b79[type=STATE,log=<null>,spec=<null>,connectionStatus=<null>,catalog=<null>,record=<null>,state=io.airbyte.protocol.models.AirbyteStateMessage@4f936d23[data={"agents":{"id":1909667858145}},additionalProperties={}],additionalProperties={}]
[35mdestination[0m - 2021-12-15 14:06:47 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:47 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(closeNormalBigqueryStreams):312 - {} - Removing tmp tables...
[35mdestination[0m - 2021-12-15 14:06:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:48 [32mINFO[m i.a.i.d.b.BigQueryRecordConsumer(closeNormalBigqueryStreams):314 - {} - Finishing destination process...completed
[35mdestination[0m - 2021-12-15 14:06:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:48 [32mINFO[m i.a.i.b.IntegrationRunner(run):133 - {} - Completed integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination
[35mdestination[0m - 2021-12-15 14:06:48 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-15 14:06:48 [32mINFO[m i.a.i.d.b.BigQueryDestination(main):336 - {} - completed destination: class io.airbyte.integrations.destination.bigquery.BigQueryDestination
2021-12-15 14:06:48 INFO () DefaultReplicationWorker(run):141 - Destination thread complete.
2021-12-15 14:06:48 ERROR () DefaultReplicationWorker(run):145 - Sync worker failed.
io.airbyte.workers.WorkerException: Source process exit with code 1. This warning is normal if the job was cancelled.
	at io.airbyte.workers.protocols.airbyte.DefaultAirbyteSource.close(DefaultAirbyteSource.java:117) ~[io.airbyte-airbyte-workers-0.33.9-alpha.jar:?]
	at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:143) ~[io.airbyte-airbyte-workers-0.33.9-alpha.jar:?]
	at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:49) ~[io.airbyte-airbyte-workers-0.33.9-alpha.jar:?]
	at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:167) ~[io.airbyte-airbyte-workers-0.33.9-alpha.jar:?]
	at java.lang.Thread.run(Thread.java:832) [?:?]
2021-12-15 14:06:48 INFO () DefaultReplicationWorker(run):169 - sync summary: io.airbyte.config.ReplicationAttemptSummary@769580c0[status=failed,recordsSynced=623,bytesSynced=263477,startTime=1639577168383,endTime=1639577208594]
2021-12-15 14:06:48 INFO () DefaultReplicationWorker(run):176 - Source output at least one state message
2021-12-15 14:06:48 INFO () DefaultReplicationWorker(run):182 - State capture: Updated state to: Optional[io.airbyte.config.State@34f7ea86[state={"agents":{"id":1909667858145}}]]
2021-12-15 14:06:48 INFO () TemporalAttemptExecution(get):137 - Stopping cancellation check scheduling...
2021-12-15 14:06:48 INFO () ReplicationActivityImpl(replicate):121 - sync summary: io.airbyte.config.StandardSyncOutput@69e12078[standardSyncSummary=io.airbyte.config.StandardSyncSummary@72da32f[status=failed,recordsSynced=623,bytesSynced=263477,startTime=1639577168383,endTime=1639577208594],state=io.airbyte.config.State@34f7ea86[state={"agents":{"id":1909667858145}}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@50ce10f3[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@d2d2e0d[stream=io.airbyte.protocol.models.AirbyteStream@6daf3d30[name=zendesk_accounts,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"plan":{"type":["null","object"],"properties":{"sla":{"type":["null","boolean"]},"name":{"type":["null","string"]},"goals":{"type":["null","integer"]},"price":{"type":["null","number"],"maximum":1000000000000000000000000000000000,"minimum":-1000000000000000000000000000000000},"support":{"type":["null","boolean"]},"rest_api":{"type":["null","boolean"]},"analytics":{"type":["null","boolean"]},"high_load":{"type":["null","boolean"]},"long_desc":{"type":["null","string"]},"max_agents":{"type":["null","integer"]},"monitoring":{"type":["null","boolean"]},"short_desc":{"type":["null","string"]},"unbranding":{"type":["null","boolean"]},"file_upload":{"type":["null","boolean"]},"chat_reports":{"type":["null","boolean"]},"integrations":{"type":["null","boolean"]},"agent_reports":{"type":["null","boolean"]},"daily_reports":{"type":["null","boolean"]},"email_reports":{"type":["null","boolean"]},"ip_restriction":{"type":["null","boolean"]},"max_departments":{"type":["null","string"]},"operating_hours":{"type":["null","boolean"]},"agent_leaderboard":{"type":["null","boolean"]},"max_basic_triggers":{"type":["null","string"]},"max_concurrent_chats":{"type":["null","string"]},"widget_customization":{"type":["null","string"]},"max_advanced_triggers":{"type":["null","string"]},"max_history_search_days":{"type":["null","string"]}}},"status":{"type":["null","string"]},"billing":{"type":["null","object"],"properties":{"city":{"type":["null","string"]},"cycle":{"type":["null","integer"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"state":{"type":["null","string"]},"company":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"postal_code":{"type":["null","string"]},"country_code":{"type":["null","string"]},"additional_info":{"type":["null","string"]}}},"account_key":{"type":["null","string"]},"create_date":{"type":["null","string"],"format":"date-time"}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[account_key]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[account_key]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@7f1cf71[stream=io.airbyte.protocol.models.AirbyteStream@27981ef4[name=zendesk_agents,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"email":{"type":["null","string"]},"roles":{"type":["null","object"],"properties":{"owner":{"type":["boolean"]},"administrator":{"type":["boolean"]}}},"scope":{"type":["null","string"]},"skills":{"type":["null","array"],"items":{"type":"integer"}},"enabled":{"type":["null","boolean"]},"role_id":{"type":["null","integer"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"last_login":{"type":["null","string"],"format":"date-time"},"create_date":{"type":["null","string"],"format":"date-time"},"departments":{"type":["null","array"],"items":{"type":["integer"]}},"login_count":{"type":["null","integer"]},"display_name":{"type":["null","string"]},"enabled_departments":{"type":["null","array"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[id],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=incremental,cursorField=[id],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4321114c[stream=io.airbyte.protocol.models.AirbyteStream@57f3e2a5[name=zendesk_bans,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"type":{"type":["null","string"]},"reason":{"type":["null","string"]},"ip_address":{"type":["null","string"]},"visitor_id":{"type":["null","string"]},"create_date":{"type":["null","string"],"format":"date-time"},"visitor_name":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[id],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=incremental,cursorField=[id],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@5e70356d[stream=io.airbyte.protocol.models.AirbyteStream@3978ffe9[name=zendesk_chats,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"tags":{"type":["null","array"],"items":{"type":["string"]}},"type":{"type":["null","string"]},"count":{"type":["null","object"],"properties":{"agent":{"type":["null","integer"]},"total":{"type":["null","integer"]},"visitor":{"type":["null","integer"]}},"additionalProperties":false},"missed":{"type":["null","boolean"]},"rating":{"type":["null","string"]},"unread":{"type":["null","boolean"]},"comment":{"type":["null","string"]},"deleted":{"type":["null","boolean"]},"history":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"msg":{"type":["null","string"]},"name":{"type":["null","string"]},"nick":{"type":["null","string"]},"tags":{"type":["null","array"]},"type":{"type":["null","string"]},"msg_id":{"type":["null","string","integer"]},"rating":{"type":["null","string"]},"channel":{"type":["null","string"]},"options":{"type":["null","string"]},"new_tags":{"type":["null","array"]},"timestamp":{"type":["null","string"],"format":"date-time"},"conversion":{"type":["null","object"],"properties":{"id":{"type":["string"]},"goal_id":{"type":["null","integer"]},"goal_name":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"},"attribution":{"type":["null","object"],"properties":{"agent_id":{"type":["null","integer"]},"agent_name":{"type":["null","string"]},"department_id":{"type":["null","integer"]},"chat_timestamp":{"type":["null","string"],"format":"date-time"},"department_name":{"type":["null","string"]}}}},"additionalProperties":true},"new_rating":{"type":["null","string"]},"skills_name":{"type":["null","array"]},"department_id":{"type":["null","integer","string"]},"department_name":{"type":["null","string"]},"prev_department_id":{"type":["null","integer","string"]}},"additionalProperties":true}},"message":{"type":["null","string"]},"session":{"type":["null","object"],"additionalProperties":true},"visitor":{"type":["null","object"],"properties":{"id":{"type":["string"]},"name":{"type":["null","string"]},"email":{"type":["null","string"]},"notes":{"type":["null","string"]},"phone":{"type":["null","string"]}},"additionalProperties":false},"webpath":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"to":{"type":["null","string"]},"from":{"type":["null","string"]},"title":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"}},"additionalProperties":false}},"duration":{"type":["null","integer"]},"agent_ids":{"type":["null","array"],"items":{"type":["string"]}},"timestamp":{"type":["null","string"],"format":"date-time"},"triggered":{"type":["null","boolean"]},"started_by":{"type":["null","string"]},"agent_names":{"type":["null","array"],"items":{"type":["string"]}},"conversions":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["string"]},"goal_id":{"type":["null","integer"]},"goal_name":{"type":["null","string"]},"timestamp":{"type":["null","string"],"format":"date-time"},"attribution":{"type":["null","object"],"properties":{"agent_id":{"type":["null","integer"]},"agent_name":{"type":["null","string"]},"department_id":{"type":["null","integer"]},"chat_timestamp":{"type":["null","string"],"format":"date-time"},"department_name":{"type":["null","string"]}}}},"additionalProperties":true}},"department_id":{"type":["null","integer"]},"response_time":{"type":["null","object"],"properties":{"avg":{"type":["null","number"]},"max":{"type":["null","integer"]},"first":{"type":["null","integer"]}},"additionalProperties":false},"department_name":{"type":["null","string"]},"update_timestamp":{"type":["null","string"],"format":"date-time"},"zendesk_ticket_id":{"type":["null","integer"]},"triggered_response":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[update_timestamp],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=incremental,cursorField=[update_timestamp],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@729832fb[stream=io.airbyte.protocol.models.AirbyteStream@3a3600c7[name=zendesk_departments,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"name":{"type":["null","string"]},"enabled":{"type":["null","boolean"]},"members":{"type":["null","array"],"items":{"type":["null","integer"]}},"settings":{"type":["null","object"],"additionalProperties":true},"description":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@65b291b1[stream=io.airbyte.protocol.models.AirbyteStream@1b4bbd59[name=zendesk_goals,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"name":{"type":["null","string"]},"enabled":{"type":["null","boolean"]},"settings":{"type":["null","object"],"properties":{"conditions":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"type":{"type":["null","string"]},"value":{"type":["null","string"]},"operator":{"type":["null","string"]}}}}},"additionalProperties":true},"description":{"type":["null","string"]},"attribution_model":{"type":["null","string"]},"attribution_period":{"type":["null","integer"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@28774b21[stream=io.airbyte.protocol.models.AirbyteStream@224d56d0[name=zendesk_roles,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"name":{"type":["null","string"]},"enabled":{"type":["null","boolean"]},"description":{"type":["null","string"]},"permissions":{"type":["null","object"],"properties":{"manage_bans":{"type":["null","string"]},"view_monitor":{"type":["null","string"]},"visitors_seen":{"type":["null","string"]},"edit_chat_tags":{"type":["null","boolean"]},"view_past_chats":{"type":["null","string"]},"access_analytics":{"type":["null","string"]},"manage_shortcuts":{"type":["null","string"]},"edit_visitor_notes":{"type":["null","boolean"]},"proactive_chatting":{"type":["null","string"]},"set_agent_chat_limit":{"type":["null","string"]},"edit_department_agents":{"type":["null","string"]},"edit_visitor_information":{"type":["null","boolean"]}}},"members_count":{"type":["integer"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@53036431[stream=io.airbyte.protocol.models.AirbyteStream@1564aa7d[name=zendesk_routing_settings,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"auto_idle":{"type":["null","object"],"properties":{"enabled":{"type":["null","boolean"]},"new_status":{"type":["null","string"]},"reassignments_before_idle":{"type":["null","integer"]}}},"chat_limit":{"type":["null","object"],"properties":{"limit":{"type":["null","integer"]},"enabled":{"type":["null","boolean"]},"limit_type":{"type":["null","string"]},"allow_agent_override":{"type":["null","boolean"]}}},"reassignment":{"type":["null","object"],"properties":{"enabled":{"type":["null","boolean"]},"timeout":{"type":["null","integer"]}}},"routing_mode":{"type":["null","string"]},"skill_routing":{"type":["null","object"],"properties":{"enabled":{"type":["null","boolean"]},"max_wait_time":{"type":["null","integer"]}}}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@758c5b3[stream=io.airbyte.protocol.models.AirbyteStream@4f6be85e[name=zendesk_shortcuts,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"name":{"type":["string"]},"tags":{"type":["null","array"],"items":{"type":["string"]}},"scope":{"type":["null","string"]},"message":{"type":["null","string"]},"options":{"type":["null","string"]},"departments":{"type":["null","array"],"items":{"type":"integer"}}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@7813f6e[stream=io.airbyte.protocol.models.AirbyteStream@37864aa1[name=zendesk_skills,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["integer"]},"name":{"type":["null","string"]},"enabled":{"type":["null","boolean"]},"members":{"type":["null","array"],"items":{"type":"integer"}},"description":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}]]
2021-12-15 14:06:48 INFO () ConfigRepository(updateConnectionState):515 - Updating connection 3d83868a-bd09-4740-9d67-475ff192b25d state: io.airbyte.config.State@68ff72cf[state={"agents":{"id":1909667858145}}]
2021-12-15 14:06:48 INFO () DatabaseConfigPersistence(updateConfigRecord):273 - Updating STANDARD_SYNC_STATE record 3d83868a-bd09-4740-9d67-475ff192b25d
2021-12-15 14:06:48 INFO () TemporalAttemptExecution(get):116 - Executing worker wrapper. Airbyte version: 0.33.9-alpha
2021-12-15 14:06:48 WARN () Databases(createPostgresDatabaseWithRetry):41 - Waiting for database to become available...
2021-12-15 14:06:48 INFO () JobsDatabaseInstance(lambda$static$2):25 - Testing if jobs database is ready...
2021-12-15 14:06:48 INFO () Databases(createPostgresDatabaseWithRetry):58 - Database available!
2021-12-15 14:06:48 INFO () DefaultNormalizationWorker(run):46 - Running normalization.
2021-12-15 14:06:48 INFO () DefaultNormalizationRunner(runProcess):114 - Running with normalization version: airbyte/normalization:0.1.61
2021-12-15 14:06:48 INFO () LineGobbler(voidCall):82 - Checking if airbyte/normalization:0.1.61 exists...
2021-12-15 14:06:48 INFO () LineGobbler(voidCall):82 - airbyte/normalization:0.1.61 was found locally.
2021-12-15 14:06:48 INFO () DockerProcessFactory(create):127 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/18/2/normalize --network host --log-driver none airbyte/normalization:0.1.61 run --integration-type bigquery --config destination_config.json --catalog destination_catalog.json
[32mnormalization[0m - 2021-12-15 14:06:48 INFO () LineGobbler(voidCall):82 - Running: transform-config --config destination_config.json --integration-type bigquery --out /data/18/2/normalize
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 - Namespace(config='destination_config.json', integration_type=<DestinationType.bigquery: 'bigquery'>, out='/data/18/2/normalize')
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 - transform_bigquery
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 - Running: transform-catalog --integration-type bigquery --profile-config-dir /data/18/2/normalize --catalog destination_catalog.json --out /data/18/2/normalize/models/generated/ --json-column _airbyte_data
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 - Processing destination_catalog.json...
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_ab1.sql from zendesk_accounts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_ab2.sql from zendesk_accounts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_ab3.sql from zendesk_accounts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_accounts.sql from zendesk_accounts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_ab1.sql from zendesk_agents
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_ab2.sql from zendesk_agents
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_ab3.sql from zendesk_agents
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_agents.sql from zendesk_agents
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_bans_ab1.sql from zendesk_bans
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_bans_ab2.sql from zendesk_bans
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_bans_ab3.sql from zendesk_bans
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_bans.sql from zendesk_bans
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_ab1.sql from zendesk_chats
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_ab2.sql from zendesk_chats
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_ab3.sql from zendesk_chats
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats.sql from zendesk_chats
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_departments_ab1.sql from zendesk_departments
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_departments_ab2.sql from zendesk_departments
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_departments_ab3.sql from zendesk_departments
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_departments.sql from zendesk_departments
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_ab1.sql from zendesk_goals
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_ab2.sql from zendesk_goals
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_ab3.sql from zendesk_goals
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_goals.sql from zendesk_goals
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_ab1.sql from zendesk_roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_ab2.sql from zendesk_roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_ab3.sql from zendesk_roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_roles.sql from zendesk_roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_ab1.sql from zendesk_routing_settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_ab2.sql from zendesk_routing_settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_ab3.sql from zendesk_routing_settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_routing_settings.sql from zendesk_routing_settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_shortcuts_ab1.sql from zendesk_shortcuts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_shortcuts_ab2.sql from zendesk_shortcuts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_shortcuts_ab3.sql from zendesk_shortcuts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_shortcuts.sql from zendesk_shortcuts
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_skills_ab1.sql from zendesk_skills
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_skills_ab2.sql from zendesk_skills
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_skills_ab3.sql from zendesk_skills
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_skills.sql from zendesk_skills
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_plan_ab1.sql from zendesk_accounts/plan
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_plan_ab2.sql from zendesk_accounts/plan
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_plan_ab3.sql from zendesk_accounts/plan
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_accounts_plan.sql from zendesk_accounts/plan
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_billing_ab1.sql from zendesk_accounts/billing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_billing_ab2.sql from zendesk_accounts/billing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_accounts_billing_ab3.sql from zendesk_accounts/billing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_accounts_billing.sql from zendesk_accounts/billing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_roles_ab1.sql from zendesk_agents/roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_roles_ab2.sql from zendesk_agents/roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_agents_roles_ab3.sql from zendesk_agents/roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_agents_roles.sql from zendesk_agents/roles
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'skills' from zendesk_agents/skills because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'departments' from zendesk_agents/departments because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'tags' from zendesk_chats/tags because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_count_ab1.sql from zendesk_chats/count
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_count_ab2.sql from zendesk_chats/count
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_count_ab3.sql from zendesk_chats/count
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_count.sql from zendesk_chats/count
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_ab1.sql from zendesk_chats/history
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_ab2.sql from zendesk_chats/history
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_ab3.sql from zendesk_chats/history
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_history.sql from zendesk_chats/history
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_visitor_ab1.sql from zendesk_chats/visitor
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_visitor_ab2.sql from zendesk_chats/visitor
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_visitor_ab3.sql from zendesk_chats/visitor
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_visitor.sql from zendesk_chats/visitor
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_webpath_ab1.sql from zendesk_chats/webpath
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_webpath_ab2.sql from zendesk_chats/webpath
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_webpath_ab3.sql from zendesk_chats/webpath
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_webpath.sql from zendesk_chats/webpath
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'agent_ids' from zendesk_chats/agent_ids because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'agent_names' from zendesk_chats/agent_names because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_ab1.sql from zendesk_chats/conversions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_ab2.sql from zendesk_chats/conversions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_ab3.sql from zendesk_chats/conversions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_conversions.sql from zendesk_chats/conversions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_response_time_ab1.sql from zendesk_chats/response_time
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_response_time_ab2.sql from zendesk_chats/response_time
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_response_time_ab3.sql from zendesk_chats/response_time
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_response_time.sql from zendesk_chats/response_time
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'members' from zendesk_departments/members because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_ab1.sql from zendesk_goals/settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_ab2.sql from zendesk_goals/settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_ab3.sql from zendesk_goals/settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_goals_settings.sql from zendesk_goals/settings
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_permissions_ab1.sql from zendesk_roles/permissions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_permissions_ab2.sql from zendesk_roles/permissions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_roles_permissions_ab3.sql from zendesk_roles/permissions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_roles_permissions.sql from zendesk_roles/permissions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_auto_idle_ab1.sql from zendesk_routing_settings/auto_idle
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_auto_idle_ab2.sql from zendesk_routing_settings/auto_idle
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_auto_idle_ab3.sql from zendesk_routing_settings/auto_idle
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_routing_settings_auto_idle.sql from zendesk_routing_settings/auto_idle
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_chat_limit_ab1.sql from zendesk_routing_settings/chat_limit
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_chat_limit_ab2.sql from zendesk_routing_settings/chat_limit
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_chat_limit_ab3.sql from zendesk_routing_settings/chat_limit
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_routing_settings_chat_limit.sql from zendesk_routing_settings/chat_limit
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_reassignment_ab1.sql from zendesk_routing_settings/reassignment
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_reassignment_ab2.sql from zendesk_routing_settings/reassignment
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_reassignment_ab3.sql from zendesk_routing_settings/reassignment
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_routing_settings_reassignment.sql from zendesk_routing_settings/reassignment
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_skill_routing_ab1.sql from zendesk_routing_settings/skill_routing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_skill_routing_ab2.sql from zendesk_routing_settings/skill_routing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_routing_settings_skill_routing_ab3.sql from zendesk_routing_settings/skill_routing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_routing_settings_skill_routing.sql from zendesk_routing_settings/skill_routing
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'tags' from zendesk_shortcuts/tags because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'departments' from zendesk_shortcuts/departments because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Ignoring stream 'members' from zendesk_skills/members because properties list is empty
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_ab1.sql from zendesk_chats/history/conversion
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_ab2.sql from zendesk_chats/history/conversion
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_ab3.sql from zendesk_chats/history/conversion
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_history_conversion.sql from zendesk_chats/history/conversion
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_attribution_ab1.sql from zendesk_chats/conversions/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_attribution_ab2.sql from zendesk_chats/conversions/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_conversions_attribution_ab3.sql from zendesk_chats/conversions/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_conversions_attribution.sql from zendesk_chats/conversions/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_conditions_ab1.sql from zendesk_goals/settings/conditions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_conditions_ab2.sql from zendesk_goals/settings/conditions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_goals_settings_conditions_ab3.sql from zendesk_goals/settings/conditions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_tables/dsc_sandbox/zendesk_goals_settings_conditions.sql from zendesk_goals/settings/conditions
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_attribution_ab1.sql from zendesk_chats/history/conversion/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_attribution_ab2.sql from zendesk_chats/history/conversion/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_ctes/dsc_sandbox/zendesk_chats_history_conversion_attribution_ab3.sql from zendesk_chats/history/conversion/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 -   Generating airbyte_incremental/dsc_sandbox/zendesk_chats_history_conversion_attribution.sql from zendesk_chats/history/conversion/attribution
[32mnormalization[0m - 2021-12-15 14:06:49 INFO () LineGobbler(voidCall):82 - detected no config file for ssh, assuming ssh is off.
[32mnormalization[0m - 2021-12-15 14:06:51 INFO () LineGobbler(voidCall):82 - Running with dbt=0.21.1
[32mnormalization[0m - 2021-12-15 14:06:52 INFO () LineGobbler(voidCall):82 - Unable to do partial parsing because ../build/partial_parse.msgpack not found
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - [[33mWARNING[0m]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - There are 1 unused configuration paths:
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - - models.airbyte_utils.generated.airbyte_views
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - 
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - Found 116 models, 0 tests, 0 snapshots, 0 analyses, 501 macros, 0 operations, 0 seed files, 10 sources, 0 exposures
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - 
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - 14:06:55 | Concurrency: 32 threads (target='prod')
[32mnormalization[0m - 2021-12-15 14:06:55 INFO () LineGobbler(voidCall):82 - 14:06:55 | 
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 1 of 29 START table model dsc_sandbox.zendesk_goals.......................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 2 of 29 START table model dsc_sandbox.zendesk_skills......................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 3 of 29 START table model dsc_sandbox.zendesk_shortcuts...................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 4 of 29 START table model dsc_sandbox.zendesk_accounts....................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 5 of 29 START table model dsc_sandbox.zendesk_roles.......................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 6 of 29 START table model dsc_sandbox.zendesk_departments.................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 7 of 29 START table model dsc_sandbox.zendesk_routing_settings............................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:56 INFO () LineGobbler(voidCall):82 - 14:06:56 | 8 of 29 START incremental model dsc_sandbox.zendesk_bans..................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:57 INFO () LineGobbler(voidCall):82 - 14:06:57 | 9 of 29 START incremental model dsc_sandbox.zendesk_agents................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:57 INFO () LineGobbler(voidCall):82 - 14:06:57 | 10 of 29 START incremental model dsc_sandbox.zendesk_chats................................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 5 of 29 OK created table model dsc_sandbox.zendesk_roles..................................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 2.98s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 11 of 29 START table model dsc_sandbox.zendesk_roles_permissions............................................. [RUN]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 1 of 29 OK created table model dsc_sandbox.zendesk_goals..................................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.31s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 4 of 29 OK created table model dsc_sandbox.zendesk_accounts.................................................. [[32mCREATE TABLE (1.0 rows, 841.0 Bytes processed)[0m in 3.26s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 2 of 29 OK created table model dsc_sandbox.zendesk_skills.................................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.31s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 12 of 29 START table model dsc_sandbox.zendesk_goals_settings................................................ [RUN]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 13 of 29 START table model dsc_sandbox.zendesk_accounts_billing.............................................. [RUN]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 6 of 29 OK created table model dsc_sandbox.zendesk_departments............................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.56s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 3 of 29 OK created table model dsc_sandbox.zendesk_shortcuts................................................. [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.58s]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 14 of 29 START table model dsc_sandbox.zendesk_accounts_plan................................................. [RUN]
[32mnormalization[0m - 2021-12-15 14:06:59 INFO () LineGobbler(voidCall):82 - 14:06:59 | 7 of 29 OK created table model dsc_sandbox.zendesk_routing_settings.......................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.65s]
[32mnormalization[0m - 2021-12-15 14:07:00 INFO () LineGobbler(voidCall):82 - 14:07:00 | 15 of 29 START table model dsc_sandbox.zendesk_routing_settings_auto_idle.................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:00 INFO () LineGobbler(voidCall):82 - 14:07:00 | 16 of 29 START table model dsc_sandbox.zendesk_routing_settings_chat_limit................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:00 INFO () LineGobbler(voidCall):82 - 14:07:00 | 17 of 29 START table model dsc_sandbox.zendesk_routing_settings_skill_routing................................ [RUN]
[32mnormalization[0m - 2021-12-15 14:07:00 INFO () LineGobbler(voidCall):82 - 14:07:00 | 18 of 29 START table model dsc_sandbox.zendesk_routing_settings_reassignment................................. [RUN]
[32mnormalization[0m - 2021-12-15 14:07:02 INFO () LineGobbler(voidCall):82 - 14:07:02 | 14 of 29 OK created table model dsc_sandbox.zendesk_accounts_plan............................................ [[32mCREATE TABLE (1.0 rows, 762.0 Bytes processed)[0m in 2.99s]
[32mnormalization[0m - 2021-12-15 14:07:02 INFO () LineGobbler(voidCall):82 - 14:07:02 | 13 of 29 OK created table model dsc_sandbox.zendesk_accounts_billing......................................... [[32mCREATE TABLE (0.0 rows, 80.0 Bytes processed)[0m in 3.05s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 12 of 29 OK created table model dsc_sandbox.zendesk_goals_settings........................................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.48s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 19 of 29 START table model dsc_sandbox.zendesk_goals_settings_conditions..................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 11 of 29 OK created table model dsc_sandbox.zendesk_roles_permissions........................................ [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.83s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 16 of 29 OK created table model dsc_sandbox.zendesk_routing_settings_chat_limit.............................. [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.30s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 15 of 29 OK created table model dsc_sandbox.zendesk_routing_settings_auto_idle............................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.34s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 18 of 29 OK created table model dsc_sandbox.zendesk_routing_settings_reassignment............................ [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.23s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 8 of 29 OK created incremental model dsc_sandbox.zendesk_bans................................................ [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.70s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 17 of 29 OK created table model dsc_sandbox.zendesk_routing_settings_skill_routing........................... [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 3.53s]
[32mnormalization[0m - 2021-12-15 14:07:03 INFO () LineGobbler(voidCall):82 - 14:07:03 | 10 of 29 OK created incremental model dsc_sandbox.zendesk_chats.............................................. [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.82s]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 9 of 29 OK created incremental model dsc_sandbox.zendesk_agents.............................................. [[32mMERGE (625.0 rows, 234.9 KB processed)[0m in 7.49s]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 20 of 29 START incremental model dsc_sandbox.zendesk_chats_webpath........................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 22 of 29 START incremental model dsc_sandbox.zendesk_chats_conversions....................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 21 of 29 START incremental model dsc_sandbox.zendesk_chats_count............................................. [RUN]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 23 of 29 START incremental model dsc_sandbox.zendesk_chats_response_time..................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 24 of 29 START incremental model dsc_sandbox.zendesk_chats_visitor........................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:04 INFO () LineGobbler(voidCall):82 - 14:07:04 | 25 of 29 START incremental model dsc_sandbox.zendesk_chats_history........................................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:05 INFO () LineGobbler(voidCall):82 - 14:07:05 | 26 of 29 START incremental model dsc_sandbox.zendesk_agents_roles............................................ [RUN]
[32mnormalization[0m - 2021-12-15 14:07:05 INFO () LineGobbler(voidCall):82 - 14:07:05 | 19 of 29 OK created table model dsc_sandbox.zendesk_goals_settings_conditions................................ [[32mCREATE TABLE (0.0 rows, 0.0 Bytes processed)[0m in 2.65s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 20 of 29 OK created incremental model dsc_sandbox.zendesk_chats_webpath...................................... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.48s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 22 of 29 OK created incremental model dsc_sandbox.zendesk_chats_conversions.................................. [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.41s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 21 of 29 OK created incremental model dsc_sandbox.zendesk_chats_count........................................ [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.69s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 24 of 29 OK created incremental model dsc_sandbox.zendesk_chats_visitor...................................... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.78s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 25 of 29 OK created incremental model dsc_sandbox.zendesk_chats_history...................................... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.85s]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 27 of 29 START incremental model dsc_sandbox.zendesk_chats_conversions_attribution........................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:11 INFO () LineGobbler(voidCall):82 - 14:07:11 | 26 of 29 OK created incremental model dsc_sandbox.zendesk_agents_roles....................................... [[32mMERGE (625.0 rows, 75.7 KB processed)[0m in 6.56s]
[32mnormalization[0m - 2021-12-15 14:07:12 INFO () LineGobbler(voidCall):82 - 14:07:12 | 28 of 29 START incremental model dsc_sandbox.zendesk_chats_history_conversion................................ [RUN]
[32mnormalization[0m - 2021-12-15 14:07:14 INFO () LineGobbler(voidCall):82 - 14:07:14 | 23 of 29 OK created incremental model dsc_sandbox.zendesk_chats_response_time................................ [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 9.89s]
[32mnormalization[0m - 2021-12-15 14:07:18 INFO () LineGobbler(voidCall):82 - 14:07:18 | 28 of 29 OK created incremental model dsc_sandbox.zendesk_chats_history_conversion........................... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.17s]
[32mnormalization[0m - 2021-12-15 14:07:18 INFO () LineGobbler(voidCall):82 - 14:07:18 | 27 of 29 OK created incremental model dsc_sandbox.zendesk_chats_conversions_attribution...................... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 7.01s]
[32mnormalization[0m - 2021-12-15 14:07:19 INFO () LineGobbler(voidCall):82 - 14:07:19 | 29 of 29 START incremental model dsc_sandbox.zendesk_chats_history_conversion_attribution.................... [RUN]
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - 14:07:25 | 29 of 29 OK created incremental model dsc_sandbox.zendesk_chats_history_conversion_attribution............... [[32mMERGE (0.0 rows, 0.0 Bytes processed)[0m in 6.38s]
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - 14:07:25 | 
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - 14:07:25 | Finished running 16 table models, 13 incremental models in 30.23s.
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - 
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - [32mCompleted successfully[0m
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - 
[32mnormalization[0m - 2021-12-15 14:07:25 INFO () LineGobbler(voidCall):82 - Done. PASS=29 WARN=0 ERROR=0 SKIP=0 TOTAL=29
2021-12-15 14:07:25 INFO () DefaultNormalizationWorker(run):69 - Normalization executed in 37 seconds.
2021-12-15 14:07:25 INFO () TemporalAttemptExecution(get):137 - Stopping cancellation check scheduling...