Hello there,
I would like to use column names of a table or view as variables.
I know the this should work:
SELECT column_name
FROM information_schema.columns
WHERE table_name = ‘mytable’
And works if you execute the SQL command but if I try to set a variable in the dashboard using Query as follows:
It doesn’t seem to recognize anything. Somebody knows what am I doing wrong? Or in which way could I see what I want.
Thanks