SQL compilation error on Variable

Get Help
1

Hey All, I am receiving the following error when running the following code:

    SELECT 
        COUNT(DISTINCT MEMBER_EMAIL) AS TOTAL_SPORTS,
        FISCAL_PERIOD
    
    FROM "PROD"."T"."AE" E
    where {{LEAGUE_CATEGORY}} = E.LEAGUE_CATEGORY

    GROUP BY 2
    ORDER BY 2

The error I am receiving is the following:
SQL compilation error: error line 7 at position 10 invalid identifier 'T.AE.LEAGUE_CATEGORY'

I am not sure why I am receiving it? The variable type is a Field Filter mapped to the League_Category Field. But when I leave the variable type as a string and manually input a League Category I have no issues.

2

Hi @kz930
You cannot use table aliases when using Field Filters, and you should not include column or operator:
https://www.metabase.com/learn/sql-questions/field-filters#field-filter-gotchas