I’m new to redash
I’ve been setting up redash on my digital ocean from its marketplace. I’m using postgresql as the database on another server (droplets). The database right now got millions of row data.
It’s up and running now. however, my query keep getting Error like below,
" Error running query: **failed communicating with server. Please check your Internet connection and try again.**"
First, I checked my network tabs, the result shows up there but it did not show in the redash and just showed the error message. I tried a simple count query and it runs well. The query that keeps showing me this error is something like this
SELECT s.name, EXTRACT(MONTH FROM t.transaction_at) AS month, EXTRACT(DAY FROM t.transaction_at) AS day, SUM(t.total_sell_price), SUM(t.total_buy_price) FROM transactions_2 t INNER JOIN stores s ON s.id = t.store_id WHERE t.transaction_at >= '2021-09-01' AND t.transaction_at < '2021-10-01' GROUP BY s.id, EXTRACT(MONTH FROM t.transaction_at), EXTRACT(DAY FROM t.transaction_at) ORDER BY s.id, month, day
The result of these query maybe around 1000ish rows, i tried to minimize the rows with more where with result only 30 rows still didn’t work. The only approach that can work is when i limit the query to 10. but i don’t think that solve the core problem of my issue.
I already docker logs the redash server but there are no error occured that can be found. I searched around i couldn’t found the correct terms to fix this error. I hope anybody can help me with this at least where to start or where to look at.