Simon Schmitke
01/19/2024, 8:08 PMstate
in it's most basic form.
I have a local postgres that I've hooked up to my Snowflake. I have 1 table, orders
, with 3 fields (account_id, orders, updated_at), and like 10 records.
I try to run meltano elt tap-postgres target-snowflake --state-id=orders_sync, but it keeps generating an empty state file.
{
"completed": {
"singer_state": {
"bookmarks": {
"public-orders": {}
}
}
},
"partial": {}
}
My meltano.yml is setup like:
extractors:
- name: tap-postgres
config:
database: $POSTGRES_DB
host: $POSTGRES_HOST
user: $POSTGRES_USER
password: $TAP_POSTGRES_PASSWORD
port: 5432
filter_schemas:
- public
default_replication_method: INCREMENTAL
metadata:
orders:
replication-method: INCREMENTAL
replication-key: updated_at
If anyone is able to help me understand what's up, I'd really appreciate it 🙏Simon Schmitke
01/19/2024, 8:09 PMmetadata:
public-orders:
I didn't have the public-
prefix.