faucet-cli 1.7.1

# YAML equivalent of `faucet-stream/examples/postgres_to_snowflake.rs`.
# The Rust example reads the private key from disk; in YAML use the file:
# interpolation directive ($${file:PATH}) to inline the PEM body directly.
version: 1
name: postgres_to_snowflake

pipeline:
  source:
    type: postgres
    config:
      connection_url: postgres://user:pass@localhost/app
      query: SELECT id, email, created_at FROM users WHERE tenant_id = $1
      params:
        - acme
      max_connections: 8

  sink:
    type: snowflake
    config:
      account: xy12345.us-east-1
      warehouse: INGEST_WH
      database: ANALYTICS
      schema: RAW
      table: USERS
      auth:
        type: key_pair
        config:
          user: INGEST_USER
          private_key_pem: ${file:./snowflake_key.pem}
      batch_size: 500