Not able to connect a custom query of my sql which is with dynamic filters and running fine in my sql server redash. i wrote a dynamic query
SELECT *
FROM crm_leadinfo
WHERE agent_id = {{ agent_id }}
and created_at >= “2023-04-04”
in my sql which is working fine in my redash my sql server but as soon as i try to connect it to looker studio it is giving me a error please look into this and contact me.