Comment by zX41ZdbW
2 years ago
Yes, it is possible to connect to the database directly and run an arbitrary query. Example:
$ clickhouse-client --user website --host kvzqttvc2n.eu-west-1.aws.clickhouse-staging.com
clickhouse-cloud :) SELECT t, desc, count() AS c FROM planes_mercator_sample100 GROUP BY ALL ORDER BY c DESC LIMIT 10
┌─t────┬─desc────────────────────────────┬────────c─┐
1. │ B738 │ BOEING 737-800 │ 51530781 │
2. │ A320 │ AIRBUS A-320 │ 37196762 │
3. │ C172 │ CESSNA 172 Skyhawk │ 20049393 │
4. │ A321 │ AIRBUS A-321 │ 19983151 │
5. │ A20N │ AIRBUS A-320neo │ 14938832 │
6. │ B38M │ BOEING 737 MAX 8 │ 14200826 │
7. │ B737 │ BOEING 737-700 │ 13929403 │
8. │ A319 │ AIRBUS A-319 │ 13906164 │
9. │ E75L │ EMBRAER ERJ-170-200 (long wing) │ 12006441 │
10. │ A21N │ AIRBUS A-321neo │ 10965047 │
└──────┴─────────────────────────────────┴──────────┘
Add FORMAT CSV to output in CSV (or any other format).
To obtain an SQL query for a particular region, you can open the browser dev tools (F12), switch to Network, and copy a particular request that is made when you select an area with the rectangle selection tool.
Ah very nice, thank you kind internet friend.