2022-09-28 18:00:08 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-09-28 18:00:08 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-09-28 18:00:08 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. 
errors: $.access_token: object found, string expected, $.refresh_token: object found, string expected, $.client_secret: object found, string expected, $.client_id: object found, string expected
2022-09-28 18:00:08 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-09-28 18:00:08 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. 
errors: $.credentials_json: is missing but it is required, $.auth_type: must be a constant value Service
2022-09-28 18:00:08 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/163/0/logs.log
2022-09-28 18:00:08 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.3
2022-09-28 18:00:09 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/source-google-analytics-v4:0.1.25 exists...
2022-09-28 18:00:09 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/source-google-analytics-v4:0.1.25 was found locally.
2022-09-28 18:00:09 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 163
2022-09-28 18:00:09 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/163/0 --log-driver none --name source-google-analytics-v4-check-163-0-mjdsr --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-google-analytics-v4:0.1.25 -e AIRBYTE_VERSION=0.40.3 -e WORKER_JOB_ID=163 airbyte/source-google-analytics-v4:0.1.25 check --config source_config.json
2022-09-28 18:00:13 WARN i.a.w.i.DefaultAirbyteStreamFactory(internalLog):96 - Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:13 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Check succeeded
2022-09-28 18:00:13 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-09-28 18:00:13 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/163/0/logs.log
2022-09-28 18:00:13 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.3
2022-09-28 18:00:14 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/destination-postgres:0.3.22 exists...
2022-09-28 18:00:14 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/destination-postgres:0.3.22 was found locally.
2022-09-28 18:00:14 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 163
2022-09-28 18:00:14 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/163/0 --log-driver none --name destination-postgres-check-163-0-mxwht --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-postgres:0.3.22 -e AIRBYTE_VERSION=0.40.3 -e WORKER_JOB_ID=163 airbyte/destination-postgres:0.3.22 check --config source_config.json
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 INFO i.a.i.d.p.PostgresDestination(main):87 - starting destination: class io.airbyte.integrations.destination.postgres.PostgresDestination
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json}
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 INFO i.a.i.b.IntegrationRunner(runInternal):104 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 INFO i.a.i.b.IntegrationRunner(runInternal):105 - Command: CHECK
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 INFO i.a.i.b.IntegrationRunner(runInternal):106 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2022-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 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-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 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-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 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-09-28 18:00:16 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:16 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-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated...
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO i.a.i.b.IntegrationRunner(runInternal):152 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-09-28 18:00:17 INFO i.a.i.d.p.PostgresDestination(main):89 - completed destination: class io.airbyte.integrations.destination.postgres.PostgresDestination
2022-09-28 18:00:17 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-09-28 18:00:17 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/163/0/logs.log
2022-09-28 18:00:17 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.3
2022-09-28 18:00:17 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):49 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false'
2022-09-28 18:00:17 INFO i.a.c.EnvConfigs(getEnvOrDefault):1002 - Using default value for environment variable METRIC_CLIENT: ''
2022-09-28 18:00:17 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 
2022-09-28 18:00:17 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):49 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false'
2022-09-28 18:00:17 INFO i.a.w.g.DefaultReplicationWorker(run):119 - start sync worker. job id: 163 attempt id: 0
2022-09-28 18:00:17 INFO i.a.w.g.DefaultReplicationWorker(run):131 - configured sync modes: {null.pages=full_refresh - append, null.devices=full_refresh - append, null.daily_active_users=full_refresh - append, null.locations=full_refresh - append, null.traffic_sources=full_refresh - append, null.website_overview=full_refresh - append}
2022-09-28 18:00:17 INFO i.a.w.i.DefaultAirbyteDestination(start):69 - Running destination...
2022-09-28 18:00:18 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/destination-postgres:0.3.22 exists...
2022-09-28 18:00:18 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/destination-postgres:0.3.22 was found locally.
2022-09-28 18:00:18 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 163
2022-09-28 18:00:18 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/163/0 --log-driver none --name destination-postgres-write-163-0-caqqk --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-postgres:0.3.22 -e AIRBYTE_VERSION=0.40.3 -e WORKER_JOB_ID=163 airbyte/destination-postgres:0.3.22 write --config destination_config.json --catalog destination_catalog.json
2022-09-28 18:00:18 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/source-google-analytics-v4:0.1.25 exists...
2022-09-28 18:00:18 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/source-google-analytics-v4:0.1.25 was found locally.
2022-09-28 18:00:18 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 163
2022-09-28 18:00:18 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/163/0 --log-driver none --name source-google-analytics-v4-read-163-0-mnycg --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-google-analytics-v4:0.1.25 -e AIRBYTE_VERSION=0.40.3 -e WORKER_JOB_ID=163 airbyte/source-google-analytics-v4:0.1.25 read --config source_config.json --catalog source_catalog.json
2022-09-28 18:00:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):421 - Destination output thread started.
2022-09-28 18:00:18 INFO i.a.w.g.DefaultReplicationWorker(run):173 - Waiting for source and destination threads to complete.
2022-09-28 18:00:18 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):313 - Replication thread started.
2022-09-28 18:00:19 source > Starting syncing SourceGoogleAnalyticsV4
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.p.PostgresDestination(main):87 - starting destination: class io.airbyte.integrations.destination.postgres.PostgresDestination
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.b.IntegrationRunner(runInternal):104 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.b.IntegrationRunner(runInternal):105 - Command: WRITE
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.b.IntegrationRunner(runInternal):106 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 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-09-28 18:00:20 destination > 2022-09-28 18:00:20 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-09-28 18:00:20 destination > 2022-09-28 18:00:20 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-09-28 18:00:20 destination > 2022-09-28 18:00:20 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-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_daily_active_users, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_rjw_pf088rifzhsarlc_daily_active_users, outputTableName=_airbyte_raw_pf088rifzhsarlc_daily_active_users, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_devices, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_pcg_pf088rifzhsarlc_devices, outputTableName=_airbyte_raw_pf088rifzhsarlc_devices, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_locations, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_cef_pf088rifzhsarlc_locations, outputTableName=_airbyte_raw_pf088rifzhsarlc_locations, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_pages, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_sjj_pf088rifzhsarlc_pages, outputTableName=_airbyte_raw_pf088rifzhsarlc_pages, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_traffic_sources, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_gna_pf088rifzhsarlc_traffic_sources, outputTableName=_airbyte_raw_pf088rifzhsarlc_traffic_sources, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=pf088rifzhsarlc_website_overview, namespace=null, outputSchemaName=public, tmpTableName=_airbyte_tmp_iam_pf088rifzhsarlc_website_overview, outputTableName=_airbyte_raw_pf088rifzhsarlc_website_overview, syncMode=append}
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started.
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):123 - Preparing tmp tables in destination started for 6 streams
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_daily_active_users. schema: public, tmp table name: _airbyte_tmp_rjw_pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_devices. schema: public, tmp table name: _airbyte_tmp_pcg_pf088rifzhsarlc_devices
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_locations. schema: public, tmp table name: _airbyte_tmp_cef_pf088rifzhsarlc_locations
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_pages. schema: public, tmp table name: _airbyte_tmp_sjj_pf088rifzhsarlc_pages
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_traffic_sources. schema: public, tmp table name: _airbyte_tmp_gna_pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream pf088rifzhsarlc_website_overview. schema: public, tmp table name: _airbyte_tmp_iam_pf088rifzhsarlc_website_overview
2022-09-28 18:00:20 destination > 2022-09-28 18:00:20 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):133 - Preparing tables in destination completed.
2022-09-28 18:00:22 source > Syncing stream: daily_active_users 
2022-09-28 18:00:23 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:23 source > Read 99 records from daily_active_users stream
2022-09-28 18:00:23 source > Finished syncing daily_active_users
2022-09-28 18:00:23 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
2022-09-28 18:00:23 source > Syncing stream: devices 
2022-09-28 18:00:24 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:24 source > Read 462 records from devices stream
2022-09-28 18:00:24 source > Finished syncing devices
2022-09-28 18:00:24 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
Syncing stream devices 0:00:01.124814
2022-09-28 18:00:24 source > Syncing stream: locations 
2022-09-28 18:00:25 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):339 - Records read: 1000 (357 KB)
2022-09-28 18:00:26 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:26 source > Read 1170 records from locations stream
2022-09-28 18:00:26 source > Finished syncing locations
2022-09-28 18:00:26 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
Syncing stream devices 0:00:01.124814
Syncing stream locations 0:00:01.708697
2022-09-28 18:00:26 source > Syncing stream: pages 
2022-09-28 18:00:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):339 - Records read: 2000 (754 KB)
2022-09-28 18:00:27 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:27 source > Read 578 records from pages stream
2022-09-28 18:00:27 source > Finished syncing pages
2022-09-28 18:00:27 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
Syncing stream devices 0:00:01.124814
Syncing stream locations 0:00:01.708697
Syncing stream pages 0:00:00.972151
2022-09-28 18:00:27 source > Syncing stream: traffic_sources 
2022-09-28 18:00:28 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:28 source > Read 302 records from traffic_sources stream
2022-09-28 18:00:28 source > Finished syncing traffic_sources
2022-09-28 18:00:28 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
Syncing stream devices 0:00:01.124814
Syncing stream locations 0:00:01.708697
Syncing stream pages 0:00:00.972151
Syncing stream traffic_sources 0:00:01.082452
2022-09-28 18:00:28 source > Syncing stream: website_overview 
2022-09-28 18:00:29 source > Google Analytics data is not golden. Future requests may return different data.
2022-09-28 18:00:29 source > Read 99 records from website_overview stream
2022-09-28 18:00:29 source > Finished syncing website_overview
2022-09-28 18:00:29 source > SourceGoogleAnalyticsV4 runtimes:
Syncing stream daily_active_users 0:00:01.365041
Syncing stream devices 0:00:01.124814
Syncing stream locations 0:00:01.708697
Syncing stream pages 0:00:00.972151
Syncing stream traffic_sources 0:00:01.082452
Syncing stream website_overview 0:00:00.531236
2022-09-28 18:00:29 source > Finished syncing SourceGoogleAnalyticsV4
2022-09-28 18:00:29 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):342 - Source has no more messages, closing connection.
2022-09-28 18:00:29 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):350 - Total records read: 2710 (983 KB)
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream pages. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream devices. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream traffic_sources. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream locations. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream website_overview. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):353 - Schema validation errors found for stream daily_active_users. Error messages: [$ is of an incorrect type.]
2022-09-28 18:00:29 INFO i.a.w.g.DefaultReplicationWorker(run):178 - One of source or destination thread complete. Waiting on the other.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):62 - Airbyte message consumer: succeeded.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_traffic_sources: 302 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_locations: 1170 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_devices: 462 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_pages: 578 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_website_overview: 99 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(flushAll):84 - Flushing pf088rifzhsarlc_daily_active_users: 99 records (3 MB)
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):137 - No onDestinationCloseOperations required for this destination.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):163 - Finalizing tables in destination started for 6 streams
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_daily_active_users. schema public, tmp table _airbyte_tmp_rjw_pf088rifzhsarlc_daily_active_users, final table _airbyte_raw_pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_devices. schema public, tmp table _airbyte_tmp_pcg_pf088rifzhsarlc_devices, final table _airbyte_raw_pf088rifzhsarlc_devices
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_locations. schema public, tmp table _airbyte_tmp_cef_pf088rifzhsarlc_locations, final table _airbyte_raw_pf088rifzhsarlc_locations
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_pages. schema public, tmp table _airbyte_tmp_sjj_pf088rifzhsarlc_pages, final table _airbyte_raw_pf088rifzhsarlc_pages
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_traffic_sources. schema public, tmp table _airbyte_tmp_gna_pf088rifzhsarlc_traffic_sources, final table _airbyte_raw_pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream pf088rifzhsarlc_website_overview. schema public, tmp table _airbyte_tmp_iam_pf088rifzhsarlc_website_overview, final table _airbyte_raw_pf088rifzhsarlc_website_overview
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):181 - Executing finalization of tables.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Finalizing tables in destination completed.
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):186 - Cleaning tmp tables in destination started for 6 streams
2022-09-28 18:00:29 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_daily_active_users. schema public, tmp table name: _airbyte_tmp_rjw_pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:30 destination > 2022-09-28 18:00:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_devices. schema public, tmp table name: _airbyte_tmp_pcg_pf088rifzhsarlc_devices
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_locations. schema public, tmp table name: _airbyte_tmp_cef_pf088rifzhsarlc_locations
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_pages. schema public, tmp table name: _airbyte_tmp_sjj_pf088rifzhsarlc_pages
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_traffic_sources. schema public, tmp table name: _airbyte_tmp_gna_pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream pf088rifzhsarlc_website_overview. schema public, tmp table name: _airbyte_tmp_iam_pf088rifzhsarlc_website_overview
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):195 - Cleaning tmp tables in destination completed.
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.b.IntegrationRunner(runInternal):152 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-09-28 18:00:30 destination > 2022-09-28 18:00:30 INFO i.a.i.d.p.PostgresDestination(main):89 - completed destination: class io.airbyte.integrations.destination.postgres.PostgresDestination
2022-09-28 18:00:30 INFO i.a.w.g.DefaultReplicationWorker(run):180 - Source and destination threads complete.
2022-09-28 18:00:30 INFO i.a.w.g.DefaultReplicationWorker(run):249 - sync summary: io.airbyte.config.ReplicationAttemptSummary@71f27792[status=completed,recordsSynced=2710,bytesSynced=1007564,startTime=1664388017990,endTime=1664388030160,totalStats=io.airbyte.config.SyncStats@51ec87a9[recordsEmitted=2710,bytesEmitted=1007564,sourceStateMessagesEmitted=0,destinationStateMessagesEmitted=0,recordsCommitted=2710,meanSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBetweenStateMessageEmittedandCommitted=0,meanSecondsBetweenStateMessageEmittedandCommitted=0,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@123afbcf[streamName=pf088rifzhsarlc_website_overview,stats=io.airbyte.config.SyncStats@6656f7c6[recordsEmitted=99,bytesEmitted=30850,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=99,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@4fa4279[streamName=pf088rifzhsarlc_pages,stats=io.airbyte.config.SyncStats@319e5c80[recordsEmitted=578,bytesEmitted=186243,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=578,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@74bf2dff[streamName=pf088rifzhsarlc_devices,stats=io.airbyte.config.SyncStats@25060c69[recordsEmitted=462,bytesEmitted=170790,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=462,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@73396b3a[streamName=pf088rifzhsarlc_traffic_sources,stats=io.airbyte.config.SyncStats@30005381[recordsEmitted=302,bytesEmitted=110252,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=302,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@3d5d40ab[streamName=pf088rifzhsarlc_daily_active_users,stats=io.airbyte.config.SyncStats@282d662d[recordsEmitted=99,bytesEmitted=8274,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=99,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@1075b8a9[streamName=pf088rifzhsarlc_locations,stats=io.airbyte.config.SyncStats@225b7d7d[recordsEmitted=1170,bytesEmitted=501155,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=1170,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]]]]
2022-09-28 18:00:30 INFO i.a.w.g.DefaultReplicationWorker(run):278 - Source did not output any state messages
2022-09-28 18:00:30 WARN i.a.w.g.DefaultReplicationWorker(run):289 - State capture: No state retained.
2022-09-28 18:00:30 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-09-28 18:00:30 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):165 - sync summary: io.airbyte.config.StandardSyncOutput@1729c510[standardSyncSummary=io.airbyte.config.StandardSyncSummary@22fdf922[status=completed,recordsSynced=2710,bytesSynced=1007564,startTime=1664388017990,endTime=1664388030160,totalStats=io.airbyte.config.SyncStats@51ec87a9[recordsEmitted=2710,bytesEmitted=1007564,sourceStateMessagesEmitted=0,destinationStateMessagesEmitted=0,recordsCommitted=2710,meanSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBetweenStateMessageEmittedandCommitted=0,meanSecondsBetweenStateMessageEmittedandCommitted=0,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@123afbcf[streamName=pf088rifzhsarlc_website_overview,stats=io.airbyte.config.SyncStats@6656f7c6[recordsEmitted=99,bytesEmitted=30850,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=99,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@4fa4279[streamName=pf088rifzhsarlc_pages,stats=io.airbyte.config.SyncStats@319e5c80[recordsEmitted=578,bytesEmitted=186243,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=578,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@74bf2dff[streamName=pf088rifzhsarlc_devices,stats=io.airbyte.config.SyncStats@25060c69[recordsEmitted=462,bytesEmitted=170790,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=462,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@73396b3a[streamName=pf088rifzhsarlc_traffic_sources,stats=io.airbyte.config.SyncStats@30005381[recordsEmitted=302,bytesEmitted=110252,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=302,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@3d5d40ab[streamName=pf088rifzhsarlc_daily_active_users,stats=io.airbyte.config.SyncStats@282d662d[recordsEmitted=99,bytesEmitted=8274,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=99,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]], io.airbyte.config.StreamSyncStats@1075b8a9[streamName=pf088rifzhsarlc_locations,stats=io.airbyte.config.SyncStats@225b7d7d[recordsEmitted=1170,bytesEmitted=501155,sourceStateMessagesEmitted=<null>,destinationStateMessagesEmitted=<null>,recordsCommitted=1170,meanSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBeforeSourceStateMessageEmitted=<null>,maxSecondsBetweenStateMessageEmittedandCommitted=<null>,meanSecondsBetweenStateMessageEmittedandCommitted=<null>,additionalProperties={}]]]],normalizationSummary=<null>,state=<null>,outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@5ec68423[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@3f4928cf[stream=io.airbyte.protocol.models.AirbyteStream@66916b73[name=pf088rifzhsarlc_daily_active_users,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_1dayUsers":{"type":["null","integer"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2b68aa6a[stream=io.airbyte.protocol.models.AirbyteStream@4165d4b8[name=pf088rifzhsarlc_devices,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_users":{"type":["null","integer"]},"ga_browser":{"type":["string"]},"ga_exitRate":{"type":["null","number"]},"ga_newUsers":{"type":["null","integer"]},"ga_sessions":{"type":["null","integer"]},"ga_pageviews":{"type":["null","integer"]},"ga_bounceRate":{"type":["null","number"]},"ga_avgTimeOnPage":{"type":["null","number"]},"ga_deviceCategory":{"type":["string"]},"ga_operatingSystem":{"type":["string"]},"ga_sessionsPerUser":{"type":["null","number"]},"ga_avgSessionDuration":{"type":["null","number"]},"ga_pageviewsPerSession":{"type":["null","number"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@371c930b[stream=io.airbyte.protocol.models.AirbyteStream@5abbbc68[name=pf088rifzhsarlc_locations,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_city":{"type":["string"]},"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_metro":{"type":["string"]},"ga_users":{"type":["null","integer"]},"ga_region":{"type":["string"]},"ga_country":{"type":["string"]},"ga_exitRate":{"type":["null","number"]},"ga_newUsers":{"type":["null","integer"]},"ga_sessions":{"type":["null","integer"]},"ga_continent":{"type":["string"]},"ga_pageviews":{"type":["null","integer"]},"ga_bounceRate":{"type":["null","number"]},"ga_subContinent":{"type":["string"]},"ga_avgTimeOnPage":{"type":["null","number"]},"ga_sessionsPerUser":{"type":["null","number"]},"ga_avgSessionDuration":{"type":["null","number"]},"ga_pageviewsPerSession":{"type":["null","number"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@34ee66af[stream=io.airbyte.protocol.models.AirbyteStream@5bc1a49e[name=pf088rifzhsarlc_pages,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_exits":{"type":["null","integer"]},"ga_exitRate":{"type":["null","number"]},"ga_hostname":{"type":["string"]},"ga_pagePath":{"type":["string"]},"ga_entrances":{"type":["null","integer"]},"ga_pageviews":{"type":["null","integer"]},"ga_bounceRate":{"type":["null","number"]},"ga_entranceRate":{"type":["null","number"]},"ga_avgTimeOnPage":{"type":["null","number"]},"ga_uniquePageviews":{"type":["null","integer"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@816e026[stream=io.airbyte.protocol.models.AirbyteStream@f4945b0[name=pf088rifzhsarlc_traffic_sources,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_users":{"type":["null","integer"]},"ga_medium":{"type":["string"]},"ga_source":{"type":["string"]},"ga_exitRate":{"type":["null","number"]},"ga_newUsers":{"type":["null","integer"]},"ga_sessions":{"type":["null","integer"]},"ga_pageviews":{"type":["null","integer"]},"ga_bounceRate":{"type":["null","number"]},"ga_avgTimeOnPage":{"type":["null","number"]},"ga_socialNetwork":{"type":["string"]},"ga_sessionsPerUser":{"type":["null","number"]},"ga_avgSessionDuration":{"type":["null","number"]},"ga_pageviewsPerSession":{"type":["null","number"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@485581e8[stream=io.airbyte.protocol.models.AirbyteStream@1ee62928[name=pf088rifzhsarlc_website_overview,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"ga_date":{"type":["string"]},"view_id":{"type":["string"]},"ga_users":{"type":["null","integer"]},"ga_exitRate":{"type":["null","number"]},"ga_newUsers":{"type":["null","integer"]},"ga_sessions":{"type":["null","integer"]},"ga_pageviews":{"type":["null","integer"]},"ga_bounceRate":{"type":["null","number"]},"ga_avgTimeOnPage":{"type":["null","number"]},"ga_sessionsPerUser":{"type":["null","number"]},"ga_avgSessionDuration":{"type":["null","number"]},"ga_pageviewsPerSession":{"type":["null","number"]}},"additionalProperties":false},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[ga_date],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[ga_date],destinationSyncMode=append,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]]
2022-09-28 18:00:30 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):312 - Stopping temporal heartbeating...
2022-09-28 18:00:30 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/163/0/logs.log
2022-09-28 18:00:30 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.3
2022-09-28 18:00:30 INFO i.a.w.g.DefaultNormalizationWorker(run):57 - Running normalization.
2022-09-28 18:00:30 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):136 - Running with normalization version: airbyte/normalization:0.2.18
2022-09-28 18:00:30 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/normalization:0.2.18 exists...
2022-09-28 18:00:30 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/normalization:0.2.18 was found locally.
2022-09-28 18:00:30 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 163
2022-09-28 18:00:30 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/163/0/normalize --log-driver none --name normalization-normalize-163-0-ecifa --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.40.3 airbyte/normalization:0.2.18 run --integration-type postgres --config destination_config.json --catalog destination_catalog.json
2022-09-28 18:00:30 normalization > Running: transform-config --config destination_config.json --integration-type postgres --out /data/163/0/normalize
2022-09-28 18:00:31 normalization > Namespace(config='destination_config.json', integration_type=<DestinationType.POSTGRES: 'postgres'>, out='/data/163/0/normalize')
2022-09-28 18:00:31 normalization > transform_postgres
2022-09-28 18:00:31 normalization > Running: transform-catalog --integration-type postgres --profile-config-dir /data/163/0/normalize --catalog destination_catalog.json --out /data/163/0/normalize/models/generated/ --json-column _airbyte_data
2022-09-28 18:00:32 normalization > Processing destination_catalog.json...
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_daily_active_users_ab1.sql from pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_daily_active_users_ab2.sql from pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_daily_active_users_hashid (#50) to _airbyte_pf088rifzhs_y_active_users_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_daily_active_users_ab3.sql from pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_daily_active_users_hashid (#50) to _airbyte_pf088rifzhs_y_active_users_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_daily_active_users.sql from pf088rifzhsarlc_daily_active_users
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_devices_ab1.sql from pf088rifzhsarlc_devices
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_devices_ab2.sql from pf088rifzhsarlc_devices
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_devices_ab3.sql from pf088rifzhsarlc_devices
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_devices.sql from pf088rifzhsarlc_devices
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_locations_ab1.sql from pf088rifzhsarlc_locations
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_locations_ab2.sql from pf088rifzhsarlc_locations
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_locations_ab3.sql from pf088rifzhsarlc_locations
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_locations.sql from pf088rifzhsarlc_locations
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_pages_ab1.sql from pf088rifzhsarlc_pages
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_pages_ab2.sql from pf088rifzhsarlc_pages
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_pages_ab3.sql from pf088rifzhsarlc_pages
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_pages.sql from pf088rifzhsarlc_pages
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_traffic_sources_ab1.sql from pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_traffic_sources_ab2.sql from pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_traffic_sources_hashid (#47) to _airbyte_pf088rifzhs_raffic_sources_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_traffic_sources_ab3.sql from pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_traffic_sources_hashid (#47) to _airbyte_pf088rifzhs_raffic_sources_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_traffic_sources.sql from pf088rifzhsarlc_traffic_sources
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_website_overview_ab1.sql from pf088rifzhsarlc_website_overview
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_website_overview_ab2.sql from pf088rifzhsarlc_website_overview
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_website_overview_hashid (#48) to _airbyte_pf088rifzhs_bsite_overview_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_ctes/public/pf088rifzhsarlc_website_overview_ab3.sql from pf088rifzhsarlc_website_overview
2022-09-28 18:00:32 normalization > Truncating _airbyte_pf088rifzhsarlc_website_overview_hashid (#48) to _airbyte_pf088rifzhs_bsite_overview_hashid (#43)
2022-09-28 18:00:32 normalization >   Generating airbyte_incremental/public/pf088rifzhsarlc_website_overview.sql from pf088rifzhsarlc_website_overview
2022-09-28 18:00:32 normalization > detected no config file for ssh, assuming ssh is off.
2022-09-28 18:00:35 normalization >            [--event-buffer-size EVENT_BUFFER_SIZE]
2022-09-28 18:00:35 normalization >   --event-buffer-size EVENT_BUFFER_SIZE
2022-09-28 18:00:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):103 - 
2022-09-28 18:00:35 normalization > DBT >=1.0.0 detected; using 10K event buffer size
2022-09-28 18:00:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):103 - 
2022-09-28 18:00:38 normalization > Running with dbt=1.0.0
2022-09-28 18:00:38 normalization > Partial parse save file not found. Starting full parse.
2022-09-28 18:00:41 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
There are 2 unused configuration paths:
- models.airbyte_utils.generated.airbyte_views
- models.airbyte_utils.generated.airbyte_tables

2022-09-28 18:00:41 normalization > Found 24 models, 0 tests, 0 snapshots, 0 analyses, 558 macros, 0 operations, 0 seed files, 6 sources, 0 exposures, 0 metrics
2022-09-28 18:00:42 normalization > Concurrency: 8 threads (target='prod')
2022-09-28 18:00:43 normalization > 1 of 6 START incremental model public.pf088rifzhsarlc_devices........................................................... [RUN]
2022-09-28 18:00:43 normalization > 2 of 6 START incremental model public.pf088rifzhsarlc_website_overview.................................................. [RUN]
2022-09-28 18:00:43 normalization > 3 of 6 START incremental model public.pf088rifzhsarlc_traffic_sources................................................... [RUN]
2022-09-28 18:00:43 normalization > 4 of 6 START incremental model public.pf088rifzhsarlc_pages............................................................. [RUN]
2022-09-28 18:00:43 normalization > 5 of 6 START incremental model public.pf088rifzhsarlc_daily_active_users................................................ [RUN]
2022-09-28 18:00:43 normalization > 6 of 6 START incremental model public.pf088rifzhsarlc_locations......................................................... [RUN]
2022-09-28 18:00:44 normalization > 2 of 6 OK created incremental model public.pf088rifzhsarlc_website_overview............................................. [INSERT 0 100 in 1.16s]
2022-09-28 18:00:44 normalization > 3 of 6 OK created incremental model public.pf088rifzhsarlc_traffic_sources.............................................. [INSERT 0 304 in 1.08s]
2022-09-28 18:00:44 normalization > 1 of 6 OK created incremental model public.pf088rifzhsarlc_devices...................................................... [INSERT 0 465 in 1.37s]
2022-09-28 18:00:44 normalization > 5 of 6 OK created incremental model public.pf088rifzhsarlc_daily_active_users........................................... [INSERT 0 100 in 1.09s]
2022-09-28 18:00:44 normalization > 4 of 6 OK created incremental model public.pf088rifzhsarlc_pages........................................................ [INSERT 0 579 in 1.11s]
2022-09-28 18:00:44 normalization > 6 of 6 OK created incremental model public.pf088rifzhsarlc_locations.................................................... [INSERT 0 1172 in 1.14s]
2022-09-28 18:00:44 normalization > Finished running 6 incremental models in 3.04s.
2022-09-28 18:00:44 normalization > Completed successfully
2022-09-28 18:00:44 normalization > Done. PASS=6 WARN=0 ERROR=0 SKIP=0 TOTAL=6
2022-09-28 18:00:45 INFO i.a.w.g.DefaultNormalizationWorker(run):81 - Normalization executed in 14 seconds.
2022-09-28 18:00:45 INFO i.a.w.g.DefaultNormalizationWorker(run):94 - Normalization summary: io.airbyte.config.NormalizationSummary@32fc73ca[startTime=1664388030369,endTime=1664388045213,failures=[]]
2022-09-28 18:00:45 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-09-28 18:00:45 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):312 - Stopping temporal heartbeating...