Site Configuration

The file ~/.wht/siteconfig.yaml contains site specific configuration including secrets. This includes the following:

  1. Details on which warehouse to connect to and the credentials to use to connect.

  2. Credentials to use to connect to any git repository.

Different WHT projects may usee different connection profiles. Multiple connection profiles can be kept in the same site configuration file, stored in .wht folder of user’s home directory.

A sample file is shown below

profiles:
  prod-db-profile:
    target: dev
    outputs:
      dev:
        type: snowflake
        account: inb828.us-west-3
        dbname: MAT_STORE
        schema: AB_SCHEMA
        user: rik
        warehouse: M_PROD_WAREHOUSE
        password: password
        role: ANALYTICS
  test-db-profile:
    target: test
    outputs:
      test:
        type: snowflake
        account: uk12.uk-1
        dbname: REVENUE_BILL
        schema: AIR_SCHEMA
        user: anita
        warehouse: TEST_WAREHOUSE
        password: password
        role: public
gitcreds:
 - reporegex: "git@github.com:REPO_OWNER/*"
   key: |
       -----BEGIN OPENSSH PRIVATE KEY-----
       **********************************************************************
       **********************************************************************
       **********************************************************************
       **********************************************************************
       ****************************************************************
       -----END OPENSSH PRIVATE KEY-----