Skip to main content
Save the result of a filter or aggregation on a data item as a CSV or Parquet file, and get a download link.

Save to a file

dataframe export filters and aggregates with the same inputs as dataset query and saves the result as a file. Use it when the result is too large for dataset query.
Replace <dataset_id> with the id of a data item. The result below was run on the data Sales Orders (id hI6jK7lM8n). The download_url line (the download link) is trimmed, so the JSON below is an excerpt, not a complete JSON. Result
The download link expires in 15 minutes and works only for the same signed-in user. Choose the format with --format. The default is csv (UTF-8 with BOM, which opens correctly in Excel). Use --output to choose where to save the file. The example above creates the file on the server and returns a download link. Nothing is saved on your computer. To save it on your computer, add --output:
When the file is saved, the result shows saved (the path) and bytes.
If result shows rows and expires_at, the file is saved on the server. If saved and bytes are shown, it is saved on your computer too.

When downloading is not allowed

For data whose publisher does not allow downloading it as a file, dataframe export fails with DATA_EGRESS_LIMIT.
The result below was run on the data with the id US-Home-Sales-1963-2016-gH3iJ4kL5m. Result
In this case, use fetch or dataframe get-schema for what the publisher shares, or open the URL in the browser. A message can name a tool, such as dataframe_get_schema. Run expl server tools describe <tool_name> to see the command for that tool.
If error_code is DATA_EGRESS_LIMIT, this data cannot be saved as a file.

Troubleshooting

Every flag is described in dataframe export, and how to filter and aggregate in dataset query.