version: 2

sources:
  - name: fansifter
    database: FANSIFTER_APP_REPORTING
    schema: "{{ 'PROD' if target.name == 'prod' else 'QA' }}"
    tables:
      - name: global_participant_account
        identifier: GLOBAL_PARTICIPANT_ACCOUNT_DBT
      - name: ad_reporting_campaign_artist
        identifier: AD_REPORTING_CAMPAIGN_ARTIST
      - name: sendgrid_webhook_general
        identifier: SENDGRID_WEBHOOK_GENERAL
      - name: email_campaign
        identifier: EMAIL_CAMPAIGN
      - name: email_automated
        identifier: EMAIL_AUTOMATED
      - name: sendgrid_webhook_general_aggregated
        identifier: SENDGRID_WEBHOOK_GENERAL_AGGREGATED
      - name: email_automated_trigger
        identifier: EMAIL_AUTOMATED_TRIGGER
      - name: email_analytics_by_campaign_link
        identifier: EMAIL_ANALYTICS_BY_CAMPAIGN_LINK
      - name: text_campaign
        identifier: TEXT_CAMPAIGN
      - name: text_campaign_sends_country_aggregated
        identifier: TEXT_CAMPAIGN_SENDS_COUNTRY_AGGREGATED
      - name: url_shortener_clicks_country_aggregated
        identifier: URL_SHORTENER_CLICKS_COUNTRY_AGGREGATED
      - name: custom_list
        identifier: CUSTOM_LIST
  - name: facts
    database: FACTS
    schema: PROD
    tables:
      - name: global_participant
        identifier: GLOBAL_PARTICIPANT
      - name: dim_currency
        identifier: DIM_CURRENCY
      - name: vendor
        description: Table containing data for vendors
        identifier: VENDOR
      - name: company_brand
        description: Table containing company brands
        identifier: COMPANY_BRAND
      - name: company_brand_has_label_vendor
        description: Table with a Vendor - Company Brand mapping
        identifier: COMPANY_BRAND_HAS_LABEL_VENDOR
      - name: identity
        identifier: IDENTITY
  - name: fansifter_pg
    database: FANSIFTER_PG_REPORTING
    schema: "{{ 'PROD' if target.name == 'prod' else 'QA' }}_OWS_DMP_PUBLIC"
    tables:
      - name: meta_ad_reporting_connection
        identifier: META_AD_REPORTING_CONNECTION
      - name: meta_ad_reporting_connection_ad_account
        identifier: META_AD_REPORTING_CONNECTION_AD_ACCOUNT
      - name: meta_user_ad_account
        identifier: META_USER_AD_ACCOUNT
      - name: meta_ad_account
        identifier: META_AD_ACCOUNT
      - name: tiktok_ad_reporting_connection
        identifier: TIKTOK_AD_REPORTING_CONNECTION
      - name: tiktok_ad_reporting_connection_ad_account
        identifier: TIKTOK_AD_REPORTING_CONNECTION_AD_ACCOUNT
      - name: tiktok_user_ad_account
        identifier: TIKTOK_USER_AD_ACCOUNT
      - name: tiktok_ad_account
        identifier: TIKTOK_AD_ACCOUNT
      - name: email_campaign
        identifier: EMAIL_CAMPAIGN
      - name: google_ad_reporting_connection
        identifier: GOOGLE_AD_REPORTING_CONNECTION
      - name: google_ad_reporting_connection_ad_account
        identifier: GOOGLE_AD_REPORTING_CONNECTION_AD_ACCOUNT
      - name: google_user_ad_account
        identifier: GOOGLE_USER_AD_ACCOUNT
      - name: google_ad_account
        identifier: GOOGLE_AD_ACCOUNT
      - name: audience
        identifier: AUDIENCE
  - name: preference_center
    database: PREFERENCE_CENTER
    schema: "{{ 'PROD' if target.name == 'prod' else 'QA' }}"
    tables:
      - name: subscription_changelog
        identifier: subscription_changelog
      - name: deleted_profile
        identifier: DELETED_PROFILE
  - name: delphi_exploration
    database: DELPHI_EXPLORATION
    schema: SYS
    tables:
      - name: dsp_id_to_user_mapping
        identifier: DSP_ID_TO_USER_MAPPING
  - name: fansifter_shopify
    database: FANSIFTER_SHOPIFY
    schema: "{{ 'PROD' if target.name == 'prod' else 'QA' }}"
    tables:
      - name: shopify_order
        identifier: SHOPIFY_ORDER_DBT
      - name: shopify_order_line
        identifier: SHOPIFY_ORDER_LINE_DBT
      - name: shopify_order_url_tag
        identifier: SHOPIFY_ORDER_URL_TAG_DBT
      - name: shopify_shop
        identifier: SHOPIFY_SHOP_DBT
      - name: shopify_product
        identifier: SHOPIFY_PRODUCT_DBT
      - name: shopify_refund
        identifier: SHOPIFY_REFUND_DBT
      - name: shopify_order_line_refund
        identifier: SHOPIFY_ORDER_LINE_REFUND_DBT