Michal Ondras
04/17/2024, 12:54 AMvisch
04/17/2024, 1:40 AMMichal Ondras
04/17/2024, 2:10 AMid
, created_at
columns. i tried changing the incremental load from created_at
to id
but it really hasn't changed anything. any tips? @visch ; i also changed the batch_size on the snowflake end and that's reflected on the current_size in the logs; thanksvisch
04/17/2024, 2:12 AMvisch
04/17/2024, 2:17 AMMichal Ondras
04/17/2024, 2:22 AMversion: 1
default_environment: beta
plugins:
extractors:
- name: tap-postgres
variant: meltanolabs
pip_url: git+<https://github.com/MeltanoLabs/tap-postgres.git@v0.0.8>
config:
ssl_enable: true
ssl_certificate_authority: '/ssl-certs/global-bundle.pem'
default_replication_method: INCREMENTAL
filter_schemas: [public]
start_date: 2024-01-01
select: [public-events.*, public-failed_events.*]
schema:
public-events:
metadata:
type:
- object
- "null"
public-failed_events:
event:
type:
- object
metadata:
'public-events.*':
replication-method: INCREMENTAL
replication-key: id
'public-failed_events.*':
replication-method: INCREMENTAL
replication-key: id
loaders:
- name: target-snowflake
variant: meltanolabs
config:
database: MAIN
default_target_schema: SCRATCH
batch_size_rows: 150000
batch_config:
batch_size: 150000
encoding:
format: jsonl
compression: gzip
storage:
root: "file://"
environments:
- name: beta
config:
plugins:
loaders:
- name: target-snowflake
config:
default_target_schema: SCRATCH
- name: production
config:
plugins:
loaders:
- name: target-snowflake
config:
default_target_schema: RAW_PROJECT
jobs:
- name: project
tasks:
- tap-postgres target-snowflake
visch
04/17/2024, 10:49 AMMichal Ondras
04/18/2024, 10:32 PM