Where to check generated SQL by Arcadia please advise. I don’t have Activity in drop down menu, is that the place?
I am using Postgres connection from Arcadia.
Facing complaints about syntax which is not used in filter e.g.
Visual 2207 - Could not load data
Error: column “2019-09-21” does not exist
LINE 4: …019-09-21’) AND (TA_0.“period_start_time” between "2019-09-2…
which my filter does not use between but date([period_start_time]) >= ‘<selectdate.start:2019-09-20>’
Also another visual shows error:
Visual 1651 - Could not load data
Error: column “ta_0.period_start_time” must appear in the GROUP BY clause or be used in an aggregate function
LINE 4: HAVING (TA_0.“period_start_time” \u003E= ‘2019-09-20’ AND
in my visual only use period_start_time in filter shelft not in dimension so wonder why it complains about ‘Group by’
The same visuals has been tested with spark connection with no error.
Please advise. Thank you very much.