Direct exports

Overview

Through the download interface, you can easily export table metadata, reproducible SQL code, and full data in several common file formats.

In order to download a table on Redivis, navigate to that table on the dataset page or within your project. Click the Download button at top-right to open the table download interface.

Open a table from the dataset page and click the download icon
Select a table within a project and click

The download modal gives you options to download the table and its metadata in common formats. You can also export the entire SQL that was generated to create the table, 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 an exception, if allowed. This interface also provides information about interfacing with the table via the REST API.

Download metadata and SQL, view restrictions, and consult the API reference in the download interface

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.

If your table is in a project, you can also download a SQL file that contains the complete code used to generate your output. This code represents a full traversal of your project tree, and captures the exact statement necessary to generate the output table at that point in time.

Data downloads

You can export 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 download format and click the Generate file 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. Once it's been generated, you will be provided with a download link.

Generate your export file to download

Download formats

The download interface allows you to export your data in several common formats, subject to the following limits:

File type

Max size

Includes variable metadata?

Notes

.csv

100GB

No

.ndjson

100GB

No

Newline-delimited JSON

.dta (Stata)

5GB, 100GB

Yes

For > 5GB downloads, export as CSV + .do load script

.sav (SPSS)

5GB

Yes

.sas7bdat (SAS)

100GB

Yes

Exports as CSV + .sas load script

AVRO

1GB

No

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.