Skip to main content

Viewing and Exporting Results

After executing a query, Datadata provides multiple ways to view and export results.

Result Views​

Table View​

Query results display in a table by default, with support for:

  • Column sorting (click headers)
  • Column width adjustment
  • Pagination

Chart View​

Click the chart button in the toolbar to switch to visualization:

  • Line chart, bar chart, K-line chart
  • Heatmap, scatter plot
  • Pie chart, area chart

Exporting Data​

Download as NDJSON​

Each record as a JSON line:

curl -H "Authorization: Bearer YOUR_API_KEY" \
"https://www.datadata.com/api/v1/queries/{id}/results?format=ndjson"

Download as CSV​

Suitable for Excel or other spreadsheet tools:

curl -H "Authorization: Bearer YOUR_API_KEY" \
"https://www.datadata.com/api/v1/queries/{id}/results?format=csv"

Export from UI​

In the query results page, click the Export button and select NDJSON or CSV format.

Scheduled Queries​

You can set up scheduled execution for queries. Results are automatically saved. Configure schedules in the Query Schedules page in the Studio sidebar.