2022-02-17 09:01:00 INFO i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.35.11-alpha 2022-02-17 09:01:06 INFO i.a.w.t.TemporalAttemptExecution(get):118 - Docker volume job log path: /tmp/workspace/202/0/logs.log 2022-02-17 09:01:06 INFO i.a.w.t.TemporalAttemptExecution(get):123 - Executing worker wrapper. Airbyte version: 0.35.11-alpha 2022-02-17 09:01:06 WARN i.a.d.Databases(createPostgresDatabaseWithRetryTimeout):65 - Waiting for database to become available... 2022-02-17 09:01:06 INFO i.a.d.i.j.JobsDatabaseInstance(lambda$static$2):25 - Testing if jobs database is ready... 2022-02-17 09:01:06 INFO i.a.d.Databases(createPostgresDatabaseWithRetryTimeout):90 - Database available! 2022-02-17 09:01:06 INFO i.a.d.Databases(createPostgresDatabaseWithRetry):48 - Database available! 2022-02-17 09:01:06 INFO i.a.w.DefaultReplicationWorker(run):103 - start sync worker. job id: 202 attempt id: 0 2022-02-17 09:01:06 INFO i.a.w.DefaultReplicationWorker(run):115 - configured sync modes: {null.customers=incremental - append, null.products=incremental - append, null.abandoned_checkouts=incremental - append, null.orders=incremental - append, null.order_refunds=incremental - append} 2022-02-17 09:01:06 INFO i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination... 2022-02-17 09:01:06 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-redshift:0.3.23 exists... 2022-02-17 09:01:06 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-redshift:0.3.23 was found locally. 2022-02-17 09:01:06 INFO i.a.w.p.DockerProcessFactory(create):157 - Preparing command: docker run --rm --init -i -w /data/202/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local airbyte/destination-redshift:0.3.23 write --config destination_config.json --catalog destination_catalog.json 2022-02-17 09:01:06 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-shopify:0.1.26 exists... 2022-02-17 09:01:06 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-shopify:0.1.26 was found locally. 2022-02-17 09:01:06 INFO i.a.w.p.DockerProcessFactory(create):157 - Preparing command: docker run --rm --init -i -w /data/202/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local airbyte/source-shopify:0.1.26 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-02-17 09:01:06 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):307 - Destination output thread started. 2022-02-17 09:01:06 INFO i.a.w.DefaultReplicationWorker(run):147 - Waiting for source and destination threads to complete. 2022-02-17 09:01:06 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):268 - Replication thread started. 2022-02-17 09:01:06 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-02-17 09:01:06 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.16.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-02-17 09:01:06 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-02-17 09:01:06 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-02-17 09:01:07 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-02-17 09:01:07 source > Starting syncing SourceShopify 2022-02-17 09:01:07 source > Syncing stream: abandoned_checkouts 2022-02-17 09:01:07 source > Setting state of abandoned_checkouts stream to {'updated_at': '2022-02-16T02:24:54-05:00'} 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.d.r.RedshiftDestination(main):77 - {} - starting destination: class io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.b.IntegrationRunner(run):76 - {} - Running integration: io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - {} - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.b.IntegrationRunner(run):80 - {} - Command: WRITE 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.b.IntegrationRunner(run):81 - {} - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 WARN c.n.s.JsonMetaSchema(newValidator):338 - {} - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 WARN c.n.s.JsonMetaSchema(newValidator):338 - {} - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-02-17 09:01:08 destination > 2022-02-17 09:01:08 INFO i.a.i.d.j.c.SwitchingDestination(getConsumer):65 - {} - Using destination type: COPY_S3 2022-02-17 09:01:09 destination > 2022-02-17 09:01:09 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):125 - {} - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-02-17 09:01:30 source > Setting state of abandoned_checkouts stream to {'updated_at': '2022-02-17T03:34:59-05:00'} 2022-02-17 09:01:30 source > Read 110 records from abandoned_checkouts stream 2022-02-17 09:01:30 source > Finished syncing SourceShopify 2022-02-17 09:01:30 source > SourceShopify runtimes: 2022-02-17 09:01:30 source > Syncing stream: customers 2022-02-17 09:01:30 source > Setting state of customers stream to {'updated_at': '2022-02-16T03:38:19-05:00'} 2022-02-17 09:01:41 source > Setting state of customers stream to {'updated_at': '2022-02-16T16:09:54-05:00'} 2022-02-17 09:01:50 source > Setting state of customers stream to {'updated_at': '2022-02-17T03:34:59-05:00'} 2022-02-17 09:01:50 source > Read 423 records from customers stream 2022-02-17 09:01:50 source > Finished syncing SourceShopify 2022-02-17 09:01:50 source > SourceShopify runtimes: 2022-02-17 09:01:50 source > Syncing stream: orders 2022-02-17 09:01:50 source > Setting state of orders stream to {'updated_at': '2022-02-16T03:50:02-05:00'} 2022-02-17 09:01:53 source > Setting state of orders stream to {'updated_at': '2022-02-16T13:15:04-05:00'} 2022-02-17 09:01:56 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):281 - Records read: 1000 2022-02-17 09:01:56 source > Setting state of orders stream to {'updated_at': '2022-02-16T15:16:30-05:00'} 2022-02-17 09:01:59 source > Setting state of orders stream to {'updated_at': '2022-02-16T17:48:32-05:00'} 2022-02-17 09:02:01 source > Setting state of orders stream to {'updated_at': '2022-02-16T19:28:52-05:00'} 2022-02-17 09:02:07 source > Setting state of orders stream to {'updated_at': '2022-02-17T04:00:30-05:00'} 2022-02-17 09:02:07 source > Read 1217 records from orders stream 2022-02-17 09:02:07 source > Finished syncing SourceShopify 2022-02-17 09:02:07 source > SourceShopify runtimes: 2022-02-17 09:02:07 source > Syncing stream: order_refunds 2022-02-17 09:02:07 source > Setting state of order_refunds stream to {'created_at': '2022-02-15T16:26:44-05:00'} 2022-02-17 09:02:08 source > Reading order_refunds for order_id: 4217208078411 2022-02-17 09:02:08 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T08:29:07-05:00'} 2022-02-17 09:02:08 source > Reading order_refunds for order_id: 4254292148299 2022-02-17 09:02:09 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T08:48:08-05:00'} 2022-02-17 09:02:09 source > Reading order_refunds for order_id: 4253855580235 2022-02-17 09:02:10 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T08:50:14-05:00'} 2022-02-17 09:02:10 source > Reading order_refunds for order_id: 4121480331339 2022-02-17 09:02:10 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T08:50:14-05:00'} 2022-02-17 09:02:10 source > Reading order_refunds for order_id: 4269729448011 2022-02-17 09:02:11 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T08:57:19-05:00'} 2022-02-17 09:02:11 source > Reading order_refunds for order_id: 4262656639051 2022-02-17 09:02:11 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T09:18:03-05:00'} 2022-02-17 09:02:11 source > Reading order_refunds for order_id: 4223559139403 2022-02-17 09:02:12 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T09:46:30-05:00'} 2022-02-17 09:02:12 source > Reading order_refunds for order_id: 4001464746059 2022-02-17 09:02:13 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T09:46:30-05:00'} 2022-02-17 09:02:13 source > Reading order_refunds for order_id: 4006365855819 2022-02-17 09:02:13 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T09:46:30-05:00'} 2022-02-17 09:02:13 source > Reading order_refunds for order_id: 4220964765771 2022-02-17 09:02:14 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:19:49-05:00'} 2022-02-17 09:02:14 source > Reading order_refunds for order_id: 4147091603531 2022-02-17 09:02:14 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:19:49-05:00'} 2022-02-17 09:02:14 source > Reading order_refunds for order_id: 4115228688459 2022-02-17 09:02:15 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:26:36-05:00'} 2022-02-17 09:02:15 source > Reading order_refunds for order_id: 4066504867915 2022-02-17 09:02:16 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:27:18-05:00'} 2022-02-17 09:02:16 source > Reading order_refunds for order_id: 4262932971595 2022-02-17 09:02:16 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:28:33-05:00'} 2022-02-17 09:02:16 source > Reading order_refunds for order_id: 4105253716043 2022-02-17 09:02:17 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:30:19-05:00'} 2022-02-17 09:02:17 source > Reading order_refunds for order_id: 4266637459531 2022-02-17 09:02:17 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:30:44-05:00'} 2022-02-17 09:02:17 source > Reading order_refunds for order_id: 4265732079691 2022-02-17 09:02:18 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:32:22-05:00'} 2022-02-17 09:02:18 source > Reading order_refunds for order_id: 4244850966603 2022-02-17 09:02:19 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:36:26-05:00'} 2022-02-17 09:02:19 source > Reading order_refunds for order_id: 4139768807499 2022-02-17 09:02:19 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:37:16-05:00'} 2022-02-17 09:02:19 source > Reading order_refunds for order_id: 4230649708619 2022-02-17 09:02:20 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T10:43:21-05:00'} 2022-02-17 09:02:20 source > Reading order_refunds for order_id: 4226377711691 2022-02-17 09:02:20 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:09:50-05:00'} 2022-02-17 09:02:20 source > Reading order_refunds for order_id: 4024603246667 2022-02-17 09:02:21 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:09:50-05:00'} 2022-02-17 09:02:21 source > Reading order_refunds for order_id: 4270579777611 2022-02-17 09:02:21 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:24:49-05:00'} 2022-02-17 09:02:21 source > Reading order_refunds for order_id: 4281716539467 2022-02-17 09:02:22 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:24:49-05:00'} 2022-02-17 09:02:22 source > Reading order_refunds for order_id: 4266644013131 2022-02-17 09:02:23 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:42:01-05:00'} 2022-02-17 09:02:23 source > Reading order_refunds for order_id: 4256539279435 2022-02-17 09:02:23 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:49:23-05:00'} 2022-02-17 09:02:23 source > Reading order_refunds for order_id: 4276617183307 2022-02-17 09:02:24 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:49:26-05:00'} 2022-02-17 09:02:24 source > Reading order_refunds for order_id: 4116045234251 2022-02-17 09:02:24 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:50:16-05:00'} 2022-02-17 09:02:24 source > Reading order_refunds for order_id: 4138534535243 2022-02-17 09:02:25 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:51:59-05:00'} 2022-02-17 09:02:25 source > Reading order_refunds for order_id: 4139280072779 2022-02-17 09:02:25 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:52:48-05:00'} 2022-02-17 09:02:25 source > Reading order_refunds for order_id: 4270284669003 2022-02-17 09:02:26 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T11:53:44-05:00'} 2022-02-17 09:02:26 source > Reading order_refunds for order_id: 4263351844939 2022-02-17 09:02:27 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:11:12-05:00'} 2022-02-17 09:02:27 source > Reading order_refunds for order_id: 4140606259275 2022-02-17 09:02:27 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:12:44-05:00'} 2022-02-17 09:02:27 source > Reading order_refunds for order_id: 4151190782027 2022-02-17 09:02:28 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:16:08-05:00'} 2022-02-17 09:02:28 source > Reading order_refunds for order_id: 4138157572171 2022-02-17 09:02:28 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:16:24-05:00'} 2022-02-17 09:02:28 source > Reading order_refunds for order_id: 4254947868747 2022-02-17 09:02:29 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:22:51-05:00'} 2022-02-17 09:02:29 source > Reading order_refunds for order_id: 4192602095691 2022-02-17 09:02:30 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:28:04-05:00'} 2022-02-17 09:02:30 source > Reading order_refunds for order_id: 4262445285451 2022-02-17 09:02:30 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:42:21-05:00'} 2022-02-17 09:02:30 source > Reading order_refunds for order_id: 4223472435275 2022-02-17 09:02:31 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:45:38-05:00'} 2022-02-17 09:02:31 source > Reading order_refunds for order_id: 4249492226123 2022-02-17 09:02:31 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:46:56-05:00'} 2022-02-17 09:02:31 source > Reading order_refunds for order_id: 4220096806987 2022-02-17 09:02:32 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:47:21-05:00'} 2022-02-17 09:02:32 source > Reading order_refunds for order_id: 4278669574219 2022-02-17 09:02:32 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:47:21-05:00'} 2022-02-17 09:02:32 source > Reading order_refunds for order_id: 4223303254091 2022-02-17 09:02:33 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T12:50:54-05:00'} 2022-02-17 09:02:33 source > Reading order_refunds for order_id: 4053182087243 2022-02-17 09:02:34 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:12:24-05:00'} 2022-02-17 09:02:35 source > Reading order_refunds for order_id: 4216668389451 2022-02-17 09:02:35 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:17:57-05:00'} 2022-02-17 09:02:35 source > Reading order_refunds for order_id: 4279024123979 2022-02-17 09:02:36 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:17:57-05:00'} 2022-02-17 09:02:36 source > Reading order_refunds for order_id: 4146368774219 2022-02-17 09:02:36 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:17:57-05:00'} 2022-02-17 09:02:36 source > Reading order_refunds for order_id: 4212055179339 2022-02-17 09:02:37 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:22:50-05:00'} 2022-02-17 09:02:37 source > Reading order_refunds for order_id: 4139132846155 2022-02-17 09:02:39 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:41:02-05:00'} 2022-02-17 09:02:39 source > Reading order_refunds for order_id: 4264613544011 2022-02-17 09:02:40 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T13:55:49-05:00'} 2022-02-17 09:02:40 source > Reading order_refunds for order_id: 4194946842699 2022-02-17 09:02:40 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:02:10-05:00'} 2022-02-17 09:02:40 source > Reading order_refunds for order_id: 4179497746507 2022-02-17 09:02:41 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:02:13-05:00'} 2022-02-17 09:02:41 source > Reading order_refunds for order_id: 4265317662795 2022-02-17 09:02:42 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:06:40-05:00'} 2022-02-17 09:02:42 source > Reading order_refunds for order_id: 4216966611019 2022-02-17 09:02:42 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:21:06-05:00'} 2022-02-17 09:02:42 source > Reading order_refunds for order_id: 4261409325131 2022-02-17 09:02:43 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:21:09-05:00'} 2022-02-17 09:02:43 source > Reading order_refunds for order_id: 4279036411979 2022-02-17 09:02:43 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:21:09-05:00'} 2022-02-17 09:02:43 source > Reading order_refunds for order_id: 4259646701643 2022-02-17 09:02:44 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T14:29:18-05:00'} 2022-02-17 09:02:45 source > Reading order_refunds for order_id: 4286343872587 2022-02-17 09:02:45 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T15:24:39-05:00'} 2022-02-17 09:02:45 source > Reading order_refunds for order_id: 4279078551627 2022-02-17 09:02:46 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T15:24:39-05:00'} 2022-02-17 09:02:46 source > Reading order_refunds for order_id: 4278999285835 2022-02-17 09:02:47 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T15:24:39-05:00'} 2022-02-17 09:02:48 source > Reading order_refunds for order_id: 4280216125515 2022-02-17 09:02:48 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T15:24:39-05:00'} 2022-02-17 09:02:48 source > Reading order_refunds for order_id: 4189700980811 2022-02-17 09:02:49 source > Setting state of order_refunds stream to {'created_at': '2022-02-16T15:24:39-05:00'} 2022-02-17 09:02:51 source > Reading order_refunds for order_id: 4095014207563 2022-02-17 09:02:52 source > Setting state of order_refunds stream to {'created_at': '2022-02-17T02:30:46-05:00'} 2022-02-17 09:02:52 source > Read 49 records from order_refunds stream 2022-02-17 09:02:52 source > Finished syncing SourceShopify 2022-02-17 09:02:52 source > SourceShopify runtimes: 2022-02-17 09:02:52 source > Syncing stream: products 2022-02-17 09:02:52 source > Setting state of products stream to {'updated_at': '2022-02-16T03:40:26-05:00'} 2022-02-17 09:02:53 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):281 - Records read: 2000 2022-02-17 09:02:53 source > Setting state of products stream to {'updated_at': '2022-02-17T00:45:47-05:00'} 2022-02-17 09:02:54 source > Setting state of products stream to {'updated_at': '2022-02-17T03:15:23-05:00'} 2022-02-17 09:02:54 source > Read 285 records from products stream 2022-02-17 09:02:54 source > Finished syncing SourceShopify 2022-02-17 09:02:54 source > SourceShopify runtimes: 2022-02-17 09:02:54 source > Finished syncing SourceShopify 2022-02-17 09:02:54 INFO i.a.w.DefaultReplicationWorker(run):152 - One of source or destination thread complete. Waiting on the other. 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):60 - {} - Airbyte message consumer: succeeded. 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 WARN i.a.i.d.b.BufferedStreamConsumer(lambda$close$0):196 - {} - A total of 5 record(s) of data from stream AirbyteStreamNameNamespacePair{name='shopify_orders', namespace='null'} were invalid and were ignored. 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 WARN i.a.i.d.b.BufferedStreamConsumer(lambda$close$0):196 - {} - A total of 1 record(s) of data from stream AirbyteStreamNameNamespacePair{name='shopify_products', namespace='null'} were invalid and were ignored. 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO i.a.i.d.b.BufferedStreamConsumer(close):200 - {} - executing on success close procedure. 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO i.a.i.d.j.c.s.S3StreamCopier(prepareStagingFile):95 - {} - S3 upload part size: 10 MB 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO i.a.i.d.s.c.S3CsvWriter():56 - {} - Full S3 path for stream 'shopify_abandoned_checkouts': s3://airbyte-staging/targetschema/shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO i.a.i.d.s.u.S3StreamTransferManagerHelper(getDefault):55 - {} - PartSize arg is set to 10 MB 2022-02-17 09:02:54 destination > 2022-02-17 09:02:54 INFO a.m.s.StreamTransferManager(getMultiPartOutputStreams):329 - {} - Initiated multipart upload to airbyte-staging/targetschema/shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv with full ID njFoL34jr_aGi3At5lafK6j9QyZkolygol21UCmWKCDhqHa1FgqpqcxwWu9qFSpD7Gl573v8DZWUUm_9dQ7Cd9ZAU5rHWmBjw8Q0uKlgvrrtCCNk.0M4vTJIWRltOmel 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.j.c.s.S3StreamCopier(prepareStagingFile):95 - {} - S3 upload part size: 10 MB 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.s.c.S3CsvWriter():56 - {} - Full S3 path for stream 'shopify_order_refunds': s3://airbyte-staging/targetschema/shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.s.u.S3StreamTransferManagerHelper(getDefault):55 - {} - PartSize arg is set to 10 MB 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO a.m.s.StreamTransferManager(getMultiPartOutputStreams):329 - {} - Initiated multipart upload to airbyte-staging/targetschema/shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv with full ID NZBM76LbV_cgzqZ50bH7_99tm23._ioeSgxnsVv.8PD5.qj7DGOpgv7dq.CheujlkLG_Mb.F2xqfmcUp5_CWYYI.ykLDB6IVwNW74QI3hVJnO5fVvu5rsRK10Wqf9mOY 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.j.c.s.S3StreamCopier(prepareStagingFile):95 - {} - S3 upload part size: 10 MB 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.s.c.S3CsvWriter():56 - {} - Full S3 path for stream 'shopify_orders': s3://airbyte-staging/targetschema/shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO i.a.i.d.s.u.S3StreamTransferManagerHelper(getDefault):55 - {} - PartSize arg is set to 10 MB 2022-02-17 09:02:55 destination > 2022-02-17 09:02:55 INFO a.m.s.StreamTransferManager(getMultiPartOutputStreams):329 - {} - Initiated multipart upload to airbyte-staging/targetschema/shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv with full ID vBgHDr8X3CMOnrCvZZ_a9pBewiRJkp3ZlP1DvgbX9zWXltdom_cMxBdkxL__rSRo5WQP4aiYqz3VjixHuW.LNkTiuFjt3dekau2SPYx22wEOxpG7hr1C3TqGkckJ9nat 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.j.c.s.S3StreamCopier(prepareStagingFile):95 - {} - S3 upload part size: 10 MB 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.c.S3CsvWriter():56 - {} - Full S3 path for stream 'shopify_products': s3://airbyte-staging/targetschema/shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.u.S3StreamTransferManagerHelper(getDefault):55 - {} - PartSize arg is set to 10 MB 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(getMultiPartOutputStreams):329 - {} - Initiated multipart upload to airbyte-staging/targetschema/shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv with full ID dyVMie_A8hduWhHdLrVMdJ974XfCDCEioIJa1xNGY4ZGn6P1n5AB_xcWfV8ffkLotoNqduyXjS1.11OC6SS1Q0S84UvhUHzpQS7jeLElV6BiTLiTbFqs9aVM9r6tIq74 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.j.c.s.S3StreamCopier(prepareStagingFile):95 - {} - S3 upload part size: 10 MB 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.c.S3CsvWriter():56 - {} - Full S3 path for stream 'shopify_customers': s3://airbyte-staging/targetschema/shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.u.S3StreamTransferManagerHelper(getDefault):55 - {} - PartSize arg is set to 10 MB 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(getMultiPartOutputStreams):329 - {} - Initiated multipart upload to airbyte-staging/targetschema/shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv with full ID f2GAIzKbIqBjn2_aF4QlmzS5.SVWQE220WgHq8jDK2yD3duBCQrhjqL55AEML_kIL89jz3zGU5atN.F8roVW_DSsfO3RuymqYyjJH1vF_.M9uODQHoyTDa.SB_l1eHQS 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.w.BaseS3Writer(close):107 - {} - Uploading remaining data for stream 'shopify_abandoned_checkouts'. 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 WARN a.m.s.MultiPartOutputStream(close):160 - {} - [MultipartOutputStream for parts 1 - 10000] is already closed 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(complete):367 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv with id njFoL34jr...IWRltOmel]: Uploading leftover stream [Part number 1 containing 0.56 MB] 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv with id vBgHDr8X3...GkckJ9nat]: Finished uploading [Part number 1 containing 10.01 MB] 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv with id njFoL34jr...IWRltOmel]: Finished uploading [Part number 1 containing 0.56 MB] 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO a.m.s.StreamTransferManager(complete):395 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv with id njFoL34jr...IWRltOmel]: Completed 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.s.w.BaseS3Writer(close):109 - {} - Upload completed for stream 'shopify_abandoned_checkouts'. 2022-02-17 09:02:56 destination > 2022-02-17 09:02:56 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationSchema):137 - {} - Creating schema in destination if it doesn't exist: targetschema 2022-02-17 09:02:57 destination > 2022-02-17 09:02:57 INFO i.a.i.d.j.c.s.S3StreamCopier(createTemporaryTable):143 - {} - Preparing tmp table in destination for stream: shopify_abandoned_checkouts, schema: targetschema, tmp table name: _airbyte_tmp_kbc_shopify_abandoned_checkouts. 2022-02-17 09:02:57 destination > 2022-02-17 09:02:57 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):85 - {} - Starting copy to tmp table: _airbyte_tmp_kbc_shopify_abandoned_checkouts in destination for stream: shopify_abandoned_checkouts, schema: targetschema, . 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):89 - {} - Copy to tmp table _airbyte_tmp_kbc_shopify_abandoned_checkouts in destination for stream shopify_abandoned_checkouts complete. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):160 - {} - Preparing table _airbyte_raw_shopify_abandoned_checkouts in destination. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):162 - {} - Table _airbyte_tmp_kbc_shopify_abandoned_checkouts in destination prepared. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.j.c.s.S3StreamCopier(generateMergeStatement):169 - {} - Preparing to merge tmp table _airbyte_tmp_kbc_shopify_abandoned_checkouts to dest table: _airbyte_raw_shopify_abandoned_checkouts, schema: targetschema, in destination. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.s.w.BaseS3Writer(close):107 - {} - Uploading remaining data for stream 'shopify_order_refunds'. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 WARN a.m.s.MultiPartOutputStream(close):160 - {} - [MultipartOutputStream for parts 1 - 10000] is already closed 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO a.m.s.StreamTransferManager(complete):367 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv with id NZBM76LbV...10Wqf9mOY]: Uploading leftover stream [Part number 1 containing 0.32 MB] 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv with id NZBM76LbV...10Wqf9mOY]: Finished uploading [Part number 1 containing 0.32 MB] 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO a.m.s.StreamTransferManager(complete):395 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv with id NZBM76LbV...10Wqf9mOY]: Completed 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.s.w.BaseS3Writer(close):109 - {} - Upload completed for stream 'shopify_order_refunds'. 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationSchema):137 - {} - Creating schema in destination if it doesn't exist: targetschema 2022-02-17 09:02:58 destination > 2022-02-17 09:02:58 INFO i.a.i.d.j.c.s.S3StreamCopier(createTemporaryTable):143 - {} - Preparing tmp table in destination for stream: shopify_order_refunds, schema: targetschema, tmp table name: _airbyte_tmp_nin_shopify_order_refunds. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):85 - {} - Starting copy to tmp table: _airbyte_tmp_nin_shopify_order_refunds in destination for stream: shopify_order_refunds, schema: targetschema, . 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):89 - {} - Copy to tmp table _airbyte_tmp_nin_shopify_order_refunds in destination for stream shopify_order_refunds complete. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):160 - {} - Preparing table _airbyte_raw_shopify_order_refunds in destination. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):162 - {} - Table _airbyte_tmp_nin_shopify_order_refunds in destination prepared. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.j.c.s.S3StreamCopier(generateMergeStatement):169 - {} - Preparing to merge tmp table _airbyte_tmp_nin_shopify_order_refunds to dest table: _airbyte_raw_shopify_order_refunds, schema: targetschema, in destination. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO i.a.i.d.s.w.BaseS3Writer(close):107 - {} - Uploading remaining data for stream 'shopify_orders'. 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:02:59 destination > 2022-02-17 09:02:59 WARN a.m.s.MultiPartOutputStream(close):160 - {} - [MultipartOutputStream for parts 1 - 10000] is already closed 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv with id vBgHDr8X3...GkckJ9nat]: Finished uploading [Part number 2 containing 11.62 MB] 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO a.m.s.StreamTransferManager(complete):395 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv with id vBgHDr8X3...GkckJ9nat]: Completed 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO i.a.i.d.s.w.BaseS3Writer(close):109 - {} - Upload completed for stream 'shopify_orders'. 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationSchema):137 - {} - Creating schema in destination if it doesn't exist: targetschema 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO i.a.i.d.j.c.s.S3StreamCopier(createTemporaryTable):143 - {} - Preparing tmp table in destination for stream: shopify_orders, schema: targetschema, tmp table name: _airbyte_tmp_vcf_shopify_orders. 2022-02-17 09:03:00 destination > 2022-02-17 09:03:00 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):85 - {} - Starting copy to tmp table: _airbyte_tmp_vcf_shopify_orders in destination for stream: shopify_orders, schema: targetschema, . 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):89 - {} - Copy to tmp table _airbyte_tmp_vcf_shopify_orders in destination for stream shopify_orders complete. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):160 - {} - Preparing table _airbyte_raw_shopify_orders in destination. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):162 - {} - Table _airbyte_tmp_vcf_shopify_orders in destination prepared. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.j.c.s.S3StreamCopier(generateMergeStatement):169 - {} - Preparing to merge tmp table _airbyte_tmp_vcf_shopify_orders to dest table: _airbyte_raw_shopify_orders, schema: targetschema, in destination. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.s.w.BaseS3Writer(close):107 - {} - Uploading remaining data for stream 'shopify_products'. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 WARN a.m.s.MultiPartOutputStream(close):160 - {} - [MultipartOutputStream for parts 1 - 10000] is already closed 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO a.m.s.StreamTransferManager(complete):367 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv with id dyVMie_A8...M9r6tIq74]: Uploading leftover stream [Part number 1 containing 3.81 MB] 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv with id dyVMie_A8...M9r6tIq74]: Finished uploading [Part number 1 containing 3.81 MB] 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO a.m.s.StreamTransferManager(complete):395 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv with id dyVMie_A8...M9r6tIq74]: Completed 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.s.w.BaseS3Writer(close):109 - {} - Upload completed for stream 'shopify_products'. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationSchema):137 - {} - Creating schema in destination if it doesn't exist: targetschema 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.j.c.s.S3StreamCopier(createTemporaryTable):143 - {} - Preparing tmp table in destination for stream: shopify_products, schema: targetschema, tmp table name: _airbyte_tmp_vuy_shopify_products. 2022-02-17 09:03:02 destination > 2022-02-17 09:03:02 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):85 - {} - Starting copy to tmp table: _airbyte_tmp_vuy_shopify_products in destination for stream: shopify_products, schema: targetschema, . 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):89 - {} - Copy to tmp table _airbyte_tmp_vuy_shopify_products in destination for stream shopify_products complete. 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):160 - {} - Preparing table _airbyte_raw_shopify_products in destination. 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):162 - {} - Table _airbyte_tmp_vuy_shopify_products in destination prepared. 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO i.a.i.d.j.c.s.S3StreamCopier(generateMergeStatement):169 - {} - Preparing to merge tmp table _airbyte_tmp_vuy_shopify_products to dest table: _airbyte_raw_shopify_products, schema: targetschema, in destination. 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO i.a.i.d.s.w.BaseS3Writer(close):107 - {} - Uploading remaining data for stream 'shopify_customers'. 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO a.m.s.MultiPartOutputStream(close):158 - {} - Called close() on [MultipartOutputStream for parts 1 - 10000] 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 WARN a.m.s.MultiPartOutputStream(close):160 - {} - [MultipartOutputStream for parts 1 - 10000] is already closed 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO a.m.s.StreamTransferManager(complete):367 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv with id f2GAIzKbI...SB_l1eHQS]: Uploading leftover stream [Part number 1 containing 1.09 MB] 2022-02-17 09:03:03 destination > 2022-02-17 09:03:03 INFO a.m.s.StreamTransferManager(uploadStreamPart):558 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv with id f2GAIzKbI...SB_l1eHQS]: Finished uploading [Part number 1 containing 1.09 MB] 2022-02-17 09:03:04 destination > 2022-02-17 09:03:04 INFO a.m.s.StreamTransferManager(complete):395 - {} - [Manager uploading to airbyte-staging/targetschema/shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv with id f2GAIzKbI...SB_l1eHQS]: Completed 2022-02-17 09:03:04 destination > 2022-02-17 09:03:04 INFO i.a.i.d.s.w.BaseS3Writer(close):109 - {} - Upload completed for stream 'shopify_customers'. 2022-02-17 09:03:04 destination > 2022-02-17 09:03:04 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationSchema):137 - {} - Creating schema in destination if it doesn't exist: targetschema 2022-02-17 09:03:04 destination > 2022-02-17 09:03:04 INFO i.a.i.d.j.c.s.S3StreamCopier(createTemporaryTable):143 - {} - Preparing tmp table in destination for stream: shopify_customers, schema: targetschema, tmp table name: _airbyte_tmp_dkx_shopify_customers. 2022-02-17 09:03:04 destination > 2022-02-17 09:03:04 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):85 - {} - Starting copy to tmp table: _airbyte_tmp_dkx_shopify_customers in destination for stream: shopify_customers, schema: targetschema, . 2022-02-17 09:03:05 destination > 2022-02-17 09:03:05 INFO i.a.i.d.r.RedshiftStreamCopier(copyStagingFileToTemporaryTable):89 - {} - Copy to tmp table _airbyte_tmp_dkx_shopify_customers in destination for stream shopify_customers complete. 2022-02-17 09:03:05 destination > 2022-02-17 09:03:05 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):160 - {} - Preparing table _airbyte_raw_shopify_customers in destination. 2022-02-17 09:03:06 destination > 2022-02-17 09:03:06 INFO i.a.i.d.j.c.s.S3StreamCopier(createDestinationTable):162 - {} - Table _airbyte_tmp_dkx_shopify_customers in destination prepared. 2022-02-17 09:03:06 destination > 2022-02-17 09:03:06 INFO i.a.i.d.j.c.s.S3StreamCopier(generateMergeStatement):169 - {} - Preparing to merge tmp table _airbyte_tmp_dkx_shopify_customers to dest table: _airbyte_raw_shopify_customers, schema: targetschema, in destination. 2022-02-17 09:03:09 destination > 2022-02-17 09:03:09 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):186 - {} - Begin cleaning s3 staging file shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv. 2022-02-17 09:03:09 destination > 2022-02-17 09:03:09 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):190 - {} - S3 staging file shopify_abandoned_checkouts/2022_02_17_1645088469274_de6abb23-a285-4b4d-8040-db57d87c01d7.csv cleaned. 2022-02-17 09:03:09 destination > 2022-02-17 09:03:09 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):194 - {} - Begin cleaning _airbyte_tmp_kbc_shopify_abandoned_checkouts tmp table in destination. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):196 - {} - _airbyte_tmp_kbc_shopify_abandoned_checkouts tmp table in destination cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):105 - {} - Begin cleaning s3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/f828f044-c772-49b0-84cc-44e7671a292b.manifest. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):109 - {} - S3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/f828f044-c772-49b0-84cc-44e7671a292b.manifest cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):186 - {} - Begin cleaning s3 staging file shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):190 - {} - S3 staging file shopify_order_refunds/2022_02_17_1645088469280_b11b9ee9-328f-4b3c-b907-ac4800b82420.csv cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):194 - {} - Begin cleaning _airbyte_tmp_nin_shopify_order_refunds tmp table in destination. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):196 - {} - _airbyte_tmp_nin_shopify_order_refunds tmp table in destination cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):105 - {} - Begin cleaning s3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/2939d3f8-d296-4d5b-b49a-b723bfb33165.manifest. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):109 - {} - S3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/2939d3f8-d296-4d5b-b49a-b723bfb33165.manifest cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):186 - {} - Begin cleaning s3 staging file shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):190 - {} - S3 staging file shopify_orders/2022_02_17_1645088469279_c3b45cc0-718a-4e75-bc5d-0d9a2d36e94a.csv cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):194 - {} - Begin cleaning _airbyte_tmp_vcf_shopify_orders tmp table in destination. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):196 - {} - _airbyte_tmp_vcf_shopify_orders tmp table in destination cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):105 - {} - Begin cleaning s3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/70c0819d-916c-4a15-982f-84719ff48c24.manifest. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):109 - {} - S3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/70c0819d-916c-4a15-982f-84719ff48c24.manifest cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):186 - {} - Begin cleaning s3 staging file shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):190 - {} - S3 staging file shopify_products/2022_02_17_1645088469282_39192882-fe21-4f41-a00f-cb13810b6a63.csv cleaned. 2022-02-17 09:03:10 destination > 2022-02-17 09:03:10 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):194 - {} - Begin cleaning _airbyte_tmp_vuy_shopify_products tmp table in destination. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):196 - {} - _airbyte_tmp_vuy_shopify_products tmp table in destination cleaned. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):105 - {} - Begin cleaning s3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/1a6d0e86-110e-41ed-92e5-139dd055d91c.manifest. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):109 - {} - S3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/1a6d0e86-110e-41ed-92e5-139dd055d91c.manifest cleaned. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):186 - {} - Begin cleaning s3 staging file shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):190 - {} - S3 staging file shopify_customers/2022_02_17_1645088469278_9a4a2fae-65a6-48b1-879a-2e5a17385e3c.csv cleaned. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):194 - {} - Begin cleaning _airbyte_tmp_dkx_shopify_customers tmp table in destination. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.j.c.s.S3StreamCopier(removeFileAndDropTmpTable):196 - {} - _airbyte_tmp_dkx_shopify_customers tmp table in destination cleaned. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):105 - {} - Begin cleaning s3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/fdf2a842-cfd5-4345-843f-211ccb5e4f20.manifest. 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.r.RedshiftStreamCopier(removeFileAndDropTmpTable):109 - {} - S3 manifest file null/bdb491e6-c637-47bd-b7c9-7c168156dc6d/targetschema/fdf2a842-cfd5-4345-843f-211ccb5e4f20.manifest cleaned. 2022-02-17 09:03:11 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):312 - state in DefaultReplicationWorker from Destination: io.airbyte.protocol.models.AirbyteMessage@22c6c5e3[type=STATE,log=,spec=,connectionStatus=,catalog=,record=,state=io.airbyte.protocol.models.AirbyteStateMessage@2c012fcb[data={"orders":{"updated_at":"2022-02-17T04:00:30-05:00"},"products":{"updated_at":"2022-02-17T03:15:23-05:00"},"customers":{"updated_at":"2022-02-17T03:34:59-05:00"},"order_refunds":{"created_at":"2022-02-17T02:30:46-05:00"},"abandoned_checkouts":{"updated_at":"2022-02-17T03:34:59-05:00"}},additionalProperties={}],additionalProperties={}] 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.b.IntegrationRunner(run):133 - {} - Completed integration: io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-02-17 09:03:11 destination > 2022-02-17 09:03:11 INFO i.a.i.d.r.RedshiftDestination(main):79 - {} - completed destination: class io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-02-17 09:03:11 INFO i.a.w.DefaultReplicationWorker(run):154 - Source and destination threads complete. 2022-02-17 09:03:11 INFO i.a.w.DefaultReplicationWorker(run):217 - sync summary: io.airbyte.config.ReplicationAttemptSummary@23c9c09[status=completed,recordsSynced=2084,bytesSynced=25861286,startTime=1645088466125,endTime=1645088591991,totalStats=io.airbyte.config.SyncStats@1d177ce4[recordsEmitted=2084,bytesEmitted=25861286,stateMessagesEmitted=73,recordsCommitted=2084],streamStats=[io.airbyte.config.StreamSyncStats@615d2d18[streamName=shopify_abandoned_checkouts,stats=io.airbyte.config.SyncStats@159e6142[recordsEmitted=110,bytesEmitted=522272,stateMessagesEmitted=,recordsCommitted=110]], io.airbyte.config.StreamSyncStats@73247b2c[streamName=shopify_customers,stats=io.airbyte.config.SyncStats@5572c9f0[recordsEmitted=423,bytesEmitted=972989,stateMessagesEmitted=,recordsCommitted=423]], io.airbyte.config.StreamSyncStats@5d4f1bab[streamName=shopify_products,stats=io.airbyte.config.SyncStats@3bbdf531[recordsEmitted=285,bytesEmitted=3683190,stateMessagesEmitted=,recordsCommitted=285]], io.airbyte.config.StreamSyncStats@6b901471[streamName=shopify_orders,stats=io.airbyte.config.SyncStats@286e7dba[recordsEmitted=1217,bytesEmitted=20392260,stateMessagesEmitted=,recordsCommitted=1217]], io.airbyte.config.StreamSyncStats@dd9a95f[streamName=shopify_order_refunds,stats=io.airbyte.config.SyncStats@5919c1a8[recordsEmitted=49,bytesEmitted=290575,stateMessagesEmitted=,recordsCommitted=49]]]] 2022-02-17 09:03:11 INFO i.a.w.DefaultReplicationWorker(run):237 - Source output at least one state message 2022-02-17 09:03:11 INFO i.a.w.DefaultReplicationWorker(run):243 - State capture: Updated state to: Optional[io.airbyte.config.State@32417566[state={"orders":{"updated_at":"2022-02-17T04:00:30-05:00"},"products":{"updated_at":"2022-02-17T03:15:23-05:00"},"customers":{"updated_at":"2022-02-17T03:34:59-05:00"},"order_refunds":{"created_at":"2022-02-17T02:30:46-05:00"},"abandoned_checkouts":{"updated_at":"2022-02-17T03:34:59-05:00"}}]] 2022-02-17 09:03:11 INFO i.a.w.t.TemporalAttemptExecution(get):144 - Stopping cancellation check scheduling... 2022-02-17 09:03:11 INFO i.a.w.t.s.ReplicationActivityImpl(replicate):147 - sync summary: io.airbyte.config.StandardSyncOutput@73dbea96[standardSyncSummary=io.airbyte.config.StandardSyncSummary@165aa73a[status=completed,recordsSynced=2084,bytesSynced=25861286,startTime=1645088466125,endTime=1645088591991,totalStats=io.airbyte.config.SyncStats@1d177ce4[recordsEmitted=2084,bytesEmitted=25861286,stateMessagesEmitted=73,recordsCommitted=2084],streamStats=[io.airbyte.config.StreamSyncStats@615d2d18[streamName=shopify_abandoned_checkouts,stats=io.airbyte.config.SyncStats@159e6142[recordsEmitted=110,bytesEmitted=522272,stateMessagesEmitted=,recordsCommitted=110]], io.airbyte.config.StreamSyncStats@73247b2c[streamName=shopify_customers,stats=io.airbyte.config.SyncStats@5572c9f0[recordsEmitted=423,bytesEmitted=972989,stateMessagesEmitted=,recordsCommitted=423]], io.airbyte.config.StreamSyncStats@5d4f1bab[streamName=shopify_products,stats=io.airbyte.config.SyncStats@3bbdf531[recordsEmitted=285,bytesEmitted=3683190,stateMessagesEmitted=,recordsCommitted=285]], io.airbyte.config.StreamSyncStats@6b901471[streamName=shopify_orders,stats=io.airbyte.config.SyncStats@286e7dba[recordsEmitted=1217,bytesEmitted=20392260,stateMessagesEmitted=,recordsCommitted=1217]], io.airbyte.config.StreamSyncStats@dd9a95f[streamName=shopify_order_refunds,stats=io.airbyte.config.SyncStats@5919c1a8[recordsEmitted=49,bytesEmitted=290575,stateMessagesEmitted=,recordsCommitted=49]]]],state=io.airbyte.config.State@32417566[state={"orders":{"updated_at":"2022-02-17T04:00:30-05:00"},"products":{"updated_at":"2022-02-17T03:15:23-05:00"},"customers":{"updated_at":"2022-02-17T03:34:59-05:00"},"order_refunds":{"created_at":"2022-02-17T02:30:46-05:00"},"abandoned_checkouts":{"updated_at":"2022-02-17T03:34:59-05:00"}}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@252bdaf3[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@984356e[stream=io.airbyte.protocol.models.AirbyteStream@2527e192[name=shopify_abandoned_checkouts,jsonSchema={"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"note":{"type":["null","string"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"token":{"type":["null","string"]},"source":{"type":["null","string"]},"gateway":{"type":["null","string"]},"user_id":{"type":["null","integer"]},"currency":{"type":["null","string"]},"customer":{"type":"object","properties":{"id":{"type":["null","integer"]},"note":{"type":["null","string"]},"tags":{"type":["null","string"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"state":{"type":["null","string"]},"currency":{"type":["null","string"]},"addresses":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"default":{"type":["null","boolean"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"customer_id":{"type":["null","integer"]},"country_code":{"type":["null","string"]},"country_name":{"type":["null","string"]},"province_code":{"type":["null","string"]}}}},"last_name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"first_name":{"type":["null","string"]},"tax_exempt":{"type":["null","boolean"]},"updated_at":{"type":["null","string"],"format":"date-time"},"total_spent":{"type":["null","number"]},"orders_count":{"type":["null","integer"]},"last_order_id":{"type":["null","integer"]},"verified_email":{"type":["null","boolean"]},"default_address":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"default":{"type":["null","boolean"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"customer_id":{"type":["null","integer"]},"country_code":{"type":["null","string"]},"country_name":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"last_order_name":{"type":["null","string"]},"accepts_marketing":{"type":["null","boolean"]},"admin_graphql_api_id":{"type":["null","string"]},"multipass_identifier":{"type":["null","string"]},"accepts_marketing_updated_at":{"anyOf":[{"type":"string","format":"date-time"},{"type":"string"},{"type":"null"}]}}},"closed_at":{"type":["null","string"],"format":"date-time"},"device_id":{"type":["null","integer"]},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"zone":{"type":["null","string"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"source":{"type":["null","string"]},"position":{"type":["null","integer"]},"price_set":{},"compare_at":{"type":["null","string"]}}}},"total_tax":{"type":["null","number"]},"cart_token":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"line_items":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer","string"]},"key":{"type":["null","string"]},"sku":{"type":["null","string"]},"name":{"type":["null","string"]},"grams":{"type":["null","integer"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"vendor":{"type":["null","string"]},"taxable":{"type":["null","boolean"]},"quantity":{"type":["null","integer"]},"tax_code":{"type":["null","string"]},"gift_card":{"type":["null","boolean"]},"price_set":{},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"zone":{"type":["null","string"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"source":{"type":["null","string"]},"position":{"type":["null","integer"]},"price_set":{},"compare_at":{"type":["null","number"]}}}},"line_price":{"type":["null","number"]},"product_id":{"type":["null","integer"]},"properties":{"anyOf":[{"type":["null","array"],"items":{"type":["null","object"],"properties":{"name":{"type":["null","string"]},"value":{"type":["null","string"]}}}},{"type":["null","object"],"properties":{}}]},"variant_id":{"type":["null","integer"]},"pre_tax_price":{"type":["null","number"]},"variant_title":{"type":["null","string"]},"product_exists":{"type":["null","boolean"]},"total_discount":{"type":["null","number"],"multipleOf":1.0E-10},"origin_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"applied_discount":{"type":["null","integer"]},"compare_at_price":{"type":["null","number"]},"applied_discounts":{},"pre_tax_price_set":{},"requires_shipping":{"type":["null","boolean"]},"fulfillment_status":{"type":["null","string"]},"origin_location_id":{"type":["null","integer"]},"total_discount_set":{},"fulfillment_service":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]},"destination_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"discount_allocations":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"amount_set":{},"discount_application_index":{"type":["null","integer"]}}}},"fulfillable_quantity":{"type":["null","integer"]},"destination_location_id":{"type":["null","integer"]},"variant_inventory_management":{"type":["null","string"]}}}},"source_url":{"type":["null","string"]},"updated_at":{"type":["null","string"],"format":"date-time"},"location_id":{"type":["null","integer"]},"source_name":{"type":["null","string"]},"total_price":{"type":["null","number"]},"completed_at":{"type":["null","string"],"format":"date-time"},"landing_site":{"type":["null","string"]},"total_weight":{"type":["null","integer"]},"discount_codes":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"code":{"type":["null","string"]},"type":{"type":["null","string"]},"amount":{"type":["null","number"],"multipleOf":1.0E-10}}}},"referring_site":{"type":["null","string"]},"shipping_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","string"]},"code":{"type":["null","string"]},"phone":{"type":["null","string"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"markup":{"type":["null","string"]},"source":{"type":["null","string"]},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"],"multipleOf":1.0E-10},"zone":{"type":["null","string"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"source":{"type":["null","string"]},"position":{"type":["null","integer"]},"price_set":{},"compare_at":{"type":["null","string"]}}}},"api_client_id":{"type":["null","integer"]},"custom_tax_lines":{},"applied_discounts":{},"delivery_category":{"type":["null","string"]},"carrier_identifier":{"type":["null","string"]},"carrier_service_id":{"type":["null","integer"]},"validation_context":{"type":["null","string"]},"requested_fulfillment_service_id":{"type":["null","string"]}}}},"subtotal_price":{"type":["null","number"]},"taxes_included":{"type":["null","boolean"]},"billing_address":{"type":["null","object"],"properties":{"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"latitude":{"type":["null","number"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"longitude":{"type":["null","number"]},"first_name":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"customer_locale":{"type":["null","string"]},"note_attributes":{},"total_discounts":{"type":["null","number"]},"shipping_address":{"type":["null","object"],"properties":{"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"latitude":{"type":["null","number"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"longitude":{"type":["null","number"]},"first_name":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"source_identifier":{"type":["null","string"]},"presentment_currency":{"type":["null","string"]},"abandoned_checkout_url":{"type":["null","string"]},"total_line_items_price":{"type":["null","number"]},"buyer_accepts_marketing":{"type":["null","boolean"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6687f17b[stream=io.airbyte.protocol.models.AirbyteStream@1d80531a[name=shopify_customers,jsonSchema={"type":"object","properties":{"id":{"type":["null","integer"]},"note":{"type":["null","string"]},"tags":{"type":["null","string"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"state":{"type":["null","string"]},"currency":{"type":["null","string"]},"addresses":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"default":{"type":["null","boolean"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"customer_id":{"type":["null","integer"]},"country_code":{"type":["null","string"]},"country_name":{"type":["null","string"]},"province_code":{"type":["null","string"]}}}},"last_name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"first_name":{"type":["null","string"]},"tax_exempt":{"type":["null","boolean"]},"updated_at":{"type":["null","string"],"format":"date-time"},"total_spent":{"type":["null","number"]},"orders_count":{"type":["null","integer"]},"last_order_id":{"type":["null","integer"]},"verified_email":{"type":["null","boolean"]},"default_address":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"default":{"type":["null","boolean"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"customer_id":{"type":["null","integer"]},"country_code":{"type":["null","string"]},"country_name":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"last_order_name":{"type":["null","string"]},"accepts_marketing":{"type":["null","boolean"]},"admin_graphql_api_id":{"type":["null","string"]},"multipass_identifier":{"type":["null","string"]},"accepts_marketing_updated_at":{"anyOf":[{"type":"string","format":"date-time"},{"type":"string"},{"type":"null"}]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@35873a81[stream=io.airbyte.protocol.models.AirbyteStream@2fb666d2[name=shopify_orders,jsonSchema={"type":"object","properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"note":{"type":["null","string"]},"tags":{"type":["null","string"]},"test":{"type":["null","boolean"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"token":{"type":["null","string"]},"app_id":{"type":["null","integer"]},"number":{"type":["null","integer"]},"gateway":{"type":["null","string"]},"refunds":{"type":["null","array"]},"user_id":{"type":["null","number"]},"currency":{"type":["null","string"]},"customer":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"note":{"type":["null","string"]},"tags":{"type":["null","string"]},"email":{"type":["null","string"]},"phone":{"type":["null","string"]},"state":{"type":["null","string"]},"currency":{"type":["null","string"]},"last_name":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"first_name":{"type":["null","string"]},"tax_exempt":{"type":["null","boolean"]},"updated_at":{"type":["null","string"],"format":"date-time"},"total_spent":{"type":["null","number"]},"orders_count":{"type":["null","integer"]},"last_order_id":{"type":["null","integer"]},"tax_exemptions":{"type":["null","array"]},"verified_email":{"type":["null","boolean"]},"default_address":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"default":{"type":["null","boolean"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"first_name":{"type":["null","string"]},"customer_id":{"type":["null","integer"]},"country_code":{"type":["null","string"]},"country_name":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"last_order_name":{"type":["null","string"]},"accepts_marketing":{"type":["null","boolean"]},"admin_graphql_api_id":{"type":["null","string"]},"multipass_identifier":{"type":["null","string"]},"marketing_opt_in_level":{"type":["null","string"]},"accepts_marketing_updated_at":{"type":["null","string"]}}},"closed_at":{"type":["null","string"],"format":"date-time"},"confirmed":{"type":["null","boolean"]},"device_id":{"type":["null","string"]},"reference":{"type":["null","string"]},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}}},"total_tax":{"type":["null","number"]},"browser_ip":{"type":["null","string"]},"cart_token":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"line_items":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"sku":{"type":["null","string"]},"name":{"type":["null","string"]},"grams":{"type":["null","integer"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"duties":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","string"]},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","string"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}}}},"channel_liable":{"type":["null","boolean"]}}}},"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"admin_graphql_api_id":{"type":["null","string"]},"country_code_of_origin":{"type":["null","string"]},"harmonized_system_code":{"type":["null","string"]}}}},"vendor":{"type":["null","string"]},"taxable":{"type":["null","boolean"]},"quantity":{"type":["null","integer"]},"gift_card":{"type":["null","boolean"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}}},"product_id":{"type":["null","integer"]},"properties":{"type":["null","array"]},"variant_id":{"type":["null","integer"]},"pre_tax_price":{"type":["null","number"]},"variant_title":{"type":["null","string"]},"product_exists":{"type":["null","boolean"]},"total_discount":{"type":["null","number"]},"origin_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"requires_shipping":{"type":["null","boolean"]},"fulfillment_status":{"type":["null","string"]},"total_discount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"fulfillment_service":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]},"destination_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"discount_allocations":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"amount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}}}},"discount_application_index":{"type":["null","number"]}}}},"fulfillable_quantity":{"type":["null","integer"]},"variant_inventory_management":{"type":["null","string"]}}}},"source_url":{"type":["null","string"]},"updated_at":{"type":["null","string"],"format":"date-time"},"checkout_id":{"type":["null","integer"]},"location_id":{"type":["null","integer"]},"source_name":{"type":["null","string"]},"total_price":{"type":["null","number"]},"cancelled_at":{"type":["null","string"],"format":"date-time"},"fulfillments":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"status":{"type":["null","string"]},"receipt":{"type":["null","object"]},"service":{"type":["null","string"]},"order_id":{"type":["null","integer"]},"created_at":{"type":["null","string"],"format":"date-time"},"line_items":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"sku":{"type":["null","string"]},"name":{"type":["null","string"]},"grams":{"type":["null","integer"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"duties":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","string"]},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","string"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}}}},"channel_liable":{"type":["null","boolean"]}}}},"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"admin_graphql_api_id":{"type":["null","string"]},"country_code_of_origin":{"type":["null","string"]},"harmonized_system_code":{"type":["null","string"]}}}},"vendor":{"type":["null","string"]},"taxable":{"type":["null","boolean"]},"quantity":{"type":["null","integer"]},"gift_card":{"type":["null","boolean"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}}},"product_id":{"type":["null","integer"]},"properties":{"type":["null","array"]},"variant_id":{"type":["null","integer"]},"pre_tax_price":{"type":["null","number"]},"variant_title":{"type":["null","string"]},"product_exists":{"type":["null","boolean"]},"total_discount":{"type":["null","number"]},"origin_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"requires_shipping":{"type":["null","boolean"]},"fulfillment_status":{"type":["null","string"]},"total_discount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"fulfillment_service":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]},"destination_location":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"discount_allocations":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"amount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","string"]},"currency_code":{"type":["null","string"]}}}}},"discount_application_index":{"type":["null","number"]}}}},"fulfillable_quantity":{"type":["null","integer"]},"variant_inventory_management":{"type":["null","string"]}}}},"updated_at":{"type":["null","string"],"format":"date-time"},"location_id":{"type":["null","integer"]},"tracking_url":{"type":["null","string"]},"tracking_urls":{"type":["null","array"]},"shipment_status":{"type":["null","string"]},"tracking_number":{"type":["null","string"]},"tracking_company":{"type":["null","string"]},"tracking_numbers":{"type":["null","array"]},"admin_graphql_api_id":{"type":["null","string"]}}}},"landing_site":{"type":["null","string"]},"order_number":{"type":["null","integer"]},"processed_at":{"type":["null","string"]},"total_weight":{"type":["null","integer"]},"cancel_reason":{"type":["null","string"]},"contact_email":{"type":["null","string"]},"total_tax_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"checkout_token":{"type":["null","string"]},"client_details":{"type":["null","object"],"properties":{"browser_ip":{"type":["null","string"]},"user_agent":{"type":["null","string"]},"session_hash":{"type":["null","string"]},"browser_width":{"type":["null","integer"]},"browser_height":{"type":["null","integer"]},"accept_language":{"type":["null","string"]}}},"discount_codes":{"type":["null","array"]},"referring_site":{"type":["null","string"]},"shipping_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"code":{"type":["null","string"]},"phone":{"type":["null","string"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"source":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"tax_lines":{"type":["null","array"]},"discounted_price":{"type":["null","number"]},"delivery_category":{"type":["null","string"]},"carrier_identifier":{"type":["null","string"]},"discount_allocations":{"type":["null","array"]},"discounted_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"requested_fulfillment_service_id":{"type":["null","string"]}}}},"subtotal_price":{"type":["null","number"]},"taxes_included":{"type":["null","boolean"]},"billing_address":{"type":["null","object"],"properties":{"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"latitude":{"type":["null","number"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"longitude":{"type":["null","number"]},"first_name":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"customer_locale":{"type":["null","string"]},"note_attributes":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"name":{"type":["null","string"]},"value":{"type":["null","string"]}}}},"payment_details":{"type":["null","object"],"properties":{"avs_result_code":{"type":["null","string"]},"credit_card_bin":{"type":["null","string"]},"cvv_result_code":{"type":["null","string"]},"credit_card_number":{"type":["null","string"]},"credit_card_company":{"type":["null","string"]}}},"total_discounts":{"type":["null","number"]},"total_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"total_price_usd":{"type":["null","number"]},"financial_status":{"type":["null","string"]},"landing_site_ref":{"type":["null","string"]},"order_status_url":{"type":["null","string"]},"shipping_address":{"type":["null","object"],"properties":{"zip":{"type":["null","string"]},"city":{"type":["null","string"]},"name":{"type":["null","string"]},"phone":{"type":["null","string"]},"company":{"type":["null","string"]},"country":{"type":["null","string"]},"address1":{"type":["null","string"]},"address2":{"type":["null","string"]},"latitude":{"type":["null","number"]},"province":{"type":["null","string"]},"last_name":{"type":["null","string"]},"longitude":{"type":["null","number"]},"first_name":{"type":["null","string"]},"country_code":{"type":["null","string"]},"province_code":{"type":["null","string"]}}},"current_total_tax":{"type":["null","number"]},"processing_method":{"type":["null","string"]},"source_identifier":{"type":["null","string"]},"total_outstanding":{"type":["null","number"]},"fulfillment_status":{"type":["null","string"]},"subtotal_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"total_tip_received":{"type":["null","number"]},"current_total_price":{"type":["null","number"]},"total_discounts_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"admin_graphql_api_id":{"type":["null","string"]},"presentment_currency":{"type":["null","string"]},"current_total_tax_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"discount_applications":{"type":["null","array"]},"payment_gateway_names":{"type":["null","array"],"items":{"type":["null","string"]}},"current_subtotal_price":{"type":["null","number"]},"total_line_items_price":{"type":["null","number"]},"buyer_accepts_marketing":{"type":["null","boolean"]},"current_total_discounts":{"type":["null","number"]},"current_total_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"current_total_duties_set":{"type":["null","string"]},"total_shipping_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"original_total_duties_set":{"type":["null","string"]},"current_subtotal_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"total_line_items_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"current_total_discounts_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@76634676[stream=io.airbyte.protocol.models.AirbyteStream@6964c323[name=shopify_order_refunds,jsonSchema={"type":"object","properties":{"id":{"type":["null","integer"]},"note":{"type":["null","string"]},"restock":{"type":["null","boolean"]},"user_id":{"type":["null","integer"]},"order_id":{"type":["null","integer"]},"created_at":{"type":["null","string"],"format":"date-time"},"processed_at":{"type":["null","string"]},"order_adjustments":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"kind":{"type":["null","string"]},"amount":{"type":["null","string"]},"reason":{"type":["null","string"]},"order_id":{"type":["null","integer"]},"refund_id":{"type":["null","integer"]},"tax_amount":{"type":["null","string"]}}}},"refund_line_items":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"quantity":{"type":["null","integer"]},"subtotal":{"type":["null","number"]},"line_item":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"sku":{"type":["null","string"]},"name":{"type":["null","string"]},"grams":{"type":["null","integer"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"vendor":{"type":["null","string"]},"taxable":{"type":["null","boolean"]},"quantity":{"type":["null","integer"]},"gift_card":{"type":["null","boolean"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"tax_lines":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"rate":{"type":["null","number"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}}},"product_id":{"type":["null","integer"]},"properties":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"name":{"type":["null","string"]},"value":{"type":["null","string"]}}}},"variant_id":{"type":["null","integer"]},"pre_tax_price":{"type":["null","number"]},"variant_title":{"type":["null","string"]},"product_exists":{"type":["null","boolean"]},"total_discount":{"type":["null","number"]},"pre_tax_price_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"requires_shipping":{"type":["null","boolean"]},"fulfillment_status":{"type":["null","string"]},"total_discount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"fulfillment_service":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]},"discount_allocations":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"amount_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"discount_application_index":{"type":["null","integer"]}}}},"fulfillable_quantity":{"type":["null","integer"]},"variant_inventory_management":{"type":["null","string"]}}},"total_tax":{"type":["null","number"]},"location_id":{"type":["null","integer"]},"line_item_id":{"type":["null","integer"]},"restock_type":{"type":["null","string"]},"subtotal_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}},"total_tax_set":{"type":["null","object"],"properties":{"shop_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"presentment_money":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}}}}}}},"admin_graphql_api_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[created_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[created_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@653bbfbc[stream=io.airbyte.protocol.models.AirbyteStream@7927d53f[name=shopify_products,jsonSchema={"type":["object","null"],"properties":{"id":{"type":["null","integer"]},"tags":{"type":["null","string"]},"image":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"alt":{"type":["null","string"]},"src":{"type":["null","string"]},"width":{"type":["null","integer"]},"height":{"type":["null","integer"]},"position":{"type":["null","integer"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"variant_ids":{"type":["null","array"],"items":{"type":["null","integer"]}},"admin_graphql_api_id":{"type":["null","string"]}}},"title":{"type":["null","string"]},"handle":{"type":["null","string"]},"images":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"alt":{"type":["null","string"]},"src":{"type":["null","string"]},"width":{"type":["null","integer"]},"height":{"type":["null","integer"]},"position":{"type":["null","integer"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"variant_ids":{"type":["null","array"],"items":{"type":["null","integer"]}},"admin_graphql_api_id":{"type":["null","string"]}}}},"status":{"type":["null","string"]},"vendor":{"type":["null","string"]},"options":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"name":{"type":["null","string"]},"values":{"type":["null","array"],"items":{"type":["null","string"]}},"position":{"type":["null","integer"]},"product_id":{"type":["null","integer"]}}}},"variants":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"sku":{"type":["null","string"]},"grams":{"type":["null","integer"]},"price":{"type":["null","number"]},"title":{"type":["null","string"]},"weight":{"type":["null","number"]},"barcode":{"type":["null","string"]},"option1":{"type":["null","string"]},"option2":{"type":["null","string"]},"option3":{"type":["null","string"]},"taxable":{"type":["null","boolean"]},"image_id":{"type":["null","integer"]},"position":{"type":["null","integer"]},"tax_code":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"weight_unit":{"type":["null","string"]},"compare_at_price":{"type":["null","number"]},"inventory_policy":{"type":["null","string"]},"inventory_item_id":{"type":["null","integer"]},"requires_shipping":{"type":["null","boolean"]},"inventory_quantity":{"type":["null","integer"]},"presentment_prices":{"type":["null","array"],"items":{"type":["null","object"],"properties":{"price":{"type":["null","object"],"properties":{"amount":{"type":["null","number"]},"currency_code":{"type":["null","string"]}}},"compare_at_price":{"type":["null","number"]}}}},"fulfillment_service":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]},"inventory_management":{"type":["null","string"]},"old_inventory_quantity":{"type":["null","integer"]}}}},"body_html":{"type":["null","string"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"product_type":{"type":["null","string"]},"published_at":{"type":["null","string"],"format":"date-time"},"published_scope":{"type":["null","string"]},"template_suffix":{"type":["null","string"]},"admin_graphql_api_id":{"type":["null","string"]}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=incremental,cursorField=[updated_at],destinationSyncMode=append,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-02-17 09:05:33 INFO i.a.w.t.TemporalAttemptExecution(get):118 - Docker volume job log path: /tmp/workspace/202/0/logs.log