Hey there, I'm having trouble with setting up `state` in it's most basic form. I have a local post...
s
Hey there, I'm having trouble with setting up
state
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.
Copy code
{
  "completed": {
    "singer_state": {
      "bookmarks": {
        "public-orders": {}
      }
    }
  },
  "partial": {}
}
My meltano.yml is setup like:
Copy code
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 🙏
1
Oh my goodness - I just needed to change the metadata field name to:
Copy code
metadata:
   public-orders:
I didn't have the
public-
prefix.
🙌 1