example_connections.yml

# Connection details to an Postgres database
postgres1:
  type: postgres
  read_only: False                        # Will disable SQL and DML modifications
  outputs:
    dev:
      host: localhost
      port: 5432
      user: user_name
      password: secret_password
      database: my_db
      limit_rows: 100                         # Will limit all exports to 100 rows
    prod:
      host: prodserver_host
      port: 5432
      user: user_name
      password: secret_password
      database: my_db
  target: dev                                 # The profile that will be used when running the load

# Connection details to an SQL Server database
sqlserver1:
  type: sqlserver
  outputs:
    dev:
      driver: ODBC Driver 17 for SQL Server   # Your ODBC driver
      host: localhost
      port: 1433
      trusted_connection: True                # Use logged in user for credentials
      as_columnstore: True                    # Create tables as Clustered Columnstore Index (SQL Server only)
      database: my_db
      limit_rows: 100
    prod:
      driver: ODBC Driver 17 for SQL Server
      host: prodserver_host
      port: 1433
      user: user_name
      password: secret_password
      database: my_db
  target: dev                                 # The profile that will be used when running the load

# Connection details to an Oracle database
oracle1:
  type: oracle
  outputs:
    dev:
      host: localhost
      port: 1521
      user: user_name
      password: secret_password
      database: my_db
      limit_rows: 100                         # Will limit all exports to 100 rows
    prod:
      host: prodserver_host
      port: 1521
      user: user_name
      password: secret_password
      database: my_db
  target: dev                                 # The profile that will be used when running the load