2022-08-18 07:46:31 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.client_id: is missing but it is required, $.client_secret: is missing but it is required, $.refresh_token: is missing but it is required, $.credentials_title: must be a constant value OAuth Credentials 2022-08-18 07:46:31 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.api_key: is missing but it is required, $.credentials_title: must be a constant value API Key Credentials 2022-08-18 07:46:31 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed. errors: $.access_token: object found, string expected 2022-08-18 07:46:31 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/32930/0/logs.log 2022-08-18 07:46:31 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.0-alpha 2022-08-18 07:46:31 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if orderdata/orderdata_hubspot:0.1.6 exists... 2022-08-18 07:46:31 INFO i.a.c.i.LineGobbler(voidCall):83 - orderdata/orderdata_hubspot:0.1.6 was found locally. 2022-08-18 07:46:31 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 32930 2022-08-18 07:46:31 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/32930/0 --log-driver none --name orderdata_hubspot-check-32930-0-giaik --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=orderdata/orderdata_hubspot:0.1.6 -e AIRBYTE_VERSION=0.40.0-alpha -e WORKER_JOB_ID=32930 orderdata/orderdata_hubspot:0.1.6 check --config source_config.json 2022-08-18 07:46:34 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):99 - Check succeeded 2022-08-18 07:46:34 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-08-18 07:46:34 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/32930/0/logs.log 2022-08-18 07:46:34 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.0-alpha 2022-08-18 07:46:34 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/destination-snowflake:0.4.34 exists... 2022-08-18 07:46:34 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 32930 2022-08-18 07:46:34 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/destination-snowflake:0.4.34 was found locally. 2022-08-18 07:46:34 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/32930/0 --log-driver none --name destination-snowflake-check-32930-0-jxuny --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-snowflake:0.4.34 -e AIRBYTE_VERSION=0.40.0-alpha -e WORKER_JOB_ID=32930 airbyte/destination-snowflake:0.4.34 check --config source_config.json 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Class path contains multiple SLF4J bindings. 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-08-18 07:46:35 ERROR i.a.c.i.LineGobbler(voidCall):83 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 INFO i.a.i.b.IntegrationRunner(runInternal):104 - Running integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 INFO i.a.i.b.IntegrationRunner(runInternal):105 - Command: CHECK 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 INFO i.a.i.b.IntegrationRunner(runInternal):106 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:36 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:36 INFO i.a.i.d.j.c.SwitchingDestination(check):55 - Using destination type: INTERNAL_STAGING 2022-08-18 07:46:37 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:37 WARN i.a.i.d.s.SnowflakeDatabase(createDataSource):110 - Obsolete User/password login mode is used. Please re-create a connection to use the latest connector's version 2022-08-18 07:46:37 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:37 INFO c.z.h.HikariDataSource(getConnection):110 - HikariPool-1 - Starting... 2022-08-18 07:46:38 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:38 INFO c.z.h.p.HikariPool(checkFailFast):565 - HikariPool-1 - Added connection net.snowflake.client.jdbc.SnowflakeConnectionV1@7bab5898 2022-08-18 07:46:38 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:38 INFO c.z.h.HikariDataSource(getConnection):123 - HikariPool-1 - Start completed. 2022-08-18 07:46:38 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:38 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):105 - closing connection 2022-08-18 07:46:39 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:39 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated... 2022-08-18 07:46:39 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:39 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed. 2022-08-18 07:46:39 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-18 07:46:39 INFO i.a.i.b.IntegrationRunner(runInternal):152 - Completed integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination 2022-08-18 07:46:40 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-08-18 07:46:41 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/32930/0/logs.log 2022-08-18 07:46:41 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.40.0-alpha 2022-08-18 07:46:41 INFO i.a.c.EnvConfigs(getEnvOrDefault):977 - Using default value for environment variable METRIC_CLIENT: '' 2022-08-18 07:46:41 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-08-18 07:46:41 INFO i.a.w.g.DefaultReplicationWorker(run):119 - start sync worker. job id: 32930 attempt id: 0 2022-08-18 07:46:41 INFO i.a.w.g.DefaultReplicationWorker(run):131 - configured sync modes: {null.contacts=incremental - append} 2022-08-18 07:46:41 INFO i.a.w.i.DefaultAirbyteDestination(start):69 - Running destination... 2022-08-18 07:46:41 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if airbyte/destination-snowflake:0.4.34 exists... 2022-08-18 07:46:41 INFO i.a.c.i.LineGobbler(voidCall):83 - airbyte/destination-snowflake:0.4.34 was found locally. 2022-08-18 07:46:41 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 32930 2022-08-18 07:46:41 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/32930/0 --log-driver none --name destination-snowflake-write-32930-0-duhas --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-snowflake:0.4.34 -e AIRBYTE_VERSION=0.40.0-alpha -e WORKER_JOB_ID=32930 airbyte/destination-snowflake:0.4.34 write --config destination_config.json --catalog destination_catalog.json 2022-08-18 07:46:41 INFO i.a.c.i.LineGobbler(voidCall):83 - Checking if orderdata/orderdata_hubspot:0.1.6 exists... 2022-08-18 07:46:41 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: 32930 2022-08-18 07:46:41 INFO i.a.c.i.LineGobbler(voidCall):83 - orderdata/orderdata_hubspot:0.1.6 was found locally. 2022-08-18 07:46:41 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/32930/0 --log-driver none --name orderdata_hubspot-read-32930-0-hboec --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=orderdata/orderdata_hubspot:0.1.6 -e AIRBYTE_VERSION=0.40.0-alpha -e WORKER_JOB_ID=32930 orderdata/orderdata_hubspot:0.1.6 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-08-18 07:46:41 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):411 - Destination output thread started. 2022-08-18 07:46:41 INFO i.a.w.g.DefaultReplicationWorker(run):173 - Waiting for source and destination threads to complete. 2022-08-18 07:46:41 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):303 - Replication thread started. 2022-08-18 07:46:42 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-08-18 07:46:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-08-18 07:46:42 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-08-18 07:46:42 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-08-18 07:46:43 source > Starting syncing SourceHubspot 2022-08-18 07:46:43 source > No scopes to grant when authenticating with API key. 2022-08-18 07:46:43 source > Syncing stream: contacts 2022-08-18 07:46:43 source > Setting state of contacts stream to {'updatedAt': '2022-08-17T14:29:40.629000Z'} 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 INFO i.a.i.b.IntegrationRunner(runInternal):104 - Running integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 INFO i.a.i.b.IntegrationRunner(runInternal):105 - Command: WRITE 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 INFO i.a.i.b.IntegrationRunner(runInternal):106 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-08-18 07:46:44 destination > 2022-08-18 07:46:44 INFO i.a.i.d.j.c.SwitchingDestination(getConsumer):65 - Using destination type: INTERNAL_STAGING 2022-08-18 07:46:45 source > Reading contacts associations of contact 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 WARN i.a.i.d.s.SnowflakeDatabase(createDataSource):110 - Obsolete User/password login mode is used. Please re-create a connection to use the latest connector's version 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 INFO i.a.i.d.s.StagingConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=test-contacts-contacts, namespace=null, outputSchemaName=AIRBYTE, tmpTableName=_airbyte_tmp_cdu_test_contacts_contacts, outputTableName=_airbyte_raw_test_contacts_contacts, syncMode=append} 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onStartFunction$1):116 - Preparing tmp tables in destination started for 1 streams 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onStartFunction$1):124 - Preparing staging area in destination started for schema AIRBYTE stream test-contacts-contacts: tmp table: _airbyte_tmp_cdu_test_contacts_contacts, stage: 2022/08/18/07/0BC919A3-980B-43AC-9918-709759A7F052/ 2022-08-18 07:46:45 destination > 2022-08-18 07:46:45 INFO c.z.h.HikariDataSource(getConnection):110 - HikariPool-1 - Starting... 2022-08-18 07:46:45 source > Reading companies associations of contact 2022-08-18 07:46:46 destination > 2022-08-18 07:46:46 INFO c.z.h.p.HikariPool(checkFailFast):565 - HikariPool-1 - Added connection net.snowflake.client.jdbc.SnowflakeConnectionV1@7e72a6cc 2022-08-18 07:46:46 destination > 2022-08-18 07:46:46 INFO c.z.h.HikariDataSource(getConnection):123 - HikariPool-1 - Start completed. 2022-08-18 07:46:46 destination > 2022-08-18 07:46:46 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):105 - closing connection 2022-08-18 07:46:47 destination > 2022-08-18 07:46:47 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onStartFunction$1):131 - Preparing staging area in destination completed for schema AIRBYTE stream test-contacts-contacts 2022-08-18 07:46:47 destination > 2022-08-18 07:46:47 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onStartFunction$1):134 - Preparing tmp tables in destination completed. 2022-08-18 07:46:47 destination > 2022-08-18 07:46:47 INFO i.a.i.d.r.SerializedBufferingStrategy(lambda$addRecord$0):47 - Starting a new buffer for stream test-contacts-contacts (current state: 0 bytes in 0 buffers) 2022-08-18 07:46:49 source > Reading contacts associations of contact 2022-08-18 07:46:49 source > Reading companies associations of contact 2022-08-18 07:46:52 source > Reading contacts associations of contact 2022-08-18 07:46:53 source > Reading companies associations of contact 2022-08-18 07:46:55 source > Reading contacts associations of contact 2022-08-18 07:46:56 source > Reading companies associations of contact 2022-08-18 07:46:59 source > Reading contacts associations of contact 2022-08-18 07:46:59 source > Reading companies associations of contact 2022-08-18 07:47:02 source > Reading contacts associations of contact 2022-08-18 07:47:02 source > Reading companies associations of contact 2022-08-18 07:47:04 source > Reading contacts associations of contact 2022-08-18 07:47:05 source > Reading companies associations of contact 2022-08-18 07:47:08 source > Reading contacts associations of contact 2022-08-18 07:47:08 source > Reading companies associations of contact 2022-08-18 07:47:11 source > Reading contacts associations of contact 2022-08-18 07:47:11 source > Reading companies associations of contact 2022-08-18 07:47:14 source > Reading contacts associations of contact 2022-08-18 07:47:14 source > Reading companies associations of contact 2022-08-18 07:47:16 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):329 - Records read: 1000 (25 MB) 2022-08-18 07:47:17 source > Reading contacts associations of contact 2022-08-18 07:47:17 source > Reading companies associations of contact 2022-08-18 07:47:20 source > Reading contacts associations of contact 2022-08-18 07:47:20 source > Reading companies associations of contact 2022-08-18 07:47:23 source > Reading contacts associations of contact 2022-08-18 07:47:23 source > Reading companies associations of contact 2022-08-18 07:47:25 source > Reading contacts associations of contact 2022-08-18 07:47:26 source > Reading companies associations of contact 2022-08-18 07:47:28 source > Reading contacts associations of contact 2022-08-18 07:47:29 source > Reading companies associations of contact 2022-08-18 07:47:31 source > Reading contacts associations of contact 2022-08-18 07:47:32 source > Reading companies associations of contact 2022-08-18 07:47:34 source > Reading contacts associations of contact 2022-08-18 07:47:35 source > Reading companies associations of contact 2022-08-18 07:47:37 source > Reading contacts associations of contact 2022-08-18 07:47:38 source > Reading companies associations of contact 2022-08-18 07:47:40 source > Reading contacts associations of contact 2022-08-18 07:47:40 source > Reading companies associations of contact 2022-08-18 07:47:43 source > Reading contacts associations of contact 2022-08-18 07:47:44 source > Reading companies associations of contact 2022-08-18 07:47:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):329 - Records read: 2000 (50 MB) 2022-08-18 07:47:46 source > Reading contacts associations of contact 2022-08-18 07:47:46 source > Reading companies associations of contact 2022-08-18 07:47:49 source > Reading contacts associations of contact 2022-08-18 07:47:49 source > Reading companies associations of contact 2022-08-18 07:47:51 source > Reading contacts associations of contact 2022-08-18 07:47:52 source > Reading companies associations of contact 2022-08-18 07:47:54 source > Reading contacts associations of contact 2022-08-18 07:47:55 source > Reading companies associations of contact 2022-08-18 07:47:57 source > Reading contacts associations of contact 2022-08-18 07:47:58 source > Reading companies associations of contact 2022-08-18 07:48:00 source > Reading contacts associations of contact 2022-08-18 07:48:00 source > Reading companies associations of contact 2022-08-18 07:48:03 source > Reading contacts associations of contact 2022-08-18 07:48:03 source > Reading companies associations of contact 2022-08-18 07:48:06 source > Reading contacts associations of contact 2022-08-18 07:48:06 source > Reading companies associations of contact 2022-08-18 07:48:09 source > Reading contacts associations of contact 2022-08-18 07:48:09 source > Reading companies associations of contact 2022-08-18 07:48:12 source > Reading contacts associations of contact 2022-08-18 07:48:12 source > Reading companies associations of contact 2022-08-18 07:48:14 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):329 - Records read: 3000 (75 MB) 2022-08-18 07:48:15 source > Reading contacts associations of contact 2022-08-18 07:48:15 source > Reading companies associations of contact 2022-08-18 07:48:18 source > Reading contacts associations of contact 2022-08-18 07:48:18 source > Reading companies associations of contact 2022-08-18 07:48:21 source > Reading contacts associations of contact 2022-08-18 07:48:21 source > Reading companies associations of contact 2022-08-18 07:48:24 source > Reading contacts associations of contact 2022-08-18 07:48:24 source > Reading companies associations of contact 2022-08-18 07:48:26 source > Reading contacts associations of contact 2022-08-18 07:48:27 source > Reading companies associations of contact 2022-08-18 07:48:29 source > Reading contacts associations of contact 2022-08-18 07:48:29 source > Reading companies associations of contact 2022-08-18 07:48:32 source > Reading contacts associations of contact 2022-08-18 07:48:32 source > Reading companies associations of contact 2022-08-18 07:48:35 source > Reading contacts associations of contact 2022-08-18 07:48:35 source > Reading companies associations of contact 2022-08-18 07:48:37 source > Reading contacts associations of contact 2022-08-18 07:48:38 source > Reading companies associations of contact 2022-08-18 07:48:40 source > Reading contacts associations of contact 2022-08-18 07:48:41 source > Reading companies associations of contact 2022-08-18 07:48:42 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):329 - Records read: 4000 (100 MB) 2022-08-18 07:48:43 source > Reading contacts associations of contact 2022-08-18 07:48:43 source > Reading companies associations of contact 2022-08-18 07:48:45 source > Reading contacts associations of contact 2022-08-18 07:48:46 source > Reading companies associations of contact 2022-08-18 07:48:48 source > Reading contacts associations of contact 2022-08-18 07:48:49 source > Reading companies associations of contact 2022-08-18 07:48:51 source > Reading contacts associations of contact 2022-08-18 07:48:52 source > Reading companies associations of contact 2022-08-18 07:48:54 source > Reading contacts associations of contact 2022-08-18 07:48:54 source > Reading companies associations of contact 2022-08-18 07:48:55 source > Advancing bookmark for contacts stream from 2022-08-17T14:29:40.629000+00:00 to 2022-08-18T07:48:53.550000+00:00 2022-08-18 07:48:55 source > Read 4462 records from contacts stream 2022-08-18 07:48:55 source > Finished syncing SourceHubspot 2022-08-18 07:48:55 source > SourceHubspot runtimes: 2022-08-18 07:48:55 source > Finished syncing SourceHubspot 2022-08-18 07:48:56 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):340 - Total records read: 4471 (112 MB) 2022-08-18 07:48:56 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):343 - Schema validation errors found for stream contacts. Error messages: [$.companies[0] is of an incorrect type. Expected it to be [null, string]] 2022-08-18 07:48:56 INFO i.a.w.g.DefaultReplicationWorker(run):178 - One of source or destination thread complete. Waiting on the other. 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):62 - Airbyte message consumer: succeeded. 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure. 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.r.SerializedBufferingStrategy(flushAll):100 - Flushing all 1 current buffers (6 MB in total) 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.r.SerializedBufferingStrategy(flushAll):102 - Flushing buffer of stream test-contacts-contacts (6 MB) 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.s.StagingConsumerFactory(lambda$flushBufferFunction$2):153 - Flushing buffer for stream test-contacts-contacts (6 MB) to staging 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.r.BaseSerializedBuffer(flush):131 - Wrapping up compression and write GZIP trailer data. 2022-08-18 07:48:56 destination > 2022-08-18 07:48:56 INFO i.a.i.d.r.BaseSerializedBuffer(flush):138 - Finished writing data to 65a393a8-05bc-4904-bdef-3bdac574b602789739043644493501.csv.gz (6 MB) 2022-08-18 07:48:58 destination > 2022-08-18 07:48:58 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):105 - closing connection 2022-08-18 07:48:58 destination > 2022-08-18 07:48:58 INFO i.a.i.d.r.FileBuffer(deleteFile):81 - Deleting tempFile data 65a393a8-05bc-4904-bdef-3bdac574b602789739043644493501.csv.gz 2022-08-18 07:48:58 destination > 2022-08-18 07:48:58 INFO i.a.i.d.r.SerializedBufferingStrategy(close):122 - Closing buffer for stream test-contacts-contacts 2022-08-18 07:48:58 destination > 2022-08-18 07:48:58 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):181 - Copying into tables in destination started for 1 streams 2022-08-18 07:48:58 destination > 2022-08-18 07:48:58 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):190 - Copying stream test-contacts-contacts of schema AIRBYTE into tmp table _airbyte_tmp_cdu_test_contacts_contacts to final table _airbyte_raw_test_contacts_contacts from stage path 2022/08/18/07/0BC919A3-980B-43AC-9918-709759A7F052/ with 1 file(s) [65a393a8-05bc-4904-bdef-3bdac574b602789739043644493501.csv.gz] 2022-08-18 07:49:04 destination > 2022-08-18 07:49:04 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):137 - No onDestinationCloseOperations required for this destination. 2022-08-18 07:49:04 destination > 2022-08-18 07:49:04 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):211 - Executing finalization of tables. 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):213 - Finalizing tables in destination completed. 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):215 - Cleaning up destination started for 1 streams 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):219 - Cleaning tmp table in destination started for stream test-contacts-contacts. schema AIRBYTE, tmp table name: _airbyte_tmp_cdu_test_contacts_contacts 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):225 - Cleaning stage in destination started for stream test-contacts-contacts. schema AIRBYTE, stage: AIRBYTE_TEST_CONTACTS_CONTACTS 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.d.s.StagingConsumerFactory(lambda$onCloseFunction$3):230 - Cleaning up destination completed. 2022-08-18 07:49:08 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):421 - State in DefaultReplicationWorker from destination: io.airbyte.protocol.models.AirbyteMessage@46728fce[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@48b56970[type=,stream=,global=,data={"contacts":{"updatedAt":"2022-08-18T07:48:53.550000Z"}},additionalProperties={}],trace=,additionalProperties={}] 2022-08-18 07:49:08 destination > 2022-08-18 07:49:08 INFO i.a.i.b.IntegrationRunner(runInternal):152 - Completed integration: io.airbyte.integrations.destination.snowflake.SnowflakeDestination 2022-08-18 07:49:10 INFO i.a.w.g.DefaultReplicationWorker(run):180 - Source and destination threads complete. 2022-08-18 07:49:10 INFO i.a.w.g.DefaultReplicationWorker(run):243 - sync summary: io.airbyte.config.ReplicationAttemptSummary@36294d6f[status=completed,recordsSynced=4462,bytesSynced=117733660,startTime=1660808801210,endTime=1660808950098,totalStats=io.airbyte.config.SyncStats@5f432f76[recordsEmitted=4462,bytesEmitted=117733660,stateMessagesEmitted=9,recordsCommitted=4462],streamStats=[io.airbyte.config.StreamSyncStats@59c05409[streamName=test-contacts-contacts,stats=io.airbyte.config.SyncStats@30dd1281[recordsEmitted=4462,bytesEmitted=117733660,stateMessagesEmitted=,recordsCommitted=4462]]]] 2022-08-18 07:49:10 INFO i.a.w.g.DefaultReplicationWorker(run):270 - Source output at least one state message 2022-08-18 07:49:10 INFO i.a.w.g.DefaultReplicationWorker(run):276 - State capture: Updated state to: Optional[io.airbyte.config.State@4c6363c0[state={"contacts":{"updatedAt":"2022-08-18T07:48:53.550000Z"}}]] 2022-08-18 07:49:10 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-08-18 07:49:10 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):165 - sync summary: io.airbyte.config.StandardSyncOutput@3a3f323e[standardSyncSummary=io.airbyte.config.StandardSyncSummary@7780a1d6[status=completed,recordsSynced=4462,bytesSynced=117733660,startTime=1660808801210,endTime=1660808950098,totalStats=io.airbyte.config.SyncStats@5f432f76[recordsEmitted=4462,bytesEmitted=117733660,stateMessagesEmitted=9,recordsCommitted=4462],streamStats=[io.airbyte.config.StreamSyncStats@59c05409[streamName=test-contacts-contacts,stats=io.airbyte.config.SyncStats@30dd1281[recordsEmitted=4462,bytesEmitted=117733660,stateMessagesEmitted=,recordsCommitted=4462]]]],normalizationSummary=,state=io.airbyte.config.State@4c6363c0[state={"contacts":{"updatedAt":"2022-08-18T07:48:53.550000Z"}}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@3650af4b[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@6c3ed6ec[stream=io.airbyte.protocol.models.AirbyteStream@2f53a797[name=test-contacts-contacts,jsonSchema={"type":["null","object"],"$schema":"http://json-schema.org/draft-07/schema#","properties":{"id":{"type":["null","string"]},"archived":{"type":["null","boolean"]},"companies":{"type":["null","array"],"items":{"type":["null","string"]}},"createdAt":{"type":["null","string"],"format":"date-time"},"updatedAt":{"type":["null","string"],"format":"date-time"},"properties":{"type":"object","properties":{"app":{"type":["null","string"]},"fax":{"type":["null","string"]},"rca":{"type":["null","string"]},"sms":{"type":["null","string"]},"zip":{"type":["null","string"]},"citt":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"test":{"type":["null","string"]},"city_":{"type":["null","string"]},"email":{"type":["null","string"]},"notes":{"type":["null","string"]},"og_fv":{"type":["null","string"]},"phone":{"type":["null","string"]},"stadt":{"type":["null","string"]},"state":{"type":["null","string"]},"ville":{"type":["null","string"]},"cidade":{"type":["null","string"]},"ciudad":{"type":["null","string"]},"degree":{"type":["null","string"]},"gender":{"type":["null","string"]},"region":{"type":["null","string"]},"school":{"type":["null","string"]},"upload":{"type":["null","string"]},"address":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"dni_nie":{"type":["null","string"]},"ip_city":{"type":["null","string"]},"message":{"type":["null","string"]},"micro_1":{"type":["null","string"]},"prepaid":{"type":["null","string"]},"quality":{"type":["null","string"]},"show_up":{"type":["null","string"]},"website":{"type":["null","string"]},"address_":{"type":["null","string"]},"cc_group":{"type":["null","string"]},"country_":{"type":["null","string"]},"fv_owner":{"type":["null","string"]},"industry":{"type":["null","string"]},"inferior":{"type":["null","string"]},"ip_state":{"type":["null","string"]},"jobtitle":{"type":["null","string"]},"lastname":{"type":["null","string"]},"location":{"type":["null","string"]},"pipeline":{"type":["null","string"]},"province":{"type":["null","string"]},"ref_date":{"type":["null","string"],"format":"date"},"sms_sent":{"type":["null","string"]},"superior":{"type":["null","string"]},"supplier":{"type":["null","string"]},"utm_term":{"type":["null","string"]},"whatsapp":{"type":["null","string"]},"affiliate":{"type":["null","string"]},"clinic_id":{"type":["null","string"]},"closedate":{"type":["null","string"],"format":"date-time"},"complaint":{"type":["null","string"]},"firstname":{"type":["null","string"]},"id_ticket":{"type":["null","string"]},"inbox_url":{"type":["null","string"]},"ip_latlon":{"type":["null","string"]},"lead_type":{"type":["null","string"]},"lower_set":{"type":["null","string"]},"num_notes":{"type":["null","number"]},"open_page":{"type":["null","string"]},"s2i_email":{"type":["null","string"]},"seniority":{"type":["null","string"]},"upper_set":{"type":["null","string"]},"advocat_id":{"type":["null","string"]},"birth_date":{"type":["null","string"],"format":"date"},"calendario":{"type":["null","string"]},"close_date":{"type":["null","string"],"format":"date"},"createdate":{"type":["null","string"],"format":"date-time"},"deal_owner":{"type":["null","string"]},"employment":{"type":["null","string"]},"hs_persona":{"type":["null","string"]},"impress_id":{"type":["null","string"]},"invitee_id":{"type":["null","string"]},"ip_address":{"type":["null","string"]},"ip_country":{"type":["null","string"]},"ip_zipcode":{"type":["null","string"]},"name_amigo":{"type":["null","string"]},"prep_works":{"type":["null","string"]},"profession":{"type":["null","string"]},"ref_code_1":{"type":["null","string"]},"roistat_id":{"type":["null","string"]},"salutation":{"type":["null","string"]},"start_date":{"type":["null","string"]},"trustpilot":{"type":["null","string"]},"utm_medium":{"type":["null","string"]},"utm_source":{"type":["null","string"]},"visit_date":{"type":["null","string"],"format":"date"},"work_email":{"type":["null","string"]},"backend_env":{"type":["null","string"]},"clinic_name":{"type":["null","string"]},"clinic_type":{"type":["null","string"]},"contact_ids":{"type":["null","string"]},"dm_pipeline":{"type":["null","string"]},"do_you_have":{"type":["null","string"]},"email_amigo":{"type":["null","string"]},"front_smile":{"type":["null","string"]},"full_name_2":{"type":["null","string"]},"hs_language":{"type":["null","string"]},"hs_pipeline":{"type":["null","string"]},"hs_timezone":{"type":["null","string"]},"influencers":{"type":["null","string"]},"mass_upload":{"type":["null","string"]},"mobilephone":{"type":["null","string"]},"nationality":{"type":["null","string"]},"oclusion_vs":{"type":["null","string"]},"org__status":{"type":["null","string"]},"postal_code":{"type":["null","string"]},"rent_amount":{"type":["null","number"]},"sms_clicked":{"type":["null","string"]},"source_page":{"type":["null","string"]},"submit_page":{"type":["null","string"]},"tiktok_user":{"type":["null","string"]},"utm_content":{"type":["null","string"]},"vs_approved":{"type":["null","string"]},"vs_inferior":{"type":["null","string"]},"vs_password":{"type":["null","string"]},"vs_superior":{"type":["null","string"]},"bank_receipt":{"type":["null","string"]},"booking_page":{"type":["null","string"]},"company_name":{"type":["null","string"]},"company_size":{"type":["null","string"]},"confirmacion":{"type":["null","string"]},"contact_type":{"type":["null","string"]},"current_page":{"type":["null","string"]},"deal_in_capo":{"type":["null","string"]},"doctor_owner":{"type":["null","string"]},"emailadresse":{"type":["null","string"]},"frontal_bite":{"type":["null","string"]},"full_payment":{"type":["null","string"]},"hs_object_id":{"type":["null","number"]},"hs_read_only":{"type":["null","boolean"]},"hs_testpurge":{"type":["null","string"]},"hubspotscore":{"type":["null","number"]},"is_developer":{"type":["null","string"]},"job_function":{"type":["null","string"]},"name_surname":{"type":["null","string"]},"numemployees":{"type":["null","string"]},"prnom_et_nom":{"type":["null","string"]},"product_type":{"type":["null","string"]},"show_up_page":{"type":["null","string"]},"sms_not_sent":{"type":["null","string"]},"top_interest":{"type":["null","string"]},"utm_campaign":{"type":["null","string"]},"voucher_sent":{"type":["null","string"]},"vs_auto_sent":{"type":["null","string"]},"whathub_sync":{"type":["null","string"]},"annualrevenue":{"type":["null","string"]},"campaign_name":{"type":["null","string"]},"company_phone":{"type":["null","string"]},"csat_answer_1":{"type":["null","number"]},"csat_answer_2":{"type":["null","number"]},"csat_answer_3":{"type":["null","number"]},"customer_uuid":{"type":["null","string"]},"date_of_birth":{"type":["null","string"]},"days_to_close":{"type":["null","number"]},"delivery_date":{"type":["null","string"],"format":"date"},"experiment_id":{"type":["null","string"]},"hs_createdate":{"type":["null","string"],"format":"date-time"},"hs_email_open":{"type":["null","number"]},"hs_is_contact":{"type":["null","boolean"]},"ip_state_code":{"type":["null","string"]},"lead_ad_prop0":{"type":["null","string"]},"lead_ad_prop1":{"type":["null","string"]},"lead_ad_prop_":{"type":["null","string"]},"location_city":{"type":["null","string"]},"n3d_scan_done":{"type":["null","string"]},"nome_completo":{"type":["null","string"]},"oberer_kiefer":{"type":["null","string"]},"preworks_done":{"type":["null","string"]},"reporting_sms":{"type":["null","string"]},"sakari_opt_in":{"type":["null","string"],"format":"date-time"},"sms_delivered":{"type":["null","string"]},"sms_sent_date":{"type":["null","string"],"format":"date"},"telefonnummer":{"type":["null","string"]},"ticket_status":{"type":["null","string"]},"total_revenue":{"type":["null","number"]},"twitterhandle":{"type":["null","string"]},"vs_ready_date":{"type":["null","string"],"format":"date"},"campaign_offer":{"type":["null","string"]},"clinic_address":{"type":["null","string"]},"dm_integration":{"type":["null","string"]},"extra_discount":{"type":["null","string"]},"field_of_study":{"type":["null","string"]},"frontaler_biss":{"type":["null","string"]},"hs_buying_role":{"type":["null","string"]},"hs_email_click":{"type":["null","number"]},"hs_ip_timezone":{"type":["null","string"]},"hs_is_unworked":{"type":["null","boolean"]},"hs_lead_status":{"type":["null","string"]},"hs_legal_basis":{"type":["null","string"]},"instagram_user":{"type":["null","string"]},"interesado_en_":{"type":["null","string"]},"left_side_bite":{"type":["null","string"]},"lifecyclestage":{"type":["null","string"]},"marital_status":{"type":["null","string"]},"monthly_income":{"type":["null","number"]},"nome_e_cognome":{"type":["null","string"]},"other_preworks":{"type":["null","string"]},"patient_temper":{"type":["null","string"]},"prepwork_price":{"type":["null","number"]},"sakari_opt_out":{"type":["null","string"],"format":"date-time"},"third_interest":{"type":["null","string"]},"treatment_link":{"type":["null","string"]},"treatment_plan":{"type":["null","string"]},"unterer_kiefer":{"type":["null","string"]},"appointment_day":{"type":["null","string"],"format":"date"},"auto_video_type":{"type":["null","string"]},"booking_address":{"type":["null","string"]},"booking_channel":{"type":["null","string"]},"company_address":{"type":["null","string"]},"fingerprint_uid":{"type":["null","string"]},"frontal_sonrisa":{"type":["null","string"]},"fv_online_email":{"type":["null","string"]},"graduation_date":{"type":["null","string"]},"hs_all_team_ids":{"type":["null","string"]},"hs_email_bounce":{"type":["null","number"]},"hs_email_domain":{"type":["null","string"]},"hs_email_optout":{"type":["null","boolean"]},"hs_testrollback":{"type":["null","string"]},"hs_time_in_lead":{"type":["null","number"]},"hubspot_team_id":{"type":["null","string"]},"in_transit_date":{"type":["null","string"],"format":"date"},"ip_country_code":{"type":["null","string"]},"landingpageexp1":{"type":["null","string"]},"marital_status_":{"type":["null","string"]},"military_status":{"type":["null","string"]},"motivo_consulta":{"type":["null","string"]},"prepayment_date":{"type":["null","string"],"format":"date"},"reason_for_call":{"type":["null","string"]},"referral_source":{"type":["null","string"]},"referral_status":{"type":["null","string"]},"rejected_reason":{"type":["null","string"]},"rent_model_1000":{"type":["null","string"]},"right_side_bite":{"type":["null","string"]},"sakari_send_sms":{"type":["null","string"]},"second_interest":{"type":["null","string"]},"type_of_housing":{"type":["null","string"]},"vs_auto_trigger":{"type":["null","string"]},"vs_sending_date":{"type":["null","string"],"format":"date"},"appointment_time":{"type":["null","string"]},"appointment_type":{"type":["null","string"]},"arcata_inferiore":{"type":["null","string"]},"arcata_superiore":{"type":["null","string"]},"asked_for_refund":{"type":["null","string"]},"dm_manual_switch":{"type":["null","string"]},"first_visit_date":{"type":["null","string"],"format":"date"},"flagship_clinics":{"type":["null","string"]},"frontal_oclusion":{"type":["null","string"]},"hs_all_owner_ids":{"type":["null","string"]},"hs_email_replied":{"type":["null","number"]},"hs_latest_source":{"type":["null","string"]},"hs_time_in_other":{"type":["null","number"]},"hubspot_owner_id":{"type":["null","string"]},"impress_employee":{"type":["null","string"]},"lastmodifieddate":{"type":["null","string"],"format":"date-time"},"manual_sms_count":{"type":["null","number"]},"medical_referral":{"type":["null","string"]},"n2__phone_number":{"type":["null","string"]},"nmero_de_telfono":{"type":["null","string"]},"number_of_quotes":{"type":["null","string"]},"numro_de_tlphone":{"type":["null","string"]},"obturation_count":{"type":["null","number"]},"oclusal_superior":{"type":["null","string"]},"patient_vs_doubt":{"type":["null","string"]},"payment_approver":{"type":["null","string"]},"personal_phone_1":{"type":["null","string"]},"personal_phone_2":{"type":["null","string"]},"prepayment_owner":{"type":["null","string"]},"prepworks___es__":{"type":["null","string"]},"preworks_partner":{"type":["null","string"]},"production_owner":{"type":["null","string"]},"referral_contact":{"type":["null","number"]},"refund_incentive":{"type":["null","string"]},"service_interest":{"type":["null","string"]},"sorriso_frontale":{"type":["null","string"]},"ticket_migration":{"type":["null","string"]},"vs_approved_date":{"type":["null","string"],"format":"date"},"whatsapp_booking":{"type":["null","string"]},"whatsapp_link_cc":{"type":["null","string"]},"aligner_treatment":{"type":["null","string"]},"amount_to_finance":{"type":["null","number"]},"appointment_owner":{"type":["null","string"]},"calendly_answer_1":{"type":["null","string"]},"calendly_answer_2":{"type":["null","string"]},"calendly_answer_3":{"type":["null","string"]},"calendly_answer_4":{"type":["null","string"]},"calendly_answer_5":{"type":["null","string"]},"calendly_answer_6":{"type":["null","string"]},"calendly_answer_9":{"type":["null","string"]},"calendly_location":{"type":["null","string"]},"cancelation_count":{"type":["null","number"]},"clinic_id_address":{"type":["null","string"]},"clinic_visit_done":{"type":["null","string"]},"correo_electrnico":{"type":["null","string"]},"first_visit_owner":{"type":["null","string"]},"flagship_location":{"type":["null","string"]},"frontal_sonriendo":{"type":["null","string"]},"fv_original_count":{"type":["null","string"],"format":"date"},"instagram_comment":{"type":["null","string"]},"landing_page_name":{"type":["null","string"]},"nmero_de_telefone":{"type":["null","string"]},"nmero_de_telfono_":{"type":["null","string"]},"number_of_meeting":{"type":["null","number"]},"prepayment_amount":{"type":["null","number"]},"prepworks_partner":{"type":["null","string"]},"random_split_test":{"type":["null","number"]},"referral_discount":{"type":["null","string"]},"rescheduled_owner":{"type":["null","string"]},"retainers_patient":{"type":["null","string"]},"show_up_intention":{"type":["null","string"]},"sms_not_delivered":{"type":["null","string"]},"vollstndiger_name":{"type":["null","string"]},"vs_treatment_link":{"type":["null","string"]},"zoom_meeting_link":{"type":["null","string"]},"zoom_meeting_time":{"type":["null","string"]},"calendly_answer_10":{"type":["null","string"]},"confirmation_owner":{"type":["null","string"]},"first_payment_type":{"type":["null","string"]},"hs_count_is_worked":{"type":["null","number"]},"hs_email_delivered":{"type":["null","number"]},"hs_google_click_id":{"type":["null","string"]},"inbound_email_type":{"type":["null","string"]},"marketing_campaign":{"type":["null","string"]},"mass_edit__cloned_":{"type":["null","string"]},"nmero_de_telefono_":{"type":["null","string"]},"nombre_y_apellidos":{"type":["null","string"]},"notes_last_updated":{"type":["null","string"],"format":"date-time"},"numero_di_telefono":{"type":["null","string"]},"oclusal_inferior_2":{"type":["null","string"]},"other_prework_type":{"type":["null","string"]},"quel_ge_avezvous__":{"type":["null","string"]},"recent_deal_amount":{"type":["null","number"]},"referral_card_sent":{"type":["null","string"]},"refinement_patient":{"type":["null","string"]},"utm_campaign_count":{"type":["null","number"]},"whathub_sync_deals":{"type":["null","string"]},"are_you_looking_for":{"type":["null","string"]},"associatedcompanyid":{"type":["null","number"]},"black_friday_raffle":{"type":["null","string"]},"calendly_question_1":{"type":["null","string"]},"calendly_question_2":{"type":["null","string"]},"calendly_question_3":{"type":["null","string"]},"calendly_question_4":{"type":["null","string"]},"calendly_question_5":{"type":["null","string"]},"calendly_question_6":{"type":["null","string"]},"calendly_question_7":{"type":["null","string"]},"calendly_question_8":{"type":["null","string"]},"calendly_question_9":{"type":["null","string"]},"currentlyinworkflow":{"type":["null","string"]},"dni_nie_photo_back_":{"type":["null","string"]},"frontal_en_oclusion":{"type":["null","string"]},"google_reviews_link":{"type":["null","string"]},"hs_all_contact_vids":{"type":["null","string"]},"hs_analytics_source":{"type":["null","string"]},"hs_date_exited_lead":{"type":["null","string"],"format":"date-time"},"hs_lastmodifieddate":{"type":["null","string"],"format":"date-time"},"hs_time_in_customer":{"type":["null","number"]},"num_contacted_notes":{"type":["null","number"]},"refund_compensation":{"type":["null","string"]},"relationship_status":{"type":["null","string"]},"sakari_sms_sent_qty":{"type":["null","number"]},"ticket_status_patch":{"type":["null","string"]},"aircall_last_call_at":{"type":["null","string"],"format":"date-time"},"booking_anticipation":{"type":["null","number"]},"calendly_question_10":{"type":["null","string"]},"dni_nie_photo_front_":{"type":["null","string"]},"first_payment_clinic":{"type":["null","string"]},"first_visit_location":{"type":["null","string"]},"frontbild___lachelnd":{"type":["null","string"]},"hs_additional_emails":{"type":["null","string"]},"hs_analytics_revenue":{"type":["null","number"]},"hs_count_is_unworked":{"type":["null","number"]},"hs_date_entered_lead":{"type":["null","string"],"format":"date-time"},"hs_date_exited_other":{"type":["null","string"],"format":"date-time"},"hs_email_bad_address":{"type":["null","boolean"]},"hs_email_quarantined":{"type":["null","boolean"]},"hs_facebook_click_id":{"type":["null","string"]},"hs_marketable_status":{"type":["null","string"]},"hs_merged_object_ids":{"type":["null","string"]},"jun_2022_discount_es":{"type":["null","string"]},"notes_last_contacted":{"type":["null","string"],"format":"date-time"},"num_associated_deals":{"type":["null","number"]},"number_of_courritage":{"type":["null","number"]},"number_of_extraction":{"type":["null","number"]},"number_of_obturation":{"type":["null","number"]},"prepworks_courritage":{"type":["null","string"]},"prepworks_obturation":{"type":["null","string"]},"refund_approved_date":{"type":["null","string"],"format":"date"},"sorteo_discount_date":{"type":["null","string"],"format":"date"},"booked_after_sms_push":{"type":["null","string"]},"count_manual_creation":{"type":["null","string"]},"date_of_deal_creation":{"type":["null","string"],"format":"date-time"},"email_referral_source":{"type":["null","string"]},"fb_pixel_intergartion":{"type":["null","string"]},"first_conversion_date":{"type":["null","string"],"format":"date-time"},"hs_analytics_last_url":{"type":["null","string"]},"hs_created_by_user_id":{"type":["null","number"]},"hs_date_entered_other":{"type":["null","string"],"format":"date-time"},"hs_time_in_evangelist":{"type":["null","number"]},"hs_time_in_subscriber":{"type":["null","number"]},"hs_updated_by_user_id":{"type":["null","number"]},"lead_to_book_sms_push":{"type":["null","string"]},"location_code_impress":{"type":["null","number"]},"morso_chiuso_frontale":{"type":["null","string"]},"num_conversion_events":{"type":["null","number"]},"payment_approved_date":{"type":["null","string"],"format":"date"},"prepworks__extraction":{"type":["null","string"]},"vs_in_production_date":{"type":["null","string"],"format":"date"},"zoom_meeting_password":{"type":["null","string"]},"appointment_days_count":{"type":["null","number"]},"clinics_history_number":{"type":["null","string"]},"dm_integration_patient":{"type":["null","string"]},"hs_analytics_first_url":{"type":["null","string"]},"hs_clicked_linkedin_ad":{"type":["null","string"]},"hs_email_is_ineligible":{"type":["null","boolean"]},"hs_facebook_ad_clicked":{"type":["null","boolean"]},"hs_linkedin_ad_clicked":{"type":["null","string"]},"hs_time_in_opportunity":{"type":["null","number"]},"hs_unique_creation_key":{"type":["null","string"]},"last_used_aircall_tags":{"type":["null","string"]},"number_of_oral_hygiene":{"type":["null","number"]},"preferred_contact_time":{"type":["null","string"]},"recent_conversion_date":{"type":["null","string"],"format":"date-time"},"recent_deal_close_date":{"type":["null","string"],"format":"date-time"},"referral_discount_date":{"type":["null","string"],"format":"date"},"sakari_message_sent_at":{"type":["null","string"],"format":"date-time"},"sakari_message_sent_by":{"type":["null","string"]},"sakari_message_sent_id":{"type":["null","string"]},"appointment_date_booked":{"type":["null","string"],"format":"date"},"contact_creation_source":{"type":["null","string"]},"create_appointment_date":{"type":["null","string"],"format":"date"},"first_deal_created_date":{"type":["null","string"],"format":"date-time"},"hs_analytics_num_visits":{"type":["null","number"]},"hs_date_exited_customer":{"type":["null","string"],"format":"date-time"},"hs_email_last_open_date":{"type":["null","string"],"format":"date-time"},"hs_email_last_send_date":{"type":["null","string"],"format":"date-time"},"hs_email_optout_6840956":{"type":["null","string"]},"hs_email_optout_6841009":{"type":["null","string"]},"hs_email_optout_6923852":{"type":["null","string"]},"hs_email_optout_6923945":{"type":["null","string"]},"hs_latest_source_data_1":{"type":["null","string"]},"hs_latest_source_data_2":{"type":["null","string"]},"hs_marketable_reason_id":{"type":["null","string"]},"hs_pinned_engagement_id":{"type":["null","number"]},"is_possibly_a_duplicate":{"type":["null","string"]},"left_to_pay__financing_":{"type":["null","string"]},"sakari_sms_received_qty":{"type":["null","number"]},"voucher_rejected_reason":{"type":["null","string"]},"webinareventlastupdated":{"type":["null","number"]},"campaign_discount_amount":{"type":["null","string"]},"email_autobooking_source":{"type":["null","string"]},"hs_date_entered_customer":{"type":["null","string"],"format":"date-time"},"hs_email_first_open_date":{"type":["null","string"],"format":"date-time"},"hs_email_first_send_date":{"type":["null","string"],"format":"date-time"},"hs_email_last_click_date":{"type":["null","string"],"format":"date-time"},"hs_email_last_email_name":{"type":["null","string"]},"hs_email_last_reply_date":{"type":["null","string"],"format":"date-time"},"hs_email_optout_14513832":{"type":["null","string"]},"hs_email_optout_33079214":{"type":["null","string"]},"hs_predictivescoringtier":{"type":["null","string"]},"hs_sequences_is_enrolled":{"type":["null","boolean"]},"impress_marketing_status":{"type":["null","string"]},"lateral_derecho_oclusion":{"type":["null","string"]},"manual_creation_counting":{"type":["null","number"]},"morso_chiuso_lato_destro":{"type":["null","string"]},"notes_next_activity_date":{"type":["null","string"],"format":"date-time"},"number_of_call_attempted":{"type":["null","number"]},"preferred_contact_method":{"type":["null","string"]},"put_into_production_date":{"type":["null","string"],"format":"date"},"que_te_gustaria_mejorar_":{"type":["null","string"]},"sakari_message_sent_type":{"type":["null","string"]},"seniority_in_the_company":{"type":["null","number"]},"whathub_last_message_out":{"type":["null","string"]},"biss_von_der_linken_seite":{"type":["null","string"]},"csat_first_visit_answer_1":{"type":["null","number"]},"csat_first_visit_answer_2":{"type":["null","number"]},"csat_first_visit_answer_3":{"type":["null","number"]},"experiment_2_self_booking":{"type":["null","string"]},"hs_avatar_filemanager_key":{"type":["null","string"]},"hs_calculated_merged_vids":{"type":["null","string"]},"hs_date_exited_evangelist":{"type":["null","string"],"format":"date-time"},"hs_date_exited_subscriber":{"type":["null","string"],"format":"date-time"},"hs_email_first_click_date":{"type":["null","string"],"format":"date-time"},"hs_email_first_reply_date":{"type":["null","string"],"format":"date-time"},"hs_marketable_reason_type":{"type":["null","string"]},"hs_user_ids_of_all_owners":{"type":["null","string"]},"last_aircall_call_outcome":{"type":["null","string"]},"marketing_contact_pt_sent":{"type":["null","string"]},"preferred_contact_channel":{"type":["null","string"]},"sakari_message_sent_error":{"type":["null","string"]},"sakari_message_sent_price":{"type":["null","number"]},"show_up_page_confirmation":{"type":["null","string"]},"ukraine_full_payment_date":{"type":["null","string"],"format":"date"},"avezvous_une_carte_vitale_":{"type":["null","string"]},"biss_von_der_rechten_seite":{"type":["null","string"]},"black_friday_2021_discount":{"type":["null","string"]},"booked_after_sms_push_date":{"type":["null","string"],"format":"date"},"contact_owner_assiged_date":{"type":["null","string"],"format":"date"},"csat_on_treatment_answer_1":{"type":["null","number"]},"csat_on_treatment_answer_2":{"type":["null","number"]},"csat_on_treatment_answer_3":{"type":["null","number"]},"hs_all_accessible_team_ids":{"type":["null","string"]},"hs_analytics_last_referrer":{"type":["null","string"]},"hs_analytics_source_data_1":{"type":["null","string"]},"hs_analytics_source_data_2":{"type":["null","string"]},"hs_calculated_phone_number":{"type":["null","string"]},"hs_date_entered_evangelist":{"type":["null","string"],"format":"date-time"},"hs_date_entered_subscriber":{"type":["null","string"],"format":"date-time"},"hs_date_exited_opportunity":{"type":["null","string"],"format":"date-time"},"hs_document_last_revisited":{"type":["null","string"],"format":"date-time"},"hs_emailconfirmationstatus":{"type":["null","string"]},"hs_has_active_subscription":{"type":["null","number"]},"hs_latest_meeting_activity":{"type":["null","string"],"format":"date-time"},"hs_latest_source_timestamp":{"type":["null","string"],"format":"date"},"hs_sales_email_last_opened":{"type":["null","string"],"format":"date-time"},"hubspot_owner_assigneddate":{"type":["null","string"],"format":"date-time"},"impress_preferred_language":{"type":["null","string"]},"lateral_izquierdo_oclusion":{"type":["null","string"]},"left_to_pay__full_payment_":{"type":["null","string"]},"morso_chiuso_lato_sinistro":{"type":["null","string"]},"sakari_message_received_at":{"type":["null","string"],"format":"date-time"},"sakari_message_received_id":{"type":["null","string"]},"sakari_message_sent_source":{"type":["null","string"]},"sakari_message_sent_status":{"type":["null","string"]},"beginning_of_treatment_date":{"type":["null","string"],"format":"date"},"confirm_put_into_production":{"type":["null","string"]},"csat_onboarding_answer_date":{"type":["null","string"],"format":"date"},"first_conversion_event_name":{"type":["null","string"]},"hs_analytics_first_referrer":{"type":["null","string"]},"hs_analytics_last_timestamp":{"type":["null","string"],"format":"date-time"},"hs_analytics_num_page_views":{"type":["null","number"]},"hs_calculated_mobile_number":{"type":["null","string"]},"hs_content_membership_notes":{"type":["null","string"]},"hs_created_by_conversations":{"type":["null","boolean"]},"hs_date_entered_opportunity":{"type":["null","string"],"format":"date-time"},"hs_email_hard_bounce_reason":{"type":["null","string"]},"hs_email_quarantined_reason":{"type":["null","string"]},"hs_feedback_last_nps_rating":{"type":["null","string"]},"hs_last_sales_activity_date":{"type":["null","string"],"format":"date-time"},"hs_last_sales_activity_type":{"type":["null","string"]},"hs_latest_sequence_enrolled":{"type":["null","number"]},"hs_lifecyclestage_lead_date":{"type":["null","string"],"format":"date-time"},"hs_marketable_until_renewal":{"type":["null","string"]},"hs_sa_first_engagement_date":{"type":["null","string"],"format":"date-time"},"hs_sales_email_last_clicked":{"type":["null","string"],"format":"date-time"},"hs_sales_email_last_replied":{"type":["null","string"],"format":"date-time"},"hs_sequences_enrolled_count":{"type":["null","number"]},"hs_time_to_first_engagement":{"type":["null","number"]},"lateral_derecho_en_oclusion":{"type":["null","string"]},"repite_tu_nmero_de_telfono_":{"type":["null","string"]},"sakari_message_sent_message":{"type":["null","string"]},"associatedcompanylastupdated":{"type":["null","number"]},"confirma_tu_nmero_de_telfono":{"type":["null","string"]},"csat_first_visit_answer_date":{"type":["null","string"],"format":"date"},"dm_manual_switch_spreadsheet":{"type":["null","string"]},"hs_analytics_first_timestamp":{"type":["null","string"],"format":"date-time"},"hs_content_membership_status":{"type":["null","string"]},"hs_feedback_last_survey_date":{"type":["null","string"],"format":"date-time"},"hs_lifecyclestage_other_date":{"type":["null","string"],"format":"date-time"},"hs_predictivecontactscore_v2":{"type":["null","number"]},"hs_sa_first_engagement_descr":{"type":["null","string"]},"mail_sent__book_appointment_":{"type":["null","number"]},"num_unique_conversion_events":{"type":["null","number"]},"number_of_complex_extraction":{"type":["null","number"]},"number_of_periodontal_report":{"type":["null","number"]},"number_of_simple_endodontics":{"type":["null","number"]},"prepworks_complex_extraction":{"type":["null","string"]},"prepworks_periodontal_report":{"type":["null","string"]},"prepworks_simple_endodontics":{"type":["null","string"]},"qr_kit_received_confirmation":{"type":["null","string"]},"recent_conversion_event_name":{"type":["null","string"]},"sakari_message_received_type":{"type":["null","string"]},"sakari_message_sent_segments":{"type":["null","number"]},"subscription_model_purchased":{"type":["null","string"]},"surveymonkeyeventlastupdated":{"type":["null","number"]},"csat_on_treatment_answer_date":{"type":["null","string"],"format":"date"},"csat_onboarding_overall_score":{"type":["null","number"]},"first_call_center_interaction":{"type":["null","string"],"format":"date"},"hs_first_engagement_object_id":{"type":["null","number"]},"hs_latest_sequence_ended_date":{"type":["null","string"],"format":"date-time"},"hs_time_in_salesqualifiedlead":{"type":["null","number"]},"introduce_tu_nmero_de_telfono":{"type":["null","string"]},"lateral_izquierdo_en_oclusion":{"type":["null","string"]},"sakari_message_received_error":{"type":["null","string"]},"sakari_message_received_price":{"type":["null","number"]},"subscription_model_interested":{"type":["null","string"]},"whathub_last_message_out_date":{"type":["null","string"],"format":"date-time"},"csat_end_of_treatment_answer_1":{"type":["null","number"]},"csat_end_of_treatment_answer_2":{"type":["null","number"]},"csat_end_of_treatment_answer_3":{"type":["null","number"]},"csat_first_visit_average_score":{"type":["null","number"]},"hs_calculated_form_submissions":{"type":["null","string"]},"hs_conversations_visitor_email":{"type":["null","string"]},"hs_feedback_last_nps_follow_up":{"type":["null","string"]},"ip__ecomm_bridge__ecomm_synced":{"type":["null","string"]},"number_of_multiple_endodontics":{"type":["null","number"]},"sakari_message_received_status":{"type":["null","string"]},"whathub_last_message_out_agent":{"type":["null","string"]},"csat_on_treatment_average_score":{"type":["null","number"]},"engagements_last_meeting_booked":{"type":["null","string"],"format":"date-time"},"hs_analytics_average_page_views":{"type":["null","number"]},"hs_feedback_show_nps_web_survey":{"type":["null","boolean"]},"hs_lifecyclestage_customer_date":{"type":["null","string"],"format":"date-time"},"hs_support_workflows_april_2021":{"type":["null","string"]},"ip__ecomm_bridge__source_app_id":{"type":["null","string"]},"prepworks_oral_hygiene__cloned_":{"type":["null","string"]},"sakari_message_received_message":{"type":["null","string"]},"cmo_prefieres_que_te_contactemos":{"type":["null","string"]},"dm_integration_patient_push_date":{"type":["null","string"],"format":"date"},"hs_email_hard_bounce_reason_enum":{"type":["null","string"]},"hs_last_sales_activity_timestamp":{"type":["null","string"],"format":"date-time"},"hs_latest_sequence_enrolled_date":{"type":["null","string"],"format":"date-time"},"hs_latest_sequence_finished_date":{"type":["null","string"],"format":"date-time"},"introduz_o_teu_nmero_de_telefone":{"type":["null","string"]},"marketing_qualified_lead_trigger":{"type":["null","string"]},"sakari_message_received_segments":{"type":["null","number"]},"whathub_last_message_synced_date":{"type":["null","string"],"format":"date-time"},"whathub_last_message_synced_full":{"type":["null","string"]},"cancelations_rescheduled_reasons_":{"type":["null","string"]},"confirmed_after_sms_same_day_push":{"type":["null","string"]},"csat_end_of_treatment_answer_date":{"type":["null","string"],"format":"date"},"dm_manual_switch_spreadsheet_date":{"type":["null","string"],"format":"date"},"hs_analytics_last_visit_timestamp":{"type":["null","string"],"format":"date-time"},"hs_date_exited_salesqualifiedlead":{"type":["null","string"],"format":"date-time"},"hs_first_subscription_create_date":{"type":["null","string"],"format":"date-time"},"hs_lifecyclestage_evangelist_date":{"type":["null","string"],"format":"date-time"},"hs_lifecyclestage_subscriber_date":{"type":["null","string"],"format":"date-time"},"hs_time_in_marketingqualifiedlead":{"type":["null","number"]},"ip__ecomm_bridge__source_store_id":{"type":["null","string"]},"qr_kit_received_confirmation_date":{"type":["null","string"],"format":"date"},"subscription_model_purchased_date":{"type":["null","string"],"format":"date"},"whathub_last_message_synced_agent":{"type":["null","string"]},"a_que_horas_prefere_ser_contactado":{"type":["null","string"]},"create_appointment_date___agents__":{"type":["null","string"],"format":"date"},"hs_analytics_first_visit_timestamp":{"type":["null","string"],"format":"date-time"},"hs_analytics_num_event_completions":{"type":["null","number"]},"hs_date_entered_salesqualifiedlead":{"type":["null","string"],"format":"date-time"},"hs_latest_sequence_unenrolled_date":{"type":["null","string"],"format":"date-time"},"hs_latest_subscription_create_date":{"type":["null","string"],"format":"date-time"},"hs_lifecyclestage_opportunity_date":{"type":["null","string"],"format":"date-time"},"hs_sa_first_engagement_object_type":{"type":["null","string"]},"csat_end_of_treatment_average_score":{"type":["null","number"]},"hs_content_membership_registered_at":{"type":["null","string"],"format":"date-time"},"inserisci_il_tuo_numero_di_telefono":{"type":["null","string"]},"sakari_message_received_destination":{"type":["null","string"]},"hs_calculated_phone_number_area_code":{"type":["null","string"]},"hs_email_customer_quarantined_reason":{"type":["null","string"]},"hs_email_sends_since_last_engagement":{"type":["null","number"]},"hs_sequences_actively_enrolled_count":{"type":["null","number"]},"number_of_complex_dental_restoration":{"type":["null","number"]},"prepworks_complex_dental_restoration":{"type":["null","string"]},"when_is_the_best_time_to_contact_you":{"type":["null","string"]},"wie_wrdest_du_deine_zhne_beschreiben":{"type":["null","string"]},"hs_content_membership_email_confirmed":{"type":["null","boolean"]},"hs_date_exited_marketingqualifiedlead":{"type":["null","string"],"format":"date-time"},"hs_searchable_calculated_phone_number":{"type":["null","string"]},"hs_time_to_move_from_lead_to_customer":{"type":["null","number"]},"qu_tipo_de_tratamiento_estas_buscando":{"type":["null","string"]},"avezvous_une_carte_didentit_franaise__":{"type":["null","string"]},"confirmed_after_sms_2_days_before_push":{"type":["null","string"]},"engagements_last_meeting_booked_medium":{"type":["null","string"]},"engagements_last_meeting_booked_source":{"type":["null","string"]},"hs_calculated_phone_number_region_code":{"type":["null","string"]},"hs_date_entered_marketingqualifiedlead":{"type":["null","string"],"format":"date-time"},"hs_searchable_calculated_mobile_number":{"type":["null","string"]},"sms_reminder_same_day_appointment_date":{"type":["null","string"],"format":"date"},"hs_calculated_phone_number_country_code":{"type":["null","string"]},"prepworks_multiple_endodontics__cloned_":{"type":["null","string"]},"realiza_una_foto_de_tu_oclusal_superior":{"type":["null","string"]},"engagements_last_meeting_booked_campaign":{"type":["null","string"]},"hs_email_recipient_fatigue_recovery_time":{"type":["null","string"],"format":"date-time"},"por_qual_canal_voc_prefere_ser_contatado":{"type":["null","string"]},"del_1al_5_cunto_deseas_mejorar_tu_sonrisa":{"type":["null","string"]},"hows_your_smile_affecting_your_confidence":{"type":["null","string"]},"hs_lifecyclestage_salesqualifiedlead_date":{"type":["null","string"],"format":"date-time"},"hs_user_ids_of_all_notification_followers":{"type":["null","string"]},"wann_mchtest_du_deinen_termin_vereinbaren":{"type":["null","string"]},"cuando_te_gustaria_empezar_el_tratamiento_":{"type":["null","string"]},"ip__sync_extension__external_source_app_id":{"type":["null","string"]},"bitte_teilen_sie_uns_ihren_wunschtermin_mit":{"type":["null","string"]},"ests_a_planear_utilizar_ortodontia_invisvel":{"type":["null","string"]},"hs_analytics_last_touch_converting_campaign":{"type":["null","string"]},"hs_time_to_move_from_subscriber_to_customer":{"type":["null","number"]},"hs_user_ids_of_all_notification_unfollowers":{"type":["null","string"]},"last_impress_marketing_status_modified_date":{"type":["null","string"],"format":"date"},"sms_reminder_2_days_before_appointment_date":{"type":["null","string"],"format":"date"},"ests_planeando_utilizar_ortodoncia_invisible":{"type":["null","string"]},"hs_analytics_first_touch_converting_campaign":{"type":["null","string"]},"hs_time_to_move_from_opportunity_to_customer":{"type":["null","number"]},"quando_voc_prefere_ter_sua_1_visita_gratuita":{"type":["null","string"]},"tesvous_intress_par_lorthodontie_invisible__":{"type":["null","string"]},"choose_which_option_best_describes_your_smile":{"type":["null","string"]},"estas_planeando_utilizar_ortodoncia_invisible":{"type":["null","string"]},"how_soon_would_you_like_to_start_your_journey":{"type":["null","string"]},"hs_lifecyclestage_marketingqualifiedlead_date":{"type":["null","string"],"format":"date-time"},"ip__sync_extension__external_source_account_id":{"type":["null","string"]},"que_souhaitezvous_amliorer_sur_votre_sourire__":{"type":["null","string"]},"received_version_same_day_appointment_sms_push":{"type":["null","string"]},"del_0_al_5_cuanto_te_gustara_mejorar_tu_sonrisa":{"type":["null","string"]},"dicci_quando_vorresti_avere_la_tua_prima_visita":{"type":["null","string"]},"hs_time_between_contact_creation_and_deal_close":{"type":["null","number"]},"conoces_las_ventajas_de_la_ortodoncia_invisible_":{"type":["null","string"]},"hs_content_membership_registration_email_sent_at":{"type":["null","string"],"format":"date-time"},"quando_voc_prefere_ter_sua_1_consulta_de_avaliao":{"type":["null","string"]},"que_opo_descreve_melhor_o_teu_sorriso_atualmente":{"type":["null","string"]},"where_do_you_want_to_book_your_free_consultation":{"type":["null","string"]},"hs_content_membership_registration_domain_sent_to":{"type":["null","string"]},"blog_default_hubspot_blog_10528869746_subscription":{"type":["null","string"]},"cuando_te_gustara_agendar_tu_primera_visita_gratis":{"type":["null","string"]},"hs_time_between_contact_creation_and_deal_creation":{"type":["null","number"]},"choose_which_option_best_describes_your_smile_today":{"type":["null","string"]},"hs_searchable_calculated_international_phone_number":{"type":["null","string"]},"hs_time_to_move_from_salesqualifiedlead_to_customer":{"type":["null","number"]},"cuando_te_gustara_agendar_tu_primera_visita_gratuita":{"type":["null","string"]},"descrivi_brevemente_laspetto_del_tuo_sorriso_attuale":{"type":["null","string"]},"hs_searchable_calculated_international_mobile_number":{"type":["null","string"]},"elige_que_opcin_describe_mejor_tu_sonrisa_actualmente":{"type":["null","string"]},"para_quien_ser_el_tratamiento_de_ortodoncia_invisible":{"type":["null","string"]},"wann_mchtest_du_deinen_kostenlosen_termin_vereinbaren":{"type":["null","string"]},"quelle_option_dcrit_le_mieux_votre_sourire_aujourdhui_":{"type":["null","string"]},"hs_time_to_move_from_marketingqualifiedlead_to_customer":{"type":["null","number"]},"has_iniciado_algun_otro_tratamiento_de_ortodoncia_antes_":{"type":["null","string"]},"quando_voc_prefere_ter_sua_1_consulta_de_avaliao_gratuita":{"type":["null","string"]},"quanto_ests_disposto_a_investir_para_alinhar_o_teu_sorriso":{"type":["null","string"]},"choisissez_loption_qui_dcrit_le_mieux_votre_sourire_actuel_":{"type":["null","string"]},"quanto_sei_disposto_a_investire_per_allineare_il_tuo_sorriso":{"type":["null","string"]},"ti_contatteremo_al_pi_presto_come_preferisci_che_lo_facciamo":{"type":["null","string"]},"del_0_al_5_cunto_te_gustara_mejorar_tu_sonrisa__0nada__5mucho":{"type":["null","string"]},"para_quien_buscas_hacer_el_tratamiento_de_ortodoncia_invisible":{"type":["null","string"]},"te_contactaremos_lo_antes_posible_cmo_prefieres_que_lo_hagamos":{"type":["null","string"]},"wie_wichtig_ist_dir_eine_zahnkorrektur_auf_einer_skala_von_110":{"type":["null","string"]},"escolhe_qual__a_opo_que_melhor_descreve_o_teu_sorriso_atualmente":{"type":["null","string"]},"whlen_sie_welche_option_ihr_heutiges_lcheln_am_besten_beschreibt":{"type":["null","string"]},"cual_de_esta_opciones_describe_mejor_tu_inquietud_sobre_tu_sonrisa":{"type":["null","string"]},"mchtest_du_deine_zhne_mit_unsichtbaren_alignern_korrigieren_lassen":{"type":["null","string"]},"welches_hauptziel_mochten_sie_mit_der_smilike_behandlung_erreichen_":{"type":["null","string"]},"ditesnous_quand_vous_souhaitez_planifier_votre_consultation_gratuite_":{"type":["null","string"]},"numa_escala_de_1_a_10_quo_importante_achas_que__corrigir_o_teu_sorriso":{"type":["null","string"]},"cual_es_el_principal_objetivo_que_esperas_conseguir_con_el_tratamiento_":{"type":["null","string"]},"we_will_contact_you_as_soon_as_possible_how_do_you_prefer_to_be_contacted":{"type":["null","string"]},"su_una_scala_da_1_a_10_quanto_ritieni_importante_correggere_il_tuo_sorriso":{"type":["null","string"]},"what_is_the_main_objective_you_hope_to_achieve_with_the_impress_treatment_":{"type":["null","string"]},"ests_interessado_em_utilizar_a_ortodontia_invisvel_para_melhorar_o_teu_sorriso":{"type":["null","string"]},"cual_es_el_principal_objetivo_que_esperas_conseguir_con_el_tratamiento_impress_":{"type":["null","string"]},"did_you_know_that_invisible_orthodontics_is_the_latest_tech_to_traditional_braces":{"type":["null","string"]},"qual_e__l__obbiettivo_principale_che_speri_di_ottenere_con_il_trattamento_impress_":{"type":["null","string"]},"wir_werden_dich_so_bald_wie_mglich_kontaktieren_wie_knnen_wir_dich_am_besten_erreichen":{"type":["null","string"]},"welches_hauptziel__mochten_sie_mit_einer_kieferorthopadischen_smilike_behandlung_erreichen_":{"type":["null","string"]},"escribe_tu_n__mero_de_tel__fono_abajo__o_toca_en_el_bot__n_si_es_correcto__y_te_llamaremos_lo_antes":{"type":["null","string"]},"escribe_tu_nmero_de_telfono_abajo_o_toca_en_el_botn_si_es_correcto_y_te_llamaremos_lo_antes_posible":{"type":["null","string"]},"quelles_sont_vos_disponibilits_ce_moisci_pour_visiter_nos_spcialistes_et_savoir_si_vous_tes_ligible":{"type":["null","string"]},"saviezvous_que_lorthodontie_invisible_est_la_dernire_technologie_en_date_pour_remplacer_les_gouttir":{"type":["null","string"]},"souhaitezvous_en_savoir_plus_sur_lorthodontie_invisible_ou_souhaitezvous_reserver_votre_premier_ren":{"type":["null","string"]},"what_is_your_availability_this_month_to_visit_our_specialists_and_find_out_if_you_are_elegible_firs":{"type":["null","string"]},"what_is_your_availability_this_month_to_visit_our_specialists_and_find_out_if_you_are_eligible_firs":{"type":["null","string"]}}}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updatedAt],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[updatedAt],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-08-18 07:49:10 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):312 - Stopping temporal heartbeating...