Redivis Documentation
API DocumentationRedivis Home
  • Introduction
  • Redivis for open science
    • FAIR data practices
    • Open access
    • Data repository characteristics
    • Data retention policy
    • Citations
  • Guides
    • Getting started
    • Discover & access data
      • Discover datasets
      • Apply to access restricted data
      • Create a study
    • Analyze data in a workflow
      • Reshape data in transforms
      • Work with data in notebooks
      • Running ML workloads
      • Example workflows
        • Analyzing large tabular data
        • Create an image classification model
        • Fine tuning a Large Language Model (LLM)
        • No-code visualization
        • Continuous enrollment
        • Select first/last encounter
    • Export & publish your work
      • Export to other environments
      • Build your own site with Observable
    • Create & manage datasets
      • Create and populate a dataset
      • Upload tabular data as tables
      • Upload unstructured data as files
      • Cleaning tabular data
    • Administer an organization
      • Configure access systems
      • Grant access to data
      • Generate a report
      • Example tasks
        • Emailing subsets of members
    • Video guides
  • Reference
    • Your account
      • Creating an account
      • Managing logins
      • Single Sign-On (SSO)
      • Workspace
      • Studies
      • Compute credits and billing
    • Datasets
      • Documentation
      • Tables
      • Variables
      • Files
      • Creating & editing datasets
      • Uploading data
        • Tabular data
        • Geospatial data
        • Unstructured data
        • Metadata
        • Data sources
        • Programmatic uploads
      • Version control
      • Sampling
      • Exporting data
        • Download
        • Programmatic
        • Google Data Studio
        • Google Cloud Storage
        • Google BigQuery
        • Embedding tables
    • Workflows
      • Workflow concepts
      • Documentation
      • Data sources
      • Tables
      • Transforms
        • Transform concepts
        • Step: Aggregate
        • Step: Create variables
        • Step: Filter
        • Step: Join
        • Step: Limit
        • Step: Stack
        • Step: Order
        • Step: Pivot
        • Step: Rename
        • Step: Retype
        • Step: SQL query
        • Variable selection
        • Value lists
        • Optimization and errors
        • Variable creation methods
          • Common elements
          • Aggregate
          • Case (if/else)
          • Date
          • DateTime
          • Geography
          • JSON
          • Math
          • Navigation
          • Numbering
          • Other
          • Statistical
          • String
          • Time
      • Notebooks
        • Notebook concepts
        • Compute resources
        • Python notebooks
        • R notebooks
        • Stata notebooks
        • SAS notebooks
        • Using the Jupyter interface
      • Access and privacy
    • Data access
      • Access levels
      • Configuring access
      • Requesting access
      • Approving access
      • Usage rules
      • Data access in workflows
    • Organizations
      • Administrator panel
      • Members
      • Studies
      • Workflows
      • Datasets
      • Permission groups
      • Requirements
      • Reports
      • Logs
      • Billing
      • Settings and branding
        • Account
        • Public profile
        • Membership
        • Export environments
        • Advanced: DOI configuration
        • Advanced: Stata & SAS setup
        • Advanced: Data storage locations
        • Advanced: Data egress configuration
    • Institutions
      • Administrator panel
      • Organizations
      • Members
      • Datasets
      • Reports
      • Settings and branding
    • Quotas and limits
    • Glossary
  • Additional Resources
    • Events and press
    • API documentation
    • Redivis Labs
    • Office hours
    • Contact us
    • More information
      • Product updates
      • Roadmap
      • System status
      • Security
      • Feature requests
      • Report a bug
Powered by GitBook
On this page
  • Overview
  • Download data
  • Downloading unstructured data files
  • Export types
  • Metadata and SQL downloads

Was this helpful?

Export as PDF
  1. Reference
  2. Datasets
  3. Exporting data

Download

Last updated 4 months ago

Was this helpful?

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.

Download data

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)

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

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.

The export modal gives you options to download the table and its metadata in common formats, as well as using or other 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 , if allowed.

You can download any table on Redivis assuming that: 1) you have ; 2) there are no on the dataset, or your export is not in conflict with these restrictions.

To download the table's data, select your 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.

Exports are subject to the

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 . Use the Download metadata tab of the table export modal, shown below.

integrations
programmatic
table.get API endpoint
file type
apply for approval
export restrictions
Export any table by clicking the "Export table" button
Download metadata
data access to the table
corresponding export quotas and limits >