Any table on Redivis can be either be saved for future use or immediately exported — subject to the export restrictions placed on any source dataset(s) by those datasets' administrators.
All saving and export options are made available through the table information dialogue. Select the table that you'd like to export, and then click the "Export" button.
This modal gives you options to download the table and its metadata in common formats. It also provides the ability to save the table to your workspace.
If there are any restrictions around downloading the table or dataset, they will be listed here. You can select different formats to download (CSV, SAS, SPSS, Stata, Newline-delimited JSON, and AVRO). Depending on whether this table or dataset has been downloaded before, you might need to wait for Redivis to generate the table in the specified format.
Certain datasets may have export restrictions that have been applied by an administrator. These restrictions include limits to the number of records and bytes that may be exported in one table, as well as the IP address(es) that they may be exported to.
A table that is derived from multiple datasets will always inherit the strictest rules from one of its ancestors, or in the case of IP addresses, will only accept the intersection of addresses allowed by its ancestors.
If your table exceeds the record or byte limit, you may still request an exception — when you save the table to your workspace (see below), the saved table's status will be marked as "pending". An administrator will then have the ability to approve the saved table, granting an exception to the export size restrictions. Note that any IP address restrictions will still apply — you must be logged in from a computer with a valid IP address when these restrictions are present.
Redivis supports the following download formats and limits:
Exports as CSV + load script
All tables and saved tables allow you to download a SQL file with all code that was generated to create that table.
Additionally, you can download a table or dataset's metadata as a structured JSON file, containing the table's information and all its variables with their names, types, labels, descriptions, and value labels (when present).
If you want to save a snapshot of the current table for future reference, or need administrator approval for data download, you can save it to your workspace. This snapshot will persist even if the current table is overwritten or its project is deleted.
A saved tables allows for the same data and metadata download functionality as the table from which it is generated.