def METHOD_NAME() -> List[int]:
    q = """
    select distinct vars.varID as varId
    from charts c, json_table(c.config, '$.dimensions[*]' columns (varID integer path '$.variableId') ) as vars
    where JSON_EXTRACT(c.config, '$.isPublished')=true;
    """
    df = pd.read_sql(q, engine)
    return df["varId"].tolist()