← Back to context

Comment by nickphx

2 years ago

Is it possible to export a report of traffic by a selected region?

2 comments

nickphx

Reply
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.