2021-12-13 04:34:20 INFO () WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.32.0-alpha
2021-12-13 04:34:20 INFO () TemporalAttemptExecution(get):116 - Executing worker wrapper. Airbyte version: 0.32.0-alpha
2021-12-13 04:34:20 WARN () Databases(createPostgresDatabaseWithRetry):41 - Waiting for database to become available...
2021-12-13 04:34:20 INFO () JobsDatabaseInstance(lambda$static$2):25 - Testing if jobs database is ready...
2021-12-13 04:34:20 INFO () Databases(createPostgresDatabaseWithRetry):58 - Database available!
2021-12-13 04:34:20 INFO () DefaultReplicationWorker(run):82 - start sync worker. job id: 904 attempt id: 0
2021-12-13 04:34:20 INFO () DefaultReplicationWorker(run):91 - configured sync modes: {null.ad_groups=full_refresh - overwrite, null.campaign_analytics=incremental - append, null.ad_accounts=full_refresh - overwrite, null.campaigns=full_refresh - overwrite, null.ad_group_analytics=incremental - append}
2021-12-13 04:34:20 INFO () DefaultAirbyteDestination(start):64 - Running destination...
2021-12-13 04:34:20 INFO () LineGobbler(voidCall):82 - Checking if airbyte/destination-bigquery:0.3.12 exists...
2021-12-13 04:34:20 INFO () LineGobbler(voidCall):82 - airbyte/destination-bigquery:0.3.12 was found locally.
2021-12-13 04:34:20 INFO () DockerProcessFactory(create):127 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/904/0 --network host --log-driver none airbyte/destination-bigquery:0.3.12 write --config destination_config.json --catalog destination_catalog.json
2021-12-13 04:34:20 INFO () LineGobbler(voidCall):82 - Checking if airbyte/source-pinterest:0.1.0 exists...
2021-12-13 04:34:21 INFO () LineGobbler(voidCall):82 - airbyte/source-pinterest:0.1.0 was found locally.
2021-12-13 04:34:21 INFO () DockerProcessFactory(create):127 - Preparing command: docker run --rm --init -i -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -w /data/904/0 --network host --log-driver none airbyte/source-pinterest:0.1.0 read --config source_config.json --catalog source_catalog.json --state input_state.json
2021-12-13 04:34:21 INFO () DefaultReplicationWorker(lambda$getDestinationOutputRunnable$3):226 - Destination output thread started.
2021-12-13 04:34:21 INFO () DefaultReplicationWorker(lambda$getReplicationRunnable$2):190 - Replication thread started.
2021-12-13 04:34:21 INFO () DefaultReplicationWorker(run):119 - Waiting for source thread to join.
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 INFO i.a.i.d.b.BigQueryDestination(main):305 - {} - starting destination: class io.airbyte.integrations.destination.bigquery.BigQueryDestination
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 INFO i.a.i.b.IntegrationRunner(run):96 - {} - Running integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 INFO i.a.i.b.IntegrationCliParser(parseOptions):135 - {} - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json}
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 INFO i.a.i.b.IntegrationRunner(run):100 - {} - Command: WRITE
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 INFO i.a.i.b.IntegrationRunner(run):101 - {} - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'}
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 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
destination - 2021-12-13 04:34:23 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:23 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
destination - 2021-12-13 04:34:25 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:25 INFO i.a.i.d.b.BigQueryUtils(createTable):85 - {} - Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_ydj_ad_accounts}} created successfully
destination - 2021-12-13 04:34:26 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:26 INFO i.a.i.d.b.BigQueryUtils(createTable):85 - {} - Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_esr_ad_group_analytics}} created successfully
destination - 2021-12-13 04:34:26 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:26 INFO i.a.i.d.b.BigQueryUtils(createTable):85 - {} - Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_myd_ad_groups}} created successfully
destination - 2021-12-13 04:34:26 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:26 INFO i.a.i.d.b.BigQueryUtils(createTable):85 - {} - Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_dsu_campaign_analytics}} created successfully
destination - 2021-12-13 04:34:27 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:34:27 INFO i.a.i.d.b.BigQueryUtils(createTable):85 - {} - Table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_zad_campaigns}} created successfully
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:56 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 ERROR () DefaultAirbyteStreamFactory(internalLog):95 - For stream ad_group_analytics rate limit exceeded.
source - 2021-12-13 04:34:57 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Backing off _send(...) for 5.0s (airbyte_cdk.sources.streams.http.exceptions.DefaultBackoffException)
source - 2021-12-13 04:35:06 INFO () DefaultAirbyteStreamFactory(internalLog):97 - Caught retryable error '' after 1 tries. Waiting 5 seconds then retrying...
2021-12-13 04:35:16 INFO () DefaultReplicationWorker(lambda$getReplicationRunnable$2):203 - Records read: 1000
2021-12-13 04:35:29 INFO () DefaultReplicationWorker(lambda$getReplicationRunnable$2):203 - Records read: 2000
2021-12-13 04:36:07 INFO () DefaultReplicationWorker(lambda$getReplicationRunnable$2):203 - Records read: 3000
2021-12-13 04:36:14 INFO () DefaultReplicationWorker(run):121 - Source thread complete.
2021-12-13 04:36:14 INFO () DefaultReplicationWorker(run):122 - Waiting for destination thread to join.
destination - 2021-12-13 04:36:14 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:14 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):80 - {} - Airbyte message consumer: succeeded.
destination - 2021-12-13 04:36:14 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:14 INFO i.a.i.d.b.BigQueryRecordConsumer(close):133 - {} - Started closing all connections
destination - 2021-12-13 04:36:16 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:16 INFO i.a.i.d.b.BigQueryRecordConsumer(close):147 - {} - Waiting for jobs to be finished/closed
destination - 2021-12-13 04:36:19 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:19 INFO i.a.i.d.b.BigQueryRecordConsumer(close):164 - {} - Migration finished with no explicit errors. Copying data from tmp tables to permanent
destination - 2021-12-13 04:36:21 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:21 INFO i.a.i.d.b.BigQueryRecordConsumer(copyTable):200 - {} - successfully copied tmp table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_esr_ad_group_analytics}} to final table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_raw_ad_group_analytics}}
destination - 2021-12-13 04:36:24 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:24 INFO i.a.i.d.b.BigQueryRecordConsumer(copyTable):200 - {} - successfully copied tmp table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_zad_campaigns}} to final table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_raw_campaigns}}
destination - 2021-12-13 04:36:26 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:26 INFO i.a.i.d.b.BigQueryRecordConsumer(copyTable):200 - {} - successfully copied tmp table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_ydj_ad_accounts}} to final table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_raw_ad_accounts}}
destination - 2021-12-13 04:36:28 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:28 INFO i.a.i.d.b.BigQueryRecordConsumer(copyTable):200 - {} - successfully copied tmp table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_myd_ad_groups}} to final table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_raw_ad_groups}}
destination - 2021-12-13 04:36:29 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:29 INFO i.a.i.d.b.BigQueryRecordConsumer(copyTable):200 - {} - successfully copied tmp table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_tmp_dsu_campaign_analytics}} to final table: GenericData{classInfo=[datasetId, projectId, tableId], {datasetId=airbyte_pinterest, tableId=_airbyte_raw_campaign_analytics}}
2021-12-13 04:36:30 INFO () DefaultReplicationWorker(lambda$getDestinationOutputRunnable$3):231 - state in DefaultReplicationWorker from Destination: io.airbyte.protocol.models.AirbyteMessage@45996d6d[type=STATE,log=<null>,spec=<null>,connectionStatus=<null>,catalog=<null>,record=<null>,state=io.airbyte.protocol.models.AirbyteStateMessage@4b5e9bae[data={"ad_group_analytics":{"DATE":"2021-12-13"},"campaign_analytics":{"DATE":"2021-12-13"}},additionalProperties={}],additionalProperties={}]
destination - 2021-12-13 04:36:30 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:30 INFO i.a.i.d.b.BigQueryRecordConsumer(close):176 - {} - Removing tmp tables...
destination - 2021-12-13 04:36:30 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:30 INFO i.a.i.d.b.BigQueryRecordConsumer(close):178 - {} - Finishing destination process...completed
destination - 2021-12-13 04:36:30 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:30 INFO i.a.i.b.IntegrationRunner(run):153 - {} - Completed integration: io.airbyte.integrations.destination.bigquery.BigQueryDestination
destination - 2021-12-13 04:36:30 INFO () DefaultAirbyteStreamFactory(lambda$create$0):61 - 2021-12-13 04:36:30 INFO i.a.i.d.b.BigQueryDestination(main):307 - {} - completed destination: class io.airbyte.integrations.destination.bigquery.BigQueryDestination
2021-12-13 04:36:30 INFO () DefaultReplicationWorker(run):124 - Destination thread complete.
2021-12-13 04:36:30 INFO () DefaultReplicationWorker(run):152 - sync summary: io.airbyte.config.ReplicationAttemptSummary@4e1bd9ac[status=completed,recordsSynced=3100,bytesSynced=2466578,startTime=1639370060923,endTime=1639370190811]
2021-12-13 04:36:30 INFO () DefaultReplicationWorker(run):159 - Source output at least one state message
2021-12-13 04:36:30 INFO () DefaultReplicationWorker(run):165 - State capture: Updated state to: Optional[io.airbyte.config.State@4cf24797[state={"ad_group_analytics":{"DATE":"2021-12-13"},"campaign_analytics":{"DATE":"2021-12-13"}}]]
2021-12-13 04:36:30 INFO () TemporalAttemptExecution(get):137 - Stopping cancellation check scheduling...
2021-12-13 04:36:30 INFO () ReplicationActivityImpl(replicate):121 - sync summary: io.airbyte.config.StandardSyncOutput@638bb31f[standardSyncSummary=io.airbyte.config.StandardSyncSummary@20fb0b6c[status=completed,recordsSynced=3100,bytesSynced=2466578,startTime=1639370060923,endTime=1639370190811],state=io.airbyte.config.State@4cf24797[state={"ad_group_analytics":{"DATE":"2021-12-13"},"campaign_analytics":{"DATE":"2021-12-13"}}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@7eadd38e[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@59686f44[stream=io.airbyte.protocol.models.AirbyteStream@67c52c3d[name=ad_accounts,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"name":{"type":["null","string"]},"owner":{"type":["null","object"],"properties":{"username":{"type":["null","string"]}}},"country":{"type":["null","string"]},"currency":{"type":["null","string"]}}},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[[id]],namespace=airbyte_pinterest,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@1f1debc2[stream=io.airbyte.protocol.models.AirbyteStream@f3c7a0c[name=ad_group_analytics,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"CTR":{"type":["null","number"]},"DATE":{"type":["null","string"],"format":"date"},"ECTR":{"type":["null","number"]},"CTR_2":{"type":["null","number"]},"REPIN_RATE":{"type":["null","number"]},"AD_GROUP_ID":{"type":["null","string"]},"CAMPAIGN_ID":{"type":["null","number"]},"IMPRESSION_1":{"type":["null","number"]},"IMPRESSION_2":{"type":["null","number"]},"TOTAL_SIGNUP":{"type":["null","number"]},"CAMPAIGN_NAME":{"type":["null","string"]},"CHECKOUT_ROAS":{"type":["null","number"]},"CPM_IN_DOLLAR":{"type":["null","number"]},"ECPC_IN_DOLLAR":{"type":["null","number"]},"ECPE_IN_DOLLAR":{"type":["null","number"]},"ECPV_IN_DOLLAR":{"type":["null","number"]},"TOTAL_CHECKOUT":{"type":["null","number"]},"ECPCV_IN_DOLLAR":{"type":["null","number"]},"ENGAGEMENT_RATE":{"type":["null","number"]},"PAGE_VISIT_ROAS":{"type":["null","number"]},"PAID_IMPRESSION":{"type":["null","number"]},"SPEND_IN_DOLLAR":{"type":["null","number"]},"EENGAGEMENT_RATE":{"type":["null","number"]},"OUTBOUND_CLICK_1":{"type":["null","number"]},"OUTBOUND_CLICK_2":{"type":["null","number"]},"TOTAL_PAGE_VISIT":{"type":["null","number"]},"TOTAL_REPIN_RATE":{"type":["null","number"]},"TOTAL_CONVERSIONS":{"type":["null","number"]},"TOTAL_VIEW_SIGNUP":{"type":["null","number"]},"VIDEO_MRC_VIEWS_2":{"type":["null","number"]},"WEB_CHECKOUT_ROAS":{"type":["null","number"]},"AD_ACCOUNT_IDAD_ID":{"type":["null","string"]},"IMPRESSION_1_GROSS":{"type":["null","number"]},"TOTAL_CLICKTHROUGH":{"type":["null","number"]},"TOTAL_CLICK_SIGNUP":{"type":["null","number"]},"TOTAL_WEB_CHECKOUT":{"type":["null","number"]},"VIDEO_3SEC_VIEWS_2":{"type":["null","number"]},"CPC_IN_MICRO_DOLLAR":{"type":["null","number"]},"CPM_IN_MICRO_DOLLAR":{"type":["null","number"]},"ECPCV_P95_IN_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_CHECKOUT":{"type":["null","number"]},"VIDEO_P0_COMBINED_2":{"type":["null","number"]},"ECPC_IN_MICRO_DOLLAR":{"type":["null","number"]},"ECPM_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_CHECKOUT":{"type":["null","number"]},"VIDEO_P25_COMBINED_2":{"type":["null","number"]},"VIDEO_P50_COMBINED_2":{"type":["null","number"]},"VIDEO_P75_COMBINED_2":{"type":["null","number"]},"VIDEO_P95_COMBINED_2":{"type":["null","number"]},"SPEND_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_IMPRESSION_USER":{"type":["null","number"]},"TOTAL_VIDEO_MRC_VIEWS":{"type":["null","number"]},"VIDEO_P100_COMPLETE_2":{"type":["null","number"]},"AD_GROUP_ENTITY_STATUS":{"type":["null","number"]},"CAMPAIGN_ENTITY_STATUS":{"type":["null","number"]},"TOTAL_VIDEO_3SEC_VIEWS":{"type":["null","number"]},"TOTAL_ENGAGEMENT_SIGNUP":{"type":["null","number"]},"TOTAL_VIDEO_P0_COMBINED":{"type":["null","number"]},"TOTAL_WEB_VIEW_CHECKOUT":{"type":["null","number"]},"CAMPAIGN_DAILY_SPEND_CAP":{"type":["null","number"]},"TOTAL_VIDEO_P25_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P50_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P75_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P95_COMBINED":{"type":["null","number"]},"TOTAL_WEB_CLICK_CHECKOUT":{"type":["null","number"]},"TOTAL_ENGAGEMENT_CHECKOUT":{"type":["null","number"]},"TOTAL_VIDEO_P100_COMPLETE":{"type":["null","number"]},"PAGE_VISIT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_IMPRESSION_FREQUENCY":{"type":["null","number"]},"CAMPAIGN_LIFETIME_SPEND_CAP":{"type":["null","number"]},"IDEA_PIN_PRODUCT_TAG_VISIT_1":{"type":["null","number"]},"IDEA_PIN_PRODUCT_TAG_VISIT_2":{"type":["null","number"]},"WEB_CHECKOUT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_WEB_ENGAGEMENT_CHECKOUT":{"type":["null","number"]},"INAPP_CHECKOUT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT":{"type":["null","number"]},"TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND":{"type":["null","number"]},"TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[DATE],sourceDefinedPrimaryKey=[],namespace=airbyte_pinterest,additionalProperties={}],syncMode=incremental,cursorField=[DATE],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@15b426e0[stream=io.airbyte.protocol.models.AirbyteStream@5b5e54af[name=ad_groups,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"name":{"type":["null","string"]},"type":{"type":["null","string"]},"status":{"type":["null","string"]},"end_time":{"type":["null","number"]},"start_time":{"type":["null","number"]},"budget_type":{"type":["null","string"]},"campaign_id":{"type":["null","string"]},"created_time":{"type":["null","number"]},"updated_time":{"type":["null","number"]},"ad_account_id":{"type":["null","string"]},"tracking_urls":{"type":["null","object"],"properties":{"click":{"type":["null","array"],"items":{"type":["null","string"]}},"engagement":{"type":["null","array"],"items":{"type":["null","string"]}},"impression":{"type":["null","array"],"items":{"type":["null","string"]}},"buyable_button":{"type":["null","array"],"items":{"type":["null","string"]}},"audience_verification":{"type":["null","array"],"items":{"type":["null","string"]}}}},"billable_event":{"type":["null","string"]},"summary_status":{"type":["null","string"]},"targeting_spec":{"type":["null","object"],"properties":{"property1":{"type":["null","array"],"items":{"type":["null","string"]}},"property2":{"type":["null","array"],"items":{"type":["null","string"]}}}},"feed_profile_id":{"type":["null","string"]},"placement_group":{"type":["null","string"]},"pacing_delivery_type":{"type":["null","string"]},"bid_in_micro_currency":{"type":["null","number"]},"auto_targeting_enabled":{"type":["null","boolean"]},"lifetime_frequency_cap":{"type":["null","number"]},"budget_in_micro_currency":{"type":["null","number"]},"conversion_learning_mode_type":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_time],sourceDefinedPrimaryKey=[[id]],namespace=airbyte_pinterest,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_time],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2bedf7fd[stream=io.airbyte.protocol.models.AirbyteStream@47ed0496[name=campaign_analytics,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"CTR":{"type":["null","number"]},"DATE":{"type":["null","string"],"format":"date"},"ECTR":{"type":["null","number"]},"CTR_2":{"type":["null","number"]},"REPIN_RATE":{"type":["null","number"]},"AD_GROUP_ID":{"type":["null","string"]},"CAMPAIGN_ID":{"type":["null","string"]},"IMPRESSION_1":{"type":["null","number"]},"IMPRESSION_2":{"type":["null","number"]},"TOTAL_SIGNUP":{"type":["null","number"]},"CAMPAIGN_NAME":{"type":["null","string"]},"CHECKOUT_ROAS":{"type":["null","number"]},"CPM_IN_DOLLAR":{"type":["null","number"]},"ECPC_IN_DOLLAR":{"type":["null","number"]},"ECPE_IN_DOLLAR":{"type":["null","number"]},"ECPV_IN_DOLLAR":{"type":["null","number"]},"TOTAL_CHECKOUT":{"type":["null","number"]},"ECPCV_IN_DOLLAR":{"type":["null","number"]},"ENGAGEMENT_RATE":{"type":["null","number"]},"PAGE_VISIT_ROAS":{"type":["null","number"]},"PAID_IMPRESSION":{"type":["null","number"]},"SPEND_IN_DOLLAR":{"type":["null","number"]},"EENGAGEMENT_RATE":{"type":["null","number"]},"OUTBOUND_CLICK_1":{"type":["null","number"]},"OUTBOUND_CLICK_2":{"type":["null","number"]},"TOTAL_PAGE_VISIT":{"type":["null","number"]},"TOTAL_REPIN_RATE":{"type":["null","number"]},"TOTAL_CONVERSIONS":{"type":["null","number"]},"TOTAL_VIEW_SIGNUP":{"type":["null","number"]},"VIDEO_MRC_VIEWS_2":{"type":["null","number"]},"WEB_CHECKOUT_ROAS":{"type":["null","number"]},"AD_ACCOUNT_IDAD_ID":{"type":["null","string"]},"IMPRESSION_1_GROSS":{"type":["null","number"]},"TOTAL_CLICKTHROUGH":{"type":["null","number"]},"TOTAL_CLICK_SIGNUP":{"type":["null","number"]},"TOTAL_WEB_CHECKOUT":{"type":["null","number"]},"VIDEO_3SEC_VIEWS_2":{"type":["null","number"]},"CPC_IN_MICRO_DOLLAR":{"type":["null","number"]},"CPM_IN_MICRO_DOLLAR":{"type":["null","number"]},"ECPCV_P95_IN_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_CHECKOUT":{"type":["null","number"]},"VIDEO_P0_COMBINED_2":{"type":["null","number"]},"ECPC_IN_MICRO_DOLLAR":{"type":["null","number"]},"ECPM_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_CHECKOUT":{"type":["null","number"]},"VIDEO_P25_COMBINED_2":{"type":["null","number"]},"VIDEO_P50_COMBINED_2":{"type":["null","number"]},"VIDEO_P75_COMBINED_2":{"type":["null","number"]},"VIDEO_P95_COMBINED_2":{"type":["null","number"]},"SPEND_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_IMPRESSION_USER":{"type":["null","number"]},"TOTAL_VIDEO_MRC_VIEWS":{"type":["null","number"]},"VIDEO_P100_COMPLETE_2":{"type":["null","number"]},"AD_GROUP_ENTITY_STATUS":{"type":["null","string"]},"CAMPAIGN_ENTITY_STATUS":{"type":["null","number"]},"TOTAL_VIDEO_3SEC_VIEWS":{"type":["null","number"]},"TOTAL_ENGAGEMENT_SIGNUP":{"type":["null","number"]},"TOTAL_VIDEO_P0_COMBINED":{"type":["null","number"]},"TOTAL_WEB_VIEW_CHECKOUT":{"type":["null","number"]},"CAMPAIGN_DAILY_SPEND_CAP":{"type":["null","number"]},"TOTAL_VIDEO_P25_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P50_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P75_COMBINED":{"type":["null","number"]},"TOTAL_VIDEO_P95_COMBINED":{"type":["null","number"]},"TOTAL_WEB_CLICK_CHECKOUT":{"type":["null","number"]},"TOTAL_ENGAGEMENT_CHECKOUT":{"type":["null","number"]},"TOTAL_VIDEO_P100_COMPLETE":{"type":["null","number"]},"PAGE_VISIT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_IMPRESSION_FREQUENCY":{"type":["null","number"]},"CAMPAIGN_LIFETIME_SPEND_CAP":{"type":["null","number"]},"IDEA_PIN_PRODUCT_TAG_VISIT_1":{"type":["null","number"]},"IDEA_PIN_PRODUCT_TAG_VISIT_2":{"type":["null","number"]},"WEB_CHECKOUT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_WEB_ENGAGEMENT_CHECKOUT":{"type":["null","number"]},"INAPP_CHECKOUT_COST_PER_ACTION":{"type":["null","number"]},"TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT":{"type":["null","number"]},"TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND":{"type":["null","number"]},"TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]},"TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR":{"type":["null","number"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[DATE],sourceDefinedPrimaryKey=[],namespace=airbyte_pinterest,additionalProperties={}],syncMode=incremental,cursorField=[DATE],destinationSyncMode=append,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@735ab9ad[stream=io.airbyte.protocol.models.AirbyteStream@5a887045[name=campaigns,jsonSchema={"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"name":{"type":["null","string"]},"type":{"type":["null","string"]},"status":{"type":["null","string"]},"created_time":{"type":["null","integer"]},"updated_time":{"type":["null","integer"]},"ad_account_id":{"type":["null","string"]},"order_line_id":{"type":["null","string"]},"tracking_urls":{"type":["null","object"],"properties":{"click":{"type":["null","array"],"items":{"type":["null","string"]}},"engagement":{"type":["null","array"],"items":{"type":["null","string"]}},"impression":{"type":["null","array"],"items":{"type":["null","string"]}},"buyable_button":{"type":["null","array"],"items":{"type":["null","string"]}},"audience_verification":{"type":["null","array"],"items":{"type":["null","string"]}}}},"objective_type":{"type":["null","string"]},"daily_spend_cap":{"type":["null","integer"]},"lifetime_spend_cap":{"type":["null","integer"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_time],sourceDefinedPrimaryKey=[[id]],namespace=airbyte_pinterest,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_time],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}]]
2021-12-13 04:36:30 INFO () ConfigRepository(updateConnectionState):500 - Updating connection f0ffdf42-091c-4afe-b587-a2ae3757ef94 state: io.airbyte.config.State@17490844[state={"ad_group_analytics":{"DATE":"2021-12-13"},"campaign_analytics":{"DATE":"2021-12-13"}}]
2021-12-13 04:36:30 INFO () DatabaseConfigPersistence(updateConfigRecord):258 - Updating STANDARD_SYNC_STATE record f0ffdf42-091c-4afe-b587-a2ae3757ef94