Querying and visualizing remote data
DuckDB-WASM supports the loading of compatible data in different formats (e.g. CSV, Parquet or Arrow) from remote http(s) sources. Other data formats that can be used include JSON, but this requires the loading of so-called DuckDB extensions.
IMPORTANT
It's necessary that the websites hosting the data add the relevant CORS headers, otherwise the browser (not DuckDB-WASM or the SQL Workbench) will forbid the loading of the files and show an error message instead.
In this example, we will use data about AWS CloudFront Edge Locations, that is available at tobilg/aws-edge-locations.
The result will look like this:
We now want to create a bar chart of the data, showing the number of Edge Locations by country and city. This can be done by hovering over the result table, and clicking on the small "configure" button that looks like a wrench which subsequently appears on the upper right corner of the table:
You then see the overview of the available columns, and the current visualization type (Datagrid in this case).
To get an overview of the possible visualization types click on the Datagrid icon on the right-hand side:
Then select "Y Bar". This will give you an initial bar chart of the data:
But as we want to display the count of Edge Locations by country and city, we need to drag-and-drop the columns
country and city to the "Group By" area:
We can now close the configuration menu to see the chart in it's full size:
There are many other visualization types from which you can choose from, such as Treemaps and Sunbursts, as well as Map Scatters:
