2022-07-29 08:58:08 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. 
errors: $.ssl_method: must be a constant value unencrypted, $.ssl_method: does not have a value in the enumeration [unencrypted]
2022-07-29 08:58:08 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/26/0/logs.log
2022-07-29 08:58:08 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.39.41-alpha
2022-07-29 08:58:08 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-file:0.2.14 exists...
2022-07-29 08:58:08 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-file:0.2.14 was found locally.
2022-07-29 08:58:08 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 26
2022-07-29 08:58:08 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/26/0 --log-driver none --name source-file-check-26-0-tgolb --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-file:0.2.14 -e AIRBYTE_VERSION=0.39.41-alpha -e WORKER_JOB_ID=26 airbyte/source-file:0.2.14 check --config source_config.json
2022-07-29 08:58:10 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Checking access to https://opendata.dwd.de/climate_environment/CDC/regional_averages_DE/annual/sunshine_duration/regional_averages_sd_year.txt...
2022-07-29 08:58:10 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - TransportParams: None
2022-07-29 08:58:10 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Check succeeded
2022-07-29 08:58:10 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-07-29 08:58:10 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/26/0/logs.log
2022-07-29 08:58:10 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.39.41-alpha
2022-07-29 08:58:10 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mssql:0.1.20 exists...
2022-07-29 08:58:10 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mssql:0.1.20 was found locally.
2022-07-29 08:58:10 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 26
2022-07-29 08:58:10 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/26/0 --log-driver none --name destination-mssql-check-26-0-hpklq --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -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.41-alpha -e WORKER_JOB_ID=26 airbyte/destination-mssql:0.1.20 check --config source_config.json
2022-07-29 08:58:11 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Class path contains multiple SLF4J bindings.
2022-07-29 08:58:11 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-07-29 08:58:11 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-07-29 08:58:11 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-07-29 08:58:11 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-07-29 08:58:11 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
2022-07-29 08:58:11 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.d.m.MSSQLDestination(main):104 - starting destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json}
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 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-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 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-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 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-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 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-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
2022-07-29 08:58:12 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:12 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
2022-07-29 08:58:13 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:13 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated...
2022-07-29 08:58:13 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:13 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.
2022-07-29 08:58:13 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:13 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-07-29 08:58:13 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-07-29 08:58:13 INFO i.a.i.d.m.MSSQLDestination(main):106 - completed destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination
2022-07-29 08:58:13 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-07-29 08:58:13 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/26/0/logs.log
2022-07-29 08:58:13 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.39.41-alpha
2022-07-29 08:58:13 INFO i.a.w.g.DefaultReplicationWorker(run):116 - start sync worker. job id: 26 attempt id: 0
2022-07-29 08:58:13 INFO i.a.w.g.DefaultReplicationWorker(run):128 - configured sync modes: {null.DWD_DE_annual_sunshine-duration_regional-averages=full_refresh - overwrite}
2022-07-29 08:58:13 INFO i.a.w.i.DefaultAirbyteDestination(start):69 - Running destination...
2022-07-29 08:58:13 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mssql:0.1.20 exists...
2022-07-29 08:58:13 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mssql:0.1.20 was found locally.
2022-07-29 08:58:13 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 26
2022-07-29 08:58:13 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/26/0 --log-driver none --name destination-mssql-write-26-0-qxsfj --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -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.41-alpha -e WORKER_JOB_ID=26 airbyte/destination-mssql:0.1.20 write --config destination_config.json --catalog destination_catalog.json
2022-07-29 08:58:13 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-file:0.2.14 exists...
2022-07-29 08:58:13 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-file:0.2.14 was found locally.
2022-07-29 08:58:13 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 26
2022-07-29 08:58:13 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/26/0 --log-driver none --name source-file-read-26-0-heygl --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-file:0.2.14 -e AIRBYTE_VERSION=0.39.41-alpha -e WORKER_JOB_ID=26 airbyte/source-file:0.2.14 read --config source_config.json --catalog source_catalog.json --state input_state.json
2022-07-29 08:58:13 INFO i.a.w.g.DefaultReplicationWorker(run):170 - Waiting for source and destination threads to complete.
2022-07-29 08:58:13 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):299 - Replication thread started.
2022-07-29 08:58:13 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):406 - Destination output thread started.
2022-07-29 08:58:13 destination > SLF4J: Class path contains multiple SLF4J bindings.
2022-07-29 08:58:13 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-07-29 08:58:13 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-07-29 08:58:13 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-07-29 08:58:13 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-07-29 08:58:13 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
2022-07-29 08:58:14 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 INFO i.a.i.d.m.MSSQLDestination(main):104 - starting destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json}
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'}
2022-07-29 08:58:14 destination > 2022-07-29 08:58:14 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-07-29 08:58:14 destination > 2022-07-29 08:58:14 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-07-29 08:58:14 destination > 2022-07-29 08:58:14 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-07-29 08:58:14 destination > 2022-07-29 08:58:14 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-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):97 - Write config: WriteConfig{streamName=elt_DWD_DE_annual_sunshine-duration_regional-averages, namespace=null, outputSchemaName=AIRBYTE_ELT, tmpTableName=_airbyte_tmp_bie_elt_DWD_DE_annual_sunshine_duration_regional_averages, outputTableName=_airbyte_raw_elt_DWD_DE_annual_sunshine_duration_regional_averages, syncMode=overwrite}
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started.
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):122 - Preparing tmp tables in destination started for 1 streams
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):126 - Preparing tmp table in destination started for stream elt_DWD_DE_annual_sunshine-duration_regional-averages. schema: AIRBYTE_ELT, tmp table name: _airbyte_tmp_bie_elt_DWD_DE_annual_sunshine_duration_regional_averages
2022-07-29 08:58:15 source > Reading DWD_DE_annual_sunshine-duration_regional-averages (https://opendata.dwd.de/climate_environment/CDC/regional_averages_DE/annual/sunshine_duration/regional_averages_sd_year.txt)...
2022-07-29 08:58:15 source > TransportParams: None
2022-07-29 08:58:15 destination > 2022-07-29 08:58:15 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):132 - Preparing tables in destination completed.
2022-07-29 08:58:15 source > /airbyte/integration_code/source_file/client.py:364: FutureWarning: Passing a set as an indexer is deprecated and will raise in a future version. Use a list instead.
2022-07-29 08:58:15 source >   yield from df[columns].to_dict(orient="records")
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):328 - Source has no more messages, closing connection.
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):336 - Total records read: 71 (29 KB)
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(run):175 - One of source or destination thread complete. Waiting on the other.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing elt_DWD_DE_annual_sunshine-duration_regional-averages: 71 records (119 KB)
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):137 - No onDestinationCloseOperations required for this destination.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):162 - Finalizing tables in destination started for 1 streams
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):167 - Finalizing stream elt_DWD_DE_annual_sunshine-duration_regional-averages. schema AIRBYTE_ELT, tmp table _airbyte_tmp_bie_elt_DWD_DE_annual_sunshine_duration_regional_averages, final table _airbyte_raw_elt_DWD_DE_annual_sunshine_duration_regional_averages
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):180 - Executing finalization of tables.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):182 - Finalizing tables in destination completed.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):185 - Cleaning tmp tables in destination started for 1 streams
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):189 - Cleaning tmp table in destination started for stream elt_DWD_DE_annual_sunshine-duration_regional-averages. schema AIRBYTE_ELT, tmp table name: _airbyte_tmp_bie_elt_DWD_DE_annual_sunshine_duration_regional_averages
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):194 - Cleaning tmp tables in destination completed.
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-07-29 08:58:16 destination > 2022-07-29 08:58:16 INFO i.a.i.d.m.MSSQLDestination(main):106 - completed destination: class io.airbyte.integrations.destination.mssql.MSSQLDestination
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(run):177 - Source and destination threads complete.
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(run):240 - sync summary: io.airbyte.config.ReplicationAttemptSummary@7840e674[status=completed,recordsSynced=71,bytesSynced=30672,startTime=1659085093426,endTime=1659085096506,totalStats=io.airbyte.config.SyncStats@39c54e29[recordsEmitted=71,bytesEmitted=30672,stateMessagesEmitted=0,recordsCommitted=71],streamStats=[io.airbyte.config.StreamSyncStats@1ecaad92[streamName=elt_DWD_DE_annual_sunshine-duration_regional-averages,stats=io.airbyte.config.SyncStats@7336bfaa[recordsEmitted=71,bytesEmitted=30672,stateMessagesEmitted=<null>,recordsCommitted=71]]]]
2022-07-29 08:58:16 INFO i.a.w.g.DefaultReplicationWorker(run):269 - Source did not output any state messages
2022-07-29 08:58:16 WARN i.a.w.g.DefaultReplicationWorker(run):277 - State capture: No new state, falling back on input state: io.airbyte.config.State@cba84fe[state={}]
2022-07-29 08:58:16 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-07-29 08:58:16 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):161 - sync summary: io.airbyte.config.StandardSyncOutput@5530f2b3[standardSyncSummary=io.airbyte.config.StandardSyncSummary@392d8206[status=completed,recordsSynced=71,bytesSynced=30672,startTime=1659085093426,endTime=1659085096506,totalStats=io.airbyte.config.SyncStats@39c54e29[recordsEmitted=71,bytesEmitted=30672,stateMessagesEmitted=0,recordsCommitted=71],streamStats=[io.airbyte.config.StreamSyncStats@1ecaad92[streamName=elt_DWD_DE_annual_sunshine-duration_regional-averages,stats=io.airbyte.config.SyncStats@7336bfaa[recordsEmitted=71,bytesEmitted=30672,stateMessagesEmitted=<null>,recordsCommitted=71]]]],normalizationSummary=<null>,state=io.airbyte.config.State@cba84fe[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@7059adf2[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@5285db26[stream=io.airbyte.protocol.models.AirbyteStream@f20eaf[name=elt_DWD_DE_annual_sunshine-duration_regional-averages,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"Jahr":{"type":["number","null"]},"Bayern":{"type":["number","null"]},"Hessen":{"type":["number","null"]},"Sachsen":{"type":["number","null"]},"Saarland":{"type":["number","null"]},"Thueringen":{"type":["number","null"]},"Brandenburg":{"type":["number","null"]},"Deutschland":{"type":["number","null"]},"Niedersachsen":{"type":["number","null"]},"Sachsen-Anhalt":{"type":["number","null"]},"Rheinland-Pfalz":{"type":["number","null"]},"Baden-Wuerttemberg":{"type":["number","null"]},"Brandenburg/Berlin":{"type":["number","null"]},"Schleswig-Holstein":{"type":["number","null"]},"Nordrhein-Westfalen":{"type":["number","null"]},"Mecklenburg-Vorpommern":{"type":["number","null"]},"Thueringen/Sachsen-Anhalt":{"type":["number","null"]},"Niedersachsen/Hamburg/Bremen":{"type":["number","null"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]]
2022-07-29 08:58:16 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):291 - Stopping temporal heartbeating...
2022-07-29 08:58:16 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/26/0/logs.log
2022-07-29 08:58:16 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.39.41-alpha
2022-07-29 08:58:16 INFO i.a.w.g.DefaultNormalizationWorker(run):50 - Running normalization.
2022-07-29 08:58:16 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):122 - Running with normalization version: airbyte/normalization-mssql:0.2.12
2022-07-29 08:58:16 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/normalization-mssql:0.2.12 exists...
2022-07-29 08:58:16 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/normalization-mssql:0.2.12 was found locally.
2022-07-29 08:58:16 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 26
2022-07-29 08:58:16 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/26/0/normalize --log-driver none --name normalization-mssql-normalize-26-0-iudkz --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.41-alpha airbyte/normalization-mssql:0.2.12 run --integration-type mssql --config destination_config.json --catalog destination_catalog.json
2022-07-29 08:58:16 normalization > Running: transform-config --config destination_config.json --integration-type mssql --out /data/26/0/normalize
2022-07-29 08:58:17 normalization > Namespace(config='destination_config.json', integration_type=<DestinationType.MSSQL: 'mssql'>, out='/data/26/0/normalize')
2022-07-29 08:58:17 normalization > transform_mssql
2022-07-29 08:58:17 normalization > Running: transform-catalog --integration-type mssql --profile-config-dir /data/26/0/normalize --catalog destination_catalog.json --out /data/26/0/normalize/models/generated/ --json-column _airbyte_data
2022-07-29 08:58:17 normalization > Processing destination_catalog.json...
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization >   Generating airbyte_ctes/airbyte_elt/elt_dwd_de_annual_sun__ion_regional_averages_ab1.sql from elt_DWD_DE_annual_sunshine-duration_regional-averages
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization >   Generating airbyte_ctes/airbyte_elt/elt_dwd_de_annual_sun__ion_regional_averages_ab2.sql from elt_DWD_DE_annual_sunshine-duration_regional-averages
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization > Truncating _airbyte_elt_dwd_de_annual_sun__ion_regional_averages_hashid (#60) to _airbyte_elt_dwd_de_a_ional_averages_hashid (#44)
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization >   Generating airbyte_ctes/airbyte_elt/elt_dwd_de_annual_sun__ion_regional_averages_ab3.sql from elt_DWD_DE_annual_sunshine-duration_regional-averages
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization > Truncating _airbyte_elt_dwd_de_annual_sun__ion_regional_averages_hashid (#60) to _airbyte_elt_dwd_de_a_ional_averages_hashid (#44)
2022-07-29 08:58:17 normalization > Truncating elt_DWD_DE_annual_sunshine_duration_regional_averages (#53) to elt_DWD_DE_annual_sun_ion_regional_averages (#44)
2022-07-29 08:58:17 normalization >   Generating airbyte_tables/airbyte_elt/elt_dwd_de_annual_sun__ion_regional_averages.sql from elt_DWD_DE_annual_sunshine-duration_regional-averages
2022-07-29 08:58:17 normalization > detected no config file for ssh, assuming ssh is off.
2022-07-29 08:58:20 normalization >            [--event-buffer-size EVENT_BUFFER_SIZE]
2022-07-29 08:58:20 normalization >   --event-buffer-size EVENT_BUFFER_SIZE
2022-07-29 08:58:20 normalization > 
2022-07-29 08:58:20 normalization > DBT >=1.0.0 detected; using 10K event buffer size
2022-07-29 08:58:20 normalization > 
2022-07-29 08:58:23 normalization > 08:58:23  Running with dbt=1.0.0
2022-07-29 08:58:23 normalization > 08:58:23  Partial parse save file not found. Starting full parse.
2022-07-29 08:58:25 normalization > 08:58:25  [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
2022-07-29 08:58:25 normalization > There are 2 unused configuration paths:
2022-07-29 08:58:25 normalization > - models.airbyte_utils.generated.airbyte_views
2022-07-29 08:58:25 normalization > - models.airbyte_utils.generated.airbyte_incremental
2022-07-29 08:58:25 normalization > 
2022-07-29 08:58:25 normalization > 08:58:25  Found 4 models, 0 tests, 0 snapshots, 0 analyses, 580 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics
2022-07-29 08:58:25 normalization > 08:58:25  
2022-07-29 08:58:25 normalization > 08:58:25  Concurrency: 8 threads (target='prod')
2022-07-29 08:58:25 normalization > 08:58:25  
2022-07-29 08:58:25 normalization > 08:58:25  1 of 1 START table model airbyte_elt.elt_dwd_de_annual_sun__ion_regional_averages....................................... [RUN]
2022-07-29 08:58:26 normalization > 08:58:26  1 of 1 OK created table model airbyte_elt.elt_dwd_de_annual_sun__ion_regional_averages.................................. [OK in 0.27s]
2022-07-29 08:58:26 normalization > 08:58:26  
2022-07-29 08:58:26 normalization > 08:58:26  Finished running 1 table model in 0.55s.
2022-07-29 08:58:26 normalization > 08:58:26  
2022-07-29 08:58:26 normalization > 08:58:26  Completed successfully
2022-07-29 08:58:26 normalization > 08:58:26  
2022-07-29 08:58:26 normalization > 08:58:26  Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1
2022-07-29 08:58:26 INFO i.a.w.g.DefaultNormalizationWorker(run):74 - Normalization executed in 9 seconds.
2022-07-29 08:58:26 INFO i.a.w.g.DefaultNormalizationWorker(run):80 - Normalization summary: io.airbyte.config.NormalizationSummary@4500a947[startTime=1659085096591,endTime=1659085106270]
2022-07-29 08:58:26 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-07-29 08:58:26 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):291 - Stopping temporal heartbeating...