meltano.yml

version: 1
default_environment: dev
project_id: meltanolabs-evidence-ext
environments:
- name: dev
- name: staging
- name: prod
plugins:
  utilities:
  - name: evidence
    namespace: evidence
    pip_url: -e .
    executable: evidence_extension
    settings_group_validation:
    - - home_dir
        # duckdb
    - - home_dir
      - settings.database
      - settings.duckdb.filename
        # sqlite
    - - home_dir
      - settings.database
      - settings.sqlite.filename
        # bigquery
    - - home_dir
      - settings.database
      - settings.bigquery.project_id
      - settings.bigquery.client_email
      - settings.bigquery.private_key
        # MySQL
    - - home_dir
      - settings.database
      - settings.mysql.host
      - settings.mysql.database
      - settings.mysql.user
      - settings.mysql.password
        # postgres
    - - home_dir
      - settings.database
      - settings.postgres.host
      - settings.postgres.port
      - settings.postgres.database
      - settings.postgres.user
      - settings.postgres.password
    - - home_dir
      - settings.database
      - settings.postgres.connection_string
        # snowflake
    - - home_dir
      - settings.database
      - settings.snowflake.account
      - settings.snowflake.username
      - settings.snowflake.password
      - settings.snowflake.database
      - settings.snowflake.warehouse
        # mssql
    - - home_dir
      - settings.database
      - settings.mssql.host
      - settings.mssql.database
      - settings.mssql.user
      - settings.mssql.password
      - settings.mssql.trust_server_certificate
      - settings.mssql.port
      - settings.mssql.encrypt
    settings:
    - name: home_dir
      env: EVIDENCE_HOME
      kind: string
      value: $MELTANO_PROJECT_ROOT/analyze/evidence
      label: Evidence Home Dir
      description: |
        The directory where Evidence will store its project, configuration, logs, and other files.
    - name: send_anonymous_usage_stats
      env: SEND_ANONYMOUS_USAGE_STATS
      kind: options
      value: yes
      label: Send Anonymous Usage Stats
      description: |
        Send Evidence anonymous usage stats.
      options:
      - value: yes
      - value: no
    - name: settings.database
      env: DATABASE
      kind: options
      value: duckdb      # sample project value
      options:
          # https://github.com/evidence-dev/evidence/blob/9b1dd45b4c90d379ea7cd2f1a525b6025364d4bc/sites/example-project/src/components/ui/Databases/DatabaseSettingsPanel.svelte#L25-L32
      - value: bigquery
        label: BigQuery
      - value: postgres
        label: Postgres
      - value: mysql
        label: MySQL
      - value: redshift
        label: Redshift
      - value: snowflake
        label: Snowflake
      - value: sqlite
        label: SQLite
      - value: duckdb
        label: DuckDB
      - value: csv
        label: CSV
      - value: mssql
        label: SQL Server
        # duckdb
    - name: settings.duckdb.filename
      env: DUCKDB_FILENAME
      kind: string
      value: needful_things.duckdb      # sample project value
      label: DuckDB Database File Name
      description: |
        Name of the DuckDB database file stored in the same directory as your Evidence project.
    - name: settings.duckdb.gitignore_duckdb
      env: DUCKDB_GITIGNOREDUCKDB
      kind: boolean
      label: Gitignore DuckDB Database Files
      description: |
        Gitignore .db and .duckdb files
       # sqlite
    - name: settings.sqlite.filename
      env: SQLITE_FILENAME
      kind: string
      label: SQLite Database File Name
      description: |
        Name of the SQLite database file stored in the same directory as your Evidence project.
    - name: settings.sqlite.gitignore_sqlite
      env: MYSQL_GITIGNORESQLITE
      kind: boolean
      label: Gitignore SQLite Database Files
      description: |
        Gitignore all SQLite files.
       # bigquery
    - name: settings.bigquery.project_id
      env: BIGQUERY_PROJECT_ID
      kind: string
      label: BigQuery Project ID
    - name: settings.bigquery.client_email
      env: BIGQUERY_CLIENT_EMAIL
      kind: string
      label: BigQuery Client Email
    - name: settings.bigquery.private_key
      env: BIGQUERY_PRIVATE_KEY
        # mysql
      kind: password
      label: BigQuery Private Key
    - name: settings.mysql.user
      env: MYSQL_USER
      kind: string
      label: MySQL User
    - name: settings.mysql.host
      env: MYSQL_HOST
      kind: string
      label: MySQL Host
    - name: settings.mysql.database
      env: MYSQL_DATABASE
      kind: string
      label: MySQL Database
    - name: settings.mysql.password
      env: MYSQL_PASSWORD
      kind: password
      label: MySQL Password
    - name: settings.mysql.port
      env: MYSQL_PORT
      label: MySQL Port
    - name: settings.mysql.ssl
      env: MYSQL_SSL
      kind: options
      label: MySQL SSL
      options:
      - value: 'true'
      - value: 'false'
      - value: Amazon RDS
    - name: settings.mysql.socket_path
      env: MYSQL_SOCKETPATH
      kind: string
      label: MySQL User
      description: |
        This is an optional field. When using Google Cloud MySQL this is commonly required.
       # postgres / redshift
    - name: settings.postgres.host
      env: POSTGRES_HOST
      kind: string
      label: Postgres Host
    - name: settings.postgres.database
      env: POSTGRES_DATABASE
      kind: string
      label: Postgres Database
    - name: settings.postgres.port
      env: POSTGRES_PORT
      kind: string
      label: Postgres Port
    - name: settings.postgres.user
      env: POSTGRES_USER
      kind: string
      label: Postgres User
    - name: settings.postgres.password
      env: POSTGRES_PASSWORD
      kind: password
      label: Postgres Password
    - name: settings.postgres.ssl
      env: POSTGRES_SSL
      kind: options
      description: |
        Postgres SSL. When using Heroku this is commonly required.
      options:
      - value: 'true'
      - value: 'false'
      - value: no-verify
    - name: settings.postgres.connection_string
      env: POSTGRES_CONNECTIONSTRING
      kind: password
      label: Postgres Connection String
      description: |
        If your database host provides a connection string, you can use that in place of the fields above.
       # snowflake
    - name: settings.snowflake.account
      env: SNOWFLAKE_ACCOUNT
      kind: string
      label: Snowflake Account
    - name: settings.snowflake.username
      env: SNOWFLAKE_USERNAME
      kind: string
      label: Snowflake Username
    - name: settings.snowflake.password
      env: SNOWFLAKE_PASSWORD
      kind: password
      label: Snowflake Password
    - name: settings.snowflake.database
      env: SNOWFLAKE_DATABASE
      kind: string
      label: Snowflake Database
    - name: settings.snowflake.warehouse
      env: SNOWFLAKE_WAREHOUSE
        # mssql
      kind: string
      label: Snowflake Warehouse
    - name: settings.mssql.host
      env: MSSQL_HOST
      kind: string
      label: MSSQL Host
    - name: settings.mssql.database
      env: MSSQL_DATABASE
      kind: string
      label: MSSQL database
    - name: settings.mssql.user
      env: MSSQL_USER
      kind: string
      label: MSSQL user name
    - name: settings.mssql.password
      env: MSSQL_PASSWORD
      kind: password
      label: MSSQL Password
    - name: settings.mssql.options.trust_server_certificate
      env: MSSQL_TRUST_SERVER_CERTIFICATE
      kind: string
      label: Trust server certificate
      description: |
        SQL Server server certificate
    - name: settings.mssql.port
      env: MSSQL_PORT
      kind: string
      value: false
      label: Port
    - name: settings.mssql.options.encrypt
      env: MSSQL_ENCRYPT
      kind: string
      value: true
      label: Encryption
      description: |
        SQL Server encryption
    commands:
      describe:
        args: describe
        executable: evidence_extension
      initialize:
        args: initialize
        executable: evidence_extension
      build:
        args: build
        executable: evidence_extension
      build-strict:
        args: build --strict
        executable: evidence_extension
      upgrade:
        args: upgrade
        executable: evidence_extension
    config:
      home_dir: $MELTANO_PROJECT_ROOT/sample/