Newbie on Redashs here. I’m on a free account on :app.redash.io: and trying to connect to my google sheet and then do some aggregation. I managed to get my query working for my google sheet (although the query runs quite slow), and then lost on how to build a query over that for aggregation. I checked documentation on Query Results and thought I could achieve it with a query like follows:
SELECT COUNT(*) FROM query_81654 a;
, where 81654 is the id of my google sheet import query. The query was created under a “Query Results(Beta)” data source. When I ran the query it spun for a few minutes and finally gave me this error:
Error running query: near "-": syntax error
Any hint? Thanks!