version: 2

sources:
  - name: google_sheets
    database: gcp-digital-bi
    schema: google_sheets
    tables:
      # BO:
      - name: fenxiang_oppo_product_businesstype_mapping
      - name: order_acv_special_treatment
      - name: finance_mrr_special_adjust
      - name: bo_special_account_quaterly_arr_commission_base
      - name: bo_arr_commision_base_special_treatment_breakdown_revrec
      - name: bo_arr_commision_base_special_treatment_op_to_cloud
      - name: global_arr_forecast_special_treatment
      # dbass_billing:
      - name: dbaas_billing_unit_category_and_business_type_mapping
      # dwd:
      - name: account_project_owner
      - name: department_cost_center
      - name: email_salesforce_user_mapping
      - name: finance_exchange_rate
      - name: jindie_finance_special_treatment
      - name: jindie_management_items_mapping
      - name: jindie_spend_yinshan_salary
      # fp_and_a:
      - name: salesforce_currency_cd_rate
      - name: fy_24_global_sales_acv_quota
      - name: fy_24_china_sales_acv_quota
      - name: fy_25_cbg_sales_overall_quota
      - name: fy_25_region_acv_quota_for_bigquery
      - name: fy_25_region_arr_quota_for_bigquery
      - name: fy_26_region_acv_quota_for_bigquery
      - name: fy_26_region_arr_quota_for_bigquery
      - name: fy_27_region_arr_quota_for_bigquery
      - name: ucloud_monthly_invoice_amount_detail
      - name: org_monthly_bill_confirmation_for_revrec
      - name: netsuite_spending_yinshan_salary_special_treatment
      
      # billing:
      - name: billing_invoice
      - name: netsuite_company_name_mapping_account_book_id
    

  - name: model_fp_and_a
    schema: model_fp_and_a
    tables:
      - name: dws_salesforce_activated_order_account_basic_info
      - name: dws_salesforce_activated_order_account_monthly_revrec
      - name: dws_salesforce_activated_order_account_monthly_revrec_v2
      - name: dws_salesforce_activated_order_to_usd_detail_v2
  - name: bo
    schema: bo
    tables:
      - name: dwm_salesforce_cloud_commitment_plan_to_marketplace_order_product_monthly_revrec
      - name: dwm_salesforce_cloud_commitment_plan_to_marketplace_order_product_detail_accum_revrec
      - name: dws_salesforce_pipeline_forecast_closedwon_acv_group_by_owner_v2