Rocky Appiah
01/13/2023, 6:47 PM$ docker-compose up -d
WARNING: The DEPLOYMENT_MODE variable is not set. Defaulting to a blank string.
WARNING: The LOG_CONNECTOR_MESSAGES variable is not set. Defaulting to a blank string.
WARNING: The SHOULD_RUN_NOTIFY_WORKFLOW variable is not set. Defaulting to a blank string.
WARNING: The SECRET_PERSISTENCE variable is not set. Defaulting to a blank string.
WARNING: The JOB_ERROR_REPORTING_SENTRY_DSN variable is not set. Defaulting to a blank string.
WARNING: The APPLY_FIELD_SELECTION variable is not set. Defaulting to a blank string.
WARNING: The FIELD_SELECTION_WORKSPACES variable is not set. Defaulting to a blank string.
WARNING: The NEW_SCHEDULER variable is not set. Defaulting to a blank string.
WARNING: The WORKER_ENVIRONMENT variable is not set. Defaulting to a blank string.
WARNING: The GITHUB_STORE_BRANCH variable is not set. Defaulting to a blank string.
WARNING: The REMOTE_CONNECTOR_CATALOG_URL variable is not set. Defaulting to a blank string.
WARNING: The TEMPORAL_HISTORY_RETENTION_IN_DAYS variable is not set. Defaulting to a blank string.
WARNING: The UPDATE_DEFINITIONS_CRON_ENABLED variable is not set. Defaulting to a blank string.
ERROR: The Compose file './docker-compose.yaml' is invalid because:
services.airbyte-connector-builder-server.depends_on contains an invalid type, it should be an array
services.airbyte-cron.depends_on contains an invalid type, it should be an array
services.server.depends_on contains an invalid type, it should be an array
services.webapp.depends_on contains an invalid type, it should be an array
services.worker.depends_on contains an invalid type, it should be an array
services.bootloader.depends_on contains an invalid type, it should be an array
Rocky Appiah
01/13/2023, 6:52 PMMateusz Kijewski
01/13/2023, 7:09 PMlogs.minio.enabled
to false
Vitória de Barros Carvalho
01/13/2023, 7:41 PMVitória de Barros Carvalho
01/13/2023, 7:42 PMMikhail Masyagin
01/14/2023, 6:54 AMRendy B. Junior
01/14/2023, 6:56 AMHttpStream._send
, copy paste the content, and add another else block after should_retry check
context: python source connectorMaksim Miceta
01/14/2023, 10:00 AMRocky Appiah
01/14/2023, 4:39 PM2023-01-14 16:34:30 INFO i.a.w.p.DockerProcessFactory(create):164 - Preparing command: docker run --rm --init -i -w /data/1/0/normalize --log-driver none --name normalization-snowflake-normalize-1-0-frzai --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.40.28 airbyte/normalization-snowflake:0.2.25 run --integration-type snowflake --config destination_config.json --catalog destination_catalog.json
2023-01-14 16:34:33 normalization > [FATAL tini (6)] exec /airbyte/entrypoint.sh failed: Exec format error
2023-01-14 16:34:33 INFO i.a.w.n.DefaultNormalizationRunner(close):189 - Terminating normalization process...
2023-01-14 16:34:33 ERROR i.a.w.g.DefaultNormalizationWorker(run):83 - Normalization failed for job 1.
io.airbyte.workers.exception.WorkerException: Normalization process did not terminate normally (exit code: 1)
at io.airbyte.workers.normalization.DefaultNormalizationRunner.close(DefaultNormalizationRunner.java:200) ~[io.airbyte-airbyte-commons-worker-0.40.28.jar:?]
at io.airbyte.workers.general.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:81) ~[io.airbyte-airbyte-commons-worker-0.40.28.jar:?]
at io.airbyte.workers.general.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:34) ~[io.airbyte-airbyte-commons-worker-0.40.28.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.40.28.jar:?]
source, destination, and normalization versions are:
airbyte/source-postgres 1.0.34 c4194c9f52c9 4 weeks ago 640MB
airbyte/destination-snowflake 0.4.42 a1e9484f57f2 41 hours ago 1.41GB
airbyte/normalization-snowflake 0.2.25 7ddea81b7155 5 weeks ago 783MB
Running Airbyte version 0.40.28Deepak Kumar
01/14/2023, 5:16 PMihsan islam
01/14/2023, 9:51 PMJordan Fox
01/14/2023, 10:53 PMMeir Ifrach
01/15/2023, 12:30 PMLeo Schick
01/15/2023, 3:26 PMJosé Lúcio Zancan Júnior
01/15/2023, 11:25 PMkube/overlays/stable
method)
I just need to change the version
parameter on my values.yaml and do a helm upgrade? Or there's something else?Omar Abdullahi Ahmed
01/16/2023, 8:57 AMIshan Anilbhai Koradiya
01/16/2023, 10:16 AMJordan Fox
01/16/2023, 10:33 AMManish Tomar
01/16/2023, 11:00 AMconnectionTimeout
parameter for Hikari JDBC connection can be changed if we change the JDBC url Params from UI of Postgres source Connector ? https://github.com/airbytehq/airbyte/pull/15226, If yes How can I check whether it successfully overrides the default value`connectionTimeout = 10000ms` or not?Miguel Ángel Torres Font - Valencia C.F.
01/16/2023, 1:59 PMMiguel Ángel Torres Font - Valencia C.F.
01/16/2023, 2:00 PMAssaf Pinhasi
01/16/2023, 2:25 PMlast_update_dt
is X
• Now, I want to define an incremental sync to that table. The sync will be based on last_update_dt
column.
• I want the first sync that runs to start from records where last_update_dt > X
i.e. I want the incremental sync to pick up from the current state of the destination table (vs. from scratch).
Is that possible?
[edit]
Is it possible to do something like set the connection state in the postgres db to point to the latest value of the column?Lucas Gonthier
01/16/2023, 2:54 PMVitória de Barros Carvalho
01/16/2023, 6:01 PMPhilip Johnson
01/16/2023, 6:59 PMISO8601Error("Unable to parse duration string '1d'")
, which is strange. Previously, in the tutorial this was the value shown as an example, but now it looks like it's P1D
for both step and cursor granularity. If I try and use those locally, I get a different error: Something went wrong in the connector. See the logs for more details...line 190, in _parse_timedelta\n assert parts is not None\nAssertionError\n.
Can anyone provide a bit of guidance on what the step and cursor_granularity should actually be here?
Coming from the stream slicer section in the yaml file:
stream_slicer:
type: "DatetimeStreamSlicer"
start_datetime:
datetime: "{{ config['start_date'] }}"
datetime_format: "%Y-%m-%d"
end_datetime:
datetime: "{{ now_utc() }}"
datetime_format: "%Y-%m-%d %H:%M:%S.%f+00:00"
step: "1d"
datetime_format: "%Y-%m-%d"
cursor_field: "{{ options['stream_cursor_field'] }}"
cursor_granularity: "day"
$options:
name: "austin_permits"
primary_key: "permit_number"
path: "/3syk-w9eu.json?$where=issue_date>='{{config['start_date'] or 'latest'}}'"
cursor_field: "issue_date"
Apoorva
01/16/2023, 8:18 PMApoorva
01/16/2023, 8:18 PMApoorva
01/16/2023, 8:18 PMApoorva
01/16/2023, 8:19 PMApoorva
01/16/2023, 8:19 PM