Can you try this?

select *
from team_finance_global.vw_fact_pnl_exp001
where "Id Date" = "20250807"

Try with double quoats

OR

-- This assumes 'id_date' is the correct underlying column name
select *
from team_finance_global.vw_fact_pnl_exp001
where id_date = '20250807'

id_date is the original column name, but the alias is 'Id Date'. Using the alias with the appropriate quoting is the intended way to query the view.