2022-08-12 22:30:43 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/840/0/logs.log 2022-08-12 22:30:43 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.23-alpha 2022-08-12 22:30:43 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-google-ads:0.1.44 exists... 2022-08-12 22:30:43 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-google-ads:0.1.44 was found locally. 2022-08-12 22:30:43 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 840 2022-08-12 22:30:43 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/840/0 --log-driver none --name source-google-ads-check-840-0-frufh --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-google-ads:0.1.44 -e AIRBYTE_VERSION=0.39.23-alpha -e WORKER_JOB_ID=840 airbyte/source-google-ads:0.1.44 check --config source_config.json 2022-08-12 22:30:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Checking the config 2022-08-12 22:30:57 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):97 - Check succeeded 2022-08-12 22:30:57 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-08-12 22:30:57 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/840/0/logs.log 2022-08-12 22:30:57 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.23-alpha 2022-08-12 22:30:57 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mssql:0.1.20 exists... 2022-08-12 22:30:57 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mssql:0.1.20 was found locally. 2022-08-12 22:30:57 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 840 2022-08-12 22:30:57 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/840/0 --log-driver none --name destination-mssql-check-840-0-styvz --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mssql:0.1.20 -e AIRBYTE_VERSION=0.39.23-alpha -e WORKER_JOB_ID=840 airbyte/destination-mssql:0.1.20 check --config source_config.json 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Class path contains multiple SLF4J bindings. 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-08-12 22:30:57 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-08-12 22:30:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:58 INFO i.a.i.d.m.MSSQLDestination(main):104 - starting destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination 2022-08-12 22:30:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:58 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-08-12 22:30:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:58 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-08-12 22:30:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:58 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK 2022-08-12 22:30:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:58 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 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-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 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-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-08-12 22:30:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:30:59 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-08-12 22:31:00 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:31:00 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated... 2022-08-12 22:31:00 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-12 22:31:00 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed. 2022-08-12 22:31:00 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-08-12 22:31:00 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/840/0/logs.log 2022-08-12 22:31:00 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.23-alpha 2022-08-12 22:31:00 INFO i.a.w.g.DefaultReplicationWorker(run):115 - start sync worker. job id: 840 attempt id: 0 2022-08-12 22:31:00 INFO i.a.w.g.DefaultReplicationWorker(run):127 - configured sync modes: {null.shopping_performance_report=incremental - append} 2022-08-12 22:31:00 INFO i.a.w.i.DefaultAirbyteDestination(start):69 - Running destination... 2022-08-12 22:31:00 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mssql:0.1.20 exists... 2022-08-12 22:31:00 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mssql:0.1.20 was found locally. 2022-08-12 22:31:00 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 840 2022-08-12 22:31:00 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/840/0 --log-driver none --name destination-mssql-write-840-0-zawyt --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mssql:0.1.20 -e AIRBYTE_VERSION=0.39.23-alpha -e WORKER_JOB_ID=840 airbyte/destination-mssql:0.1.20 write --config destination_config.json --catalog destination_catalog.json 2022-08-12 22:31:00 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-google-ads:0.1.44 exists... 2022-08-12 22:31:00 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-google-ads:0.1.44 was found locally. 2022-08-12 22:31:00 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 840 2022-08-12 22:31:00 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/840/0 --log-driver none --name source-google-ads-read-840-0-afxne --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-google-ads:0.1.44 -e AIRBYTE_VERSION=0.39.23-alpha -e WORKER_JOB_ID=840 airbyte/source-google-ads:0.1.44 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-08-12 22:31:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):405 - Destination output thread started. 2022-08-12 22:31:00 INFO i.a.w.g.DefaultReplicationWorker(run):169 - Waiting for source and destination threads to complete. 2022-08-12 22:31:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):298 - Replication thread started. 2022-08-12 22:31:01 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-08-12 22:31:01 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:31:01 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:31:01 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:31:01 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-12 22:31:01 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-08-12 22:31:01 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-08-12 22:31:01 source > Starting syncing SourceGoogleAds 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.d.m.MSSQLDestination(main):104 - starting destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 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-08-12 22:31:02 destination > 2022-08-12 22:31:02 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-08-12 22:31:02 destination > 2022-08-12 22:31:02 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-12 22:31:02 destination > 2022-08-12 22:31:02 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):97 - Write config: WriteConfig{streamName=evomcc_shopping_performance_report, namespace=google_ads, outputSchemaName=google_ads, tmpTableName=_airbyte_tmp_emk_evomcc_shopping_performance_report, outputTableName=_airbyte_raw_evomcc_shopping_performance_report, syncMode=append} 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):122 - Preparing tmp tables in destination started for 1 streams 2022-08-12 22:31:03 destination > 2022-08-12 22:31:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):126 - Preparing tmp table in destination started for stream evomcc_shopping_performance_report. schema: google_ads, tmp table name: _airbyte_tmp_emk_evomcc_shopping_performance_report 2022-08-12 22:31:04 destination > 2022-08-12 22:31:04 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):132 - Preparing tables in destination completed. 2022-08-12 22:31:11 source > Syncing stream: shopping_performance_report 2022-08-12 22:31:11 source > Setting state of shopping_performance_report stream to {'3927017757': {'segments.date': '2022-08-11'}} 2022-08-12 22:31:51 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 1000 (2 MB) 2022-08-12 22:31:55 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 2000 (4 MB) 2022-08-12 22:31:58 destination > 2022-08-12 22:31:58 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2709 records (24 MB) 2022-08-12 22:32:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 3000 (6 MB) 2022-08-12 22:32:03 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 4000 (9 MB) 2022-08-12 22:32:08 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 5000 (11 MB) 2022-08-12 22:32:11 destination > 2022-08-12 22:32:11 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2745 records (24 MB) 2022-08-12 22:32:15 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 6000 (13 MB) 2022-08-12 22:32:19 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 7000 (15 MB) 2022-08-12 22:32:23 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 8000 (18 MB) 2022-08-12 22:32:24 destination > 2022-08-12 22:32:24 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2777 records (24 MB) 2022-08-12 22:32:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 9000 (20 MB) 2022-08-12 22:32:31 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 10000 (22 MB) 2022-08-12 22:32:35 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 11000 (24 MB) 2022-08-12 22:32:36 destination > 2022-08-12 22:32:36 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2790 records (24 MB) 2022-08-12 22:32:44 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 12000 (27 MB) 2022-08-12 22:32:48 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 13000 (29 MB) 2022-08-12 22:32:51 destination > 2022-08-12 22:32:51 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2708 records (24 MB) 2022-08-12 22:32:52 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 14000 (31 MB) 2022-08-12 22:32:56 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 15000 (34 MB) 2022-08-12 22:33:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 16000 (36 MB) 2022-08-12 22:33:02 destination > 2022-08-12 22:33:02 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2738 records (24 MB) 2022-08-12 22:33:07 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 17000 (38 MB) 2022-08-12 22:33:10 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 18000 (41 MB) 2022-08-12 22:33:15 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 19000 (43 MB) 2022-08-12 22:33:16 destination > 2022-08-12 22:33:16 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2687 records (24 MB) 2022-08-12 22:33:19 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 20000 (45 MB) 2022-08-12 22:33:24 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 21000 (48 MB) 2022-08-12 22:33:27 destination > 2022-08-12 22:33:27 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2699 records (24 MB) 2022-08-12 22:33:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 22000 (50 MB) 2022-08-12 22:33:34 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 23000 (52 MB) 2022-08-12 22:33:38 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 24000 (54 MB) 2022-08-12 22:33:41 destination > 2022-08-12 22:33:41 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2753 records (24 MB) 2022-08-12 22:33:42 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 25000 (57 MB) 2022-08-12 22:33:46 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 26000 (59 MB) 2022-08-12 22:33:50 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 27000 (61 MB) 2022-08-12 22:33:52 destination > 2022-08-12 22:33:52 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2726 records (24 MB) 2022-08-12 22:33:57 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 28000 (63 MB) 2022-08-12 22:34:00 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 29000 (66 MB) 2022-08-12 22:34:05 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 30000 (68 MB) 2022-08-12 22:34:06 destination > 2022-08-12 22:34:06 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2751 records (24 MB) 2022-08-12 22:34:09 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 31000 (70 MB) 2022-08-12 22:34:13 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 32000 (73 MB) 2022-08-12 22:34:17 destination > 2022-08-12 22:34:17 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2726 records (24 MB) 2022-08-12 22:34:22 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 33000 (75 MB) 2022-08-12 22:34:23 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 34000 (77 MB) 2022-08-12 22:34:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 35000 (79 MB) 2022-08-12 22:34:30 destination > 2022-08-12 22:34:30 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2770 records (24 MB) 2022-08-12 22:34:32 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 36000 (82 MB) 2022-08-12 22:34:36 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 37000 (84 MB) 2022-08-12 22:34:40 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 38000 (86 MB) 2022-08-12 22:34:42 destination > 2022-08-12 22:34:42 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2770 records (24 MB) 2022-08-12 22:34:46 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 39000 (88 MB) 2022-08-12 22:34:51 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 40000 (91 MB) 2022-08-12 22:34:55 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 41000 (93 MB) 2022-08-12 22:34:56 destination > 2022-08-12 22:34:56 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2786 records (24 MB) 2022-08-12 22:34:59 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 42000 (95 MB) 2022-08-12 22:35:03 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 43000 (97 MB) 2022-08-12 22:35:07 destination > 2022-08-12 22:35:07 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2771 records (24 MB) 2022-08-12 22:35:07 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 44000 (100 MB) 2022-08-12 22:35:13 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 45000 (102 MB) 2022-08-12 22:35:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 46000 (104 MB) 2022-08-12 22:35:20 destination > 2022-08-12 22:35:20 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2734 records (24 MB) 2022-08-12 22:35:22 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 47000 (107 MB) 2022-08-12 22:35:26 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 48000 (109 MB) 2022-08-12 22:35:30 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 49000 (111 MB) 2022-08-12 22:35:32 destination > 2022-08-12 22:35:32 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2711 records (24 MB) 2022-08-12 22:35:36 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 50000 (113 MB) 2022-08-12 22:35:39 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 51000 (116 MB) 2022-08-12 22:35:43 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 52000 (118 MB) 2022-08-12 22:35:44 destination > 2022-08-12 22:35:44 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2690 records (24 MB) 2022-08-12 22:35:47 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 53000 (120 MB) 2022-08-12 22:35:51 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 54000 (123 MB) 2022-08-12 22:35:54 destination > 2022-08-12 22:35:54 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2672 records (24 MB) 2022-08-12 22:35:59 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 55000 (125 MB) 2022-08-12 22:36:01 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 56000 (127 MB) 2022-08-12 22:36:05 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 57000 (130 MB) 2022-08-12 22:36:08 destination > 2022-08-12 22:36:08 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2723 records (24 MB) 2022-08-12 22:36:11 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 58000 (132 MB) 2022-08-12 22:36:15 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 59000 (134 MB) 2022-08-12 22:36:20 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 60000 (137 MB) 2022-08-12 22:36:21 destination > 2022-08-12 22:36:21 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2767 records (24 MB) 2022-08-12 22:36:26 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 61000 (139 MB) 2022-08-12 22:36:30 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 62000 (141 MB) 2022-08-12 22:36:34 destination > 2022-08-12 22:36:34 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2727 records (24 MB) 2022-08-12 22:36:34 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 63000 (143 MB) 2022-08-12 22:36:38 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 64000 (146 MB) 2022-08-12 22:36:42 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 65000 (148 MB) 2022-08-12 22:36:45 destination > 2022-08-12 22:36:45 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2792 records (24 MB) 2022-08-12 22:36:50 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 66000 (150 MB) 2022-08-12 22:36:52 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 67000 (152 MB) 2022-08-12 22:36:57 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 68000 (155 MB) 2022-08-12 22:36:59 destination > 2022-08-12 22:36:59 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2723 records (24 MB) 2022-08-12 22:37:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 69000 (157 MB) 2022-08-12 22:37:05 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 70000 (159 MB) 2022-08-12 22:37:10 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 71000 (162 MB) 2022-08-12 22:37:11 destination > 2022-08-12 22:37:11 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2716 records (24 MB) 2022-08-12 22:37:17 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 72000 (164 MB) 2022-08-12 22:37:21 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 73000 (166 MB) 2022-08-12 22:37:25 destination > 2022-08-12 22:37:25 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2727 records (24 MB) 2022-08-12 22:37:25 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 74000 (168 MB) 2022-08-12 22:37:32 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 75000 (171 MB) 2022-08-12 22:37:37 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 76000 (173 MB) 2022-08-12 22:37:40 destination > 2022-08-12 22:37:40 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2712 records (24 MB) 2022-08-12 22:37:41 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 77000 (175 MB) 2022-08-12 22:37:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 78000 (178 MB) 2022-08-12 22:37:50 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 79000 (180 MB) 2022-08-12 22:37:52 destination > 2022-08-12 22:37:52 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 2719 records (24 MB) 2022-08-12 22:37:57 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):324 - Records read: 80000 (182 MB) 2022-08-12 22:39:52 source > Read 80164 records from shopping_performance_report stream 2022-08-12 22:39:52 source > Finished syncing shopping_performance_report 2022-08-12 22:39:52 source > SourceGoogleAds runtimes: Syncing stream shopping_performance_report 0:08:41.421351 2022-08-12 22:39:52 source > Finished syncing SourceGoogleAds 2022-08-12 22:39:53 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):335 - Total records read: 80219 (183 MB) 2022-08-12 22:39:53 INFO i.a.w.g.DefaultReplicationWorker(run):174 - One of source or destination thread complete. Waiting on the other. 2022-08-12 22:39:53 destination > 2022-08-12 22:39:53 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-08-12 22:39:53 destination > 2022-08-12 22:39:53 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure. 2022-08-12 22:39:53 destination > 2022-08-12 22:39:53 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing evomcc_shopping_performance_report: 845 records (7 MB) 2022-08-12 22:39:56 destination > 2022-08-12 22:39:56 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):137 - No onDestinationCloseOperations required for this destination. 2022-08-12 22:39:56 destination > 2022-08-12 22:39:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):162 - Finalizing tables in destination started for 1 streams 2022-08-12 22:39:56 destination > 2022-08-12 22:39:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):167 - Finalizing stream evomcc_shopping_performance_report. schema google_ads, tmp table _airbyte_tmp_emk_evomcc_shopping_performance_report, final table _airbyte_raw_evomcc_shopping_performance_report 2022-08-12 22:39:56 destination > 2022-08-12 22:39:56 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):180 - Executing finalization of tables. 2022-08-12 22:40:06 destination > 2022-08-12 22:40:06 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):182 - Finalizing tables in destination completed. 2022-08-12 22:40:06 destination > 2022-08-12 22:40:06 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):185 - Cleaning tmp tables in destination started for 1 streams 2022-08-12 22:40:06 destination > 2022-08-12 22:40:06 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):189 - Cleaning tmp table in destination started for stream evomcc_shopping_performance_report. schema google_ads, tmp table name: _airbyte_tmp_emk_evomcc_shopping_performance_report 2022-08-12 22:40:07 destination > 2022-08-12 22:40:07 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):194 - Cleaning tmp tables in destination completed. 2022-08-12 22:40:07 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):415 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@282b312a[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@26ecca5f[stateType=,stream=,global=,data={"shopping_performance_report":{"3927017757":{"segments.date":"2022-08-12"}}},additionalProperties={}],trace=,additionalProperties={}] 2022-08-12 22:40:07 destination > 2022-08-12 22:40:07 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-08-12 22:40:07 destination > 2022-08-12 22:40:07 INFO i.a.i.d.m.MSSQLDestination(main):106 - completed destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination 2022-08-12 22:40:07 INFO i.a.w.g.DefaultReplicationWorker(run):176 - Source and destination threads complete. 2022-08-12 22:40:07 INFO i.a.w.g.DefaultReplicationWorker(run):239 - sync summary: io.airbyte.config.ReplicationAttemptSummary@5e2ddda9[status=completed,recordsSynced=80164,bytesSynced=192056839,startTime=1660343460260,endTime=1660344007127,totalStats=io.airbyte.config.SyncStats@8e53eae[recordsEmitted=80164,bytesEmitted=192056839,stateMessagesEmitted=55,recordsCommitted=80164],streamStats=[io.airbyte.config.StreamSyncStats@868fc0[streamName=evomcc_shopping_performance_report,stats=io.airbyte.config.SyncStats@231f9ff1[recordsEmitted=80164,bytesEmitted=192056839,stateMessagesEmitted=,recordsCommitted=80164]]]] 2022-08-12 22:40:07 INFO i.a.w.g.DefaultReplicationWorker(run):266 - Source output at least one state message 2022-08-12 22:40:07 INFO i.a.w.g.DefaultReplicationWorker(run):272 - State capture: Updated state to: Optional[io.airbyte.config.State@136fceae[state={"shopping_performance_report":{"3927017757":{"segments.date":"2022-08-12"}}}]] 2022-08-12 22:40:07 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-08-12 22:40:07 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):157 - sync summary: io.airbyte.config.StandardSyncOutput@2692683a[standardSyncSummary=io.airbyte.config.StandardSyncSummary@b5d6fd5[status=completed,recordsSynced=80164,bytesSynced=192056839,startTime=1660343460260,endTime=1660344007127,totalStats=io.airbyte.config.SyncStats@8e53eae[recordsEmitted=80164,bytesEmitted=192056839,stateMessagesEmitted=55,recordsCommitted=80164],streamStats=[io.airbyte.config.StreamSyncStats@868fc0[streamName=evomcc_shopping_performance_report,stats=io.airbyte.config.SyncStats@231f9ff1[recordsEmitted=80164,bytesEmitted=192056839,stateMessagesEmitted=,recordsCommitted=80164]]]],normalizationSummary=,state=io.airbyte.config.State@136fceae[state={"shopping_performance_report":{"3927017757":{"segments.date":"2022-08-12"}}}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@17feabd5[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@73dbf28c[stream=io.airbyte.protocol.models.AirbyteStream@46bd9775[name=evomcc_shopping_performance_report,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"ad_group.id":{"type":["null","integer"]},"campaign.id":{"type":["null","integer"]},"customer.id":{"type":["null","integer"]},"metrics.ctr":{"type":["null","number"]},"ad_group.name":{"type":["null","string"]},"campaign.name":{"type":["null","string"]},"segments.date":{"type":["null","string"],"format":"datetime"},"segments.week":{"type":["null","string"]},"segments.year":{"type":["null","integer"]},"metrics.clicks":{"type":["null","integer"]},"segments.month":{"type":["null","string"]},"ad_group.status":{"type":["null","string"]},"campaign.status":{"type":["null","string"]},"segments.device":{"type":["null","string"]},"segments.quarter":{"type":["null","string"]},"metrics.average_cpc":{"type":["null","number"]},"metrics.conversions":{"type":["null","number"]},"metrics.cost_micros":{"type":["null","integer"]},"metrics.impressions":{"type":["null","integer"]},"segments.click_type":{"type":["null","string"]},"segments.day_of_week":{"type":["null","string"]},"segments.product_brand":{"type":["null","string"]},"segments.product_title":{"type":["null","string"]},"metrics.all_conversions":{"type":["null","number"]},"segments.ad_network_type":{"type":["null","string"]},"segments.product_channel":{"type":["null","string"]},"segments.product_country":{"type":["null","string"]},"segments.product_item_id":{"type":["null","string"]},"segments.product_type_l1":{"type":["null","string"]},"segments.product_type_l2":{"type":["null","string"]},"segments.product_type_l3":{"type":["null","string"]},"segments.product_type_l4":{"type":["null","string"]},"segments.product_type_l5":{"type":["null","string"]},"customer.descriptive_name":{"type":["null","string"]},"metrics.conversions_value":{"type":["null","number"]},"segments.product_language":{"type":["null","string"]},"segments.product_store_id":{"type":["null","string"]},"segments.product_condition":{"type":["null","string"]},"metrics.cost_per_conversion":{"type":["null","number"]},"metrics.value_per_conversion":{"type":["null","number"]},"segments.product_merchant_id":{"type":["null","integer"]},"metrics.all_conversions_value":{"type":["null","number"]},"segments.product_aggregator_id":{"type":["null","integer"]},"metrics.cost_per_all_conversions":{"type":["null","number"]},"metrics.cross_device_conversions":{"type":["null","number"]},"metrics.value_per_all_conversions":{"type":["null","number"]},"segments.product_custom_attribute0":{"type":["null","string"]},"segments.product_custom_attribute1":{"type":["null","string"]},"segments.product_custom_attribute2":{"type":["null","string"]},"segments.product_custom_attribute3":{"type":["null","string"]},"segments.product_custom_attribute4":{"type":["null","string"]},"segments.product_channel_exclusivity":{"type":["null","string"]},"segments.product_bidding_category_level1":{"type":["null","string"]},"segments.product_bidding_category_level2":{"type":["null","string"]},"segments.product_bidding_category_level3":{"type":["null","string"]},"segments.product_bidding_category_level4":{"type":["null","string"]},"segments.product_bidding_category_level5":{"type":["null","string"]},"metrics.conversions_from_interactions_rate":{"type":["null","number"]},"metrics.all_conversions_from_interactions_rate":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[segments.date],sourceDefinedPrimaryKey=[],namespace=google_ads,additionalProperties={}],syncMode=incremental,cursorField=[segments.date],destinationSyncMode=append,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-08-12 22:40:07 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):291 - Stopping temporal heartbeating... 2022-08-12 22:40:07 INFO i.a.c.p.ConfigRepository(updateConnectionState):775 - Updating connection c96bb755-2801-469c-b1f4-ba6f7df7db3b state: io.airbyte.config.State@68df1920[state={"shopping_performance_report":{"3927017757":{"segments.date":"2022-08-12"}}}] 2022-08-12 22:40:07 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/840/0/logs.log 2022-08-12 22:40:07 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.39.23-alpha 2022-08-12 22:40:07 INFO i.a.w.g.DefaultNormalizationWorker(run):49 - Running normalization. 2022-08-12 22:40:07 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):122 - Running with normalization version: airbyte/normalization-mssql:0.2.6 2022-08-12 22:40:07 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/normalization-mssql:0.2.6 exists... 2022-08-12 22:40:07 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/normalization-mssql:0.2.6 was found locally. 2022-08-12 22:40:07 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 840 2022-08-12 22:40:07 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/840/0/normalize --log-driver none --name normalization-mssql-normalize-840-0-gpcgt --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.39.23-alpha airbyte/normalization-mssql:0.2.6 run --integration-type mssql --config destination_config.json --catalog destination_catalog.json 2022-08-12 22:40:07 normalization > Running: transform-config --config destination_config.json --integration-type mssql --out /data/840/0/normalize 2022-08-12 22:40:07 normalization > Namespace(config='destination_config.json', integration_type=, out='/data/840/0/normalize') 2022-08-12 22:40:07 normalization > transform_mssql 2022-08-12 22:40:07 normalization > Running: transform-catalog --integration-type mssql --profile-config-dir /data/840/0/normalize --catalog destination_catalog.json --out /data/840/0/normalize/models/generated/ --json-column _airbyte_data 2022-08-12 22:40:08 normalization > Processing destination_catalog.json... 2022-08-12 22:40:08 normalization > Truncating metrics.all_conversions_from_interactions_rate (#46) to metrics.all_conversio_rom_interactions_rate (#44) 2022-08-12 22:40:08 normalization > Truncating metrics.all_conversions_from_interactions_rate (#46) to metrics.all_conversio_rom_interactions_rate (#44) 2022-08-12 22:40:08 normalization > Truncating metrics.all_conversions_from_interactions_rate (#46) to metrics.all_conversio_rom_interactions_rate (#44) 2022-08-12 22:40:08 normalization > Truncating metrics.all_conversions_from_interactions_rate (#46) to metrics.all_conversio_rom_interactions_rate (#44) 2022-08-12 22:40:08 normalization > Generating airbyte_ctes/google_ads/evomcc_shopping_performance_report_ab1.sql from evomcc_shopping_performance_report 2022-08-12 22:40:08 normalization > Generating airbyte_ctes/google_ads/evomcc_shopping_performance_report_ab2.sql from evomcc_shopping_performance_report 2022-08-12 22:40:08 normalization > Truncating _airbyte_evomcc_shopping_performance_report_hashid (#50) to _airbyte_evomcc_shopp_ormance_report_hashid (#44) 2022-08-12 22:40:08 normalization > Generating airbyte_ctes/google_ads/evomcc_shopping_performance_report_ab3.sql from evomcc_shopping_performance_report 2022-08-12 22:40:08 normalization > Truncating _airbyte_evomcc_shopping_performance_report_hashid (#50) to _airbyte_evomcc_shopp_ormance_report_hashid (#44) 2022-08-12 22:40:08 normalization > Generating airbyte_incremental/google_ads/evomcc_shopping_performance_report.sql from evomcc_shopping_performance_report 2022-08-12 22:40:08 normalization > detected no config file for ssh, assuming ssh is off. 2022-08-12 22:40:10 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-08-12 22:40:10 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-08-12 22:40:10 normalization > 2022-08-12 22:40:10 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-08-12 22:40:10 normalization > 2022-08-12 22:40:13 normalization > 22:40:13 Running with dbt=1.0.0 2022-08-12 22:40:13 normalization > 22:40:13 Partial parse save file not found. Starting full parse. 2022-08-12 22:40:14 normalization > 22:40:14 [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. 2022-08-12 22:40:14 normalization > There are 2 unused configuration paths: 2022-08-12 22:40:14 normalization > - models.airbyte_utils.generated.airbyte_tables 2022-08-12 22:40:14 normalization > - models.airbyte_utils.generated.airbyte_views 2022-08-12 22:40:14 normalization > 2022-08-12 22:40:14 normalization > 22:40:14 Found 4 models, 0 tests, 0 snapshots, 0 analyses, 548 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-08-12 22:40:14 normalization > 22:40:14 2022-08-12 22:40:14 normalization > 22:40:14 Concurrency: 8 threads (target='prod') 2022-08-12 22:40:14 normalization > 22:40:14 2022-08-12 22:40:15 normalization > 22:40:15 1 of 1 START incremental model google_ads.evomcc_shopping_performance_report............................................ [RUN] 2022-08-12 22:44:40 normalization > 22:44:40 1 of 1 OK created incremental model google_ads.evomcc_shopping_performance_report....................................... [OK in 265.25s] 2022-08-12 22:44:40 normalization > 22:44:40 2022-08-12 22:44:40 normalization > 22:44:40 Finished running 1 incremental model in 265.86s. 2022-08-12 22:44:40 normalization > 22:44:40 2022-08-12 22:44:40 normalization > 22:44:40 Completed successfully 2022-08-12 22:44:40 normalization > 22:44:40 2022-08-12 22:44:40 normalization > 22:44:40 Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1 2022-08-12 22:44:40 INFO i.a.w.g.DefaultNormalizationWorker(run):73 - Normalization executed in 4 minutes 33 seconds. 2022-08-12 22:44:40 INFO i.a.w.g.DefaultNormalizationWorker(run):79 - Normalization summary: io.airbyte.config.NormalizationSummary@a9b8b43[startTime=1660344007197,endTime=1660344280917] 2022-08-12 22:44:40 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-08-12 22:44:40 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):291 - Stopping temporal heartbeating...