Feature request: export csv/Excel from a filter/search operation run against a Mosaic table? about mosaic HOT 2 CLOSED

You can most likely implement this directly yourself. If you want to create a CSV file stored on your local server:

1. Get the query for the (filtered) table you want
2. Use that query to issue a new query that writes a CSV file

For example:

import { coordinator } from '@uwdata/vgplot';

// get query for Mosaic client, filtered according to any filterBy selection
const query = client.query(client.filterBy?.predicate(client));

// write CSV file for table to local server (will likely not work with WASM)
const csvQuery = `COPY (${query}) TO 'query.csv' WITH (HEADER 1, DELIMITER ',')`;
await coordinator().exec(csvQuery);

Note that I haven't tested the above. It might be possible to get something similar to work against DuckDB-WASM but you'd have to investigate what (if any) CSV export options DuckDB-WASM provides. Alternatively, you might instead use coordinator().query(query) and then convert the resulting Arrow table to whatever output format you want:

import { coordinator } from '@uwdata/vgplot';

// get query for Mosaic client, filtered according to any filterBy selection
const query = client.query(client.filterBy?.predicate(client));

// get arrow table for query
const data = await coordinator().query(query);
// ...now use JS to convert arrow data to your desired output format

A different approach would be to get the current data table from a client, then map that to CSV yourself using JS methods. For example, most vgplot marks store their data as client.data. However, different clients may differ in how they do (or do not) expose their data and this may be subject to change over time, so this is not a reliable approach.

from mosaic.

Incredibly helpful -- thank you so much Jeff!! Will do 🙏

from mosaic.