version: 1
send_anonymous_usage_stats: true
project_id: 14a3eb75-9bc1-4886-bfab-54691b989a95
plugins:
  extractors:
  - name: tap-postgres
    variant: transferwise
    config:
      default_replication_method: FULL_TABLE
  - name: tap-hamilton
    inherit_from: tap-postgres
    load_schema: hamilton_raw_20220422
    select:
    - public-platform.*
    - public-organisation.*
    - public-team.*
    - public-platform_setting.*
    - public-organisation_setting.*
    - public-team_setting.*
    - public-subdomain.*
    - public-tag_definition.*
    - public-tag_value.*
    metadata:
      public-platform.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
      public-organisation.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
      public-team.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
      public-platform_setting.*:
        replication-method: INCREMENTAL
        replication-key: created
      public-organisation_setting.*:
        replication-method: INCREMENTAL
        replication-key: created
      public-team_setting.*:
        replication-method: INCREMENTAL
        replication-key: created
      public-subdomain.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
      public-tag_definition.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
      public-tag_value.*:
        replication-method: INCREMENTAL
        replication-key: last_modified
  loaders:
  - name: target-postgres
    variant: transferwise
  - name: target-redshift
  - name: target-warehouse-postgres
    inherit_from: target-postgres
    config:
      parallelism: 1
  - name: target-warehouse-redshift
    inherit_from: target-redshift
  transformers:
  - name: dbt
