version: 1
default_environment: dev
environments:
- name: dev
- name: staging
- name: prod
project_id: meltano-test-e5a3b6ee-6d57-4c54-811b-d8f0f60e47ba
plugins:
extractors:
- name: tap-mssql
variant: wintersrd
pip_url: tap-mssql
config:
database: ms
filter_dbs: ms
host: ip
port: '1433'
user: xxx
default_replication_method: FULL_TABLE
- name: tap-postgres
variant: transferwise
pip_url: pipelinewise-tap-postgres
config:
dbname: postgres
default_replication_method: FULL_TABLE
filter_schemas: public
host: ip
user: user
loaders:
- name: target-postgres
variant: transferwise
pip_url: pipelinewise-target-postgres
config:
dbname: target
default_target_schema: public
host: ip
user: user
orchestrators:
- name: airflow
variant: apache
pip_url: apache-airflow==2.3.4 --constraint
https://raw.githubusercontent.com/apache/airflow/constraints-2.3.4/constraints-${MELTANO__PYTHON_>
transformers:
- name: dbt-postgres
variant: dbt-labs
pip_url: dbt-core~=1.1.0 dbt-postgres~=1.1.0
schedules:
- name: mssql-to-postgres
interval: '@once'
extractor: tap-mssql
loader: target-postgres
transform: skip
start_date: 2022-08-26 20
5322.142596