Hi there,
I'm looking forward to embed a dashboard in my web application. There, each client will have access to their data, and that data is split by schema in our database.
My goal was to pass the customer's schema and use it on the queries, like in the example below:
SELECT
count(*) AS "count"
FROM {{schema}}.users
But I'm getting the below error. Looks like there are a few CAST operations running on the variable.
I've tried the below approach as well, with no success.
SET search_path = {{schema}};
SELECT
count(*) AS "count"
FROM users
I wonder if it's possible to achieve what I'm trying to do using Metabase?
Thank you.