Download
Overview
Through the table export modal, you can easily export full data in several common file formats, as well as the table metadata.
In order to download a table on Redivis, navigate to that table on the dataset page or within your workflow. Click the Export table button at right to open the table export modal.
The export modal gives you options to download the table and its metadata in common formats, as well as using integrations or other programmatic interfaces. You can also export the entire SQL that was generated to create the table (see More menu in the top right of the workflow), facilitating reproducibility and reference in other systems.
If there are any restrictions around downloading the table or dataset, they will be listed here. If a restriction is preventing you from downloading the data, you will be able to apply for approval, if allowed.
Download data
You can download any table on Redivis assuming that: 1) you have data access to the table; 2) there are no export restrictions on the dataset, or your export is not in conflict with these restrictions.
To download the table's data, select your file type and click the Download button. Depending on the size of the table, and whether it was recently downloaded, it may take anywhere from a few seconds to several minutes to generate the file.
Downloading unstructured data files
If this is an index table that contains unstructured data, you will also be able to download a ZIP of all the files represented within that table.
Export types
Redivis supports the following export formats:
CSV
JSON-lines
Avro
Parquet
dta (Stata)
sav (SPSS)
sas7bdat (via CSV + load script)
Exports are subject to the corresponding export quotas and limits >
As a general rule, be cautious when using Excel to open .csv files. Never re-save a .csv that’s been opened in Excel, as the data may be modified.
Metadata and SQL downloads
On every table, you can download a tables metadata as a structured JSON file, containing information about the table as well as all its variables with their names, types, labels, descriptions, and value labels (when present). The schema of this file is the same as that returned by the table.get API endpoint. Use the Download metadata tab of the table export modal, shown below.
If your table is in a workflow, you can also download a SQL file (via the More menu at the top right of the workflow) that contains the complete code used to generate your output. This code represents a full traversal of your workflow tree, and captures the exact statement necessary to generate the output table at that point in time.
Last updated
Was this helpful?