Functional Analysis Tool

Query Configuration (YAML)

Paste your YAML configuration below.

client_name: "Bayer"

# Tokens that apply to ALL queries (e.g., Date ranges, Schema names)
global_tokens:
  - "COUNTRY_CODE"
  - "END_DATE"
  - "DB_SCHEMA"

sections:
  - title: "Multichannel & Digital Engagement"
    # A list of subsections, each with its own subtitle and queries
    subsections:
      - subtitle: "Events Management"
        queries:
          - name: "Event Planning and Execution"
            sql: "SELECT id FROM account__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v"

- name: "Event Planning and Execution"
            sql: "SELECT id FROM call2__v"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "created_by__vr.country__v, created_by__vr.user_type__v, created_by__vr.profile_name__v"

- name: "Event Planning and Execution"
            sql: "SELECT id, vcountry__vr.name__v FROM account__v "
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
            group_by: "vcountry__vr.name__v"
          
          - name: "Approved Email for Events"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"
              - "COUNTRY_CODE"
      - subtitle: "CLM Presentations"
        queries:
          - name: "Custom Presentations"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND security_profile__sys = '{SECURITY_PROFILE}'"
            # Tokens specific only to this query
            sub_tokens: 
              - "SECURITY_PROFILE"
          
          - name: "Media Library Search & Filtering"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"

- title: "Core CRM & Account Management"
    subsections:
      - subtitle: "Account Management"
        queries:
          - name: "Account Profiles"
            sql: "SELECT id, email__sys FROM user__sys WHERE country_code__v = '{COUNTRY_CODE}' AND name__v = '{NAME}'"
            sub_tokens:
              - "NAME"

Configuration: a