SELECT usage.dim_role_name, teams.team_name
FROM aws_cost.fct_daily_cost_usage_report AS usage
        JOIN db_exports.scry_production_project_roles_v01 AS roles
        ON usage.dim_role_name = roles.ROLE AND usage.ds = roles.ds

        JOIN db_exports.scry_production_project_teams_v01 AS projectteams
        ON roles.project_id = projectteams.project_id AND roles.ds = projectteams.ds

        JOIN db_exports.scry_production_teams_v01 teams
        ON projectteams.team_id = teams.id AND projectteams.ds = teams.ds