finance_dbt:
  target: "{{ env_var('FINANCE_DBT_TARGET') }}"
  outputs:
    .template: &default_template  # 定义锚点
      type: clickhouse
      schema: "{{ env_var('FINANCE_CLICKHOUSE_DATABASE') }}"
      # optional
      driver: http
      host: "{{ env_var('FINANCE_CLICKHOUSE_HOST') }}"
      port: "{{ env_var('FINANCE_CLICKHOUSE_HTTP_PORT') | as_number }}"
      user: "{{ env_var('FINANCE_CLICKHOUSE_USER') }}"
      password: "{{ env_var('FINANCE_CLICKHOUSE_PASSWORD') }}"
      verify: True
      secure: False
      retries: 1
      compression: gzip
      connect_timeout: 10
      send_receive_timeout: 24000
      cluster_mode: False
      use_lw_deletes: True
      check_exchange: True
      local_suffix: _local
      allow_automatic_deduplication: True
      custom_settings: {}

      # Native (clickhouse-driver) connection settings
      sync_request_timeout: 5
      compress_block_size: 1048576
    dev:
      <<: *default_template  # 引用锚点
    test:
      <<: *default_template  # 引用锚点
    prod:
      <<: *default_template  # 引用锚点
    local_dev:
      <<: *default_template  # 引用锚点