# Overview

Tables are the "container" for all data on Redivis. They are made of rows and columns, where a row represents an individual entry or observation, and the column represents a [Variable](/reference/tables/variables.md).

Tables belong to either a [Dataset](/reference/datasets.md) or a [Workflow](/reference/workflows.md). In datasets, tables are created by [uploading data](/reference/datasets/create-and-edit-datasets/import-sources.md). In workflows, tables are created as the resulting output of a [transform](/reference/workflows/transforms.md) or [notebook](/reference/workflows/notebooks.md).

Tables can be used for analysis within a [Workflow](/reference/workflows.md). Alternatively, they can be [exported](/reference/tables/exporting-tables.md) for analysis in other environments.

{% embed url="<https://redivis.com/datasets/7br5-41440fjzk/tables/6fff-7hqb797cb>" %}
Embedded view of a table with 2.7B records. Click around to interact!
{% endembed %}

## Table characteristics

| Field              | Notes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| ------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Name**           | The table's name. If in a dataset, must be unique across all tables for that version of the dataset. If in a workflow, must be unique across all tables currently in the workflow.                                                                                                                                                                                                                                                                                                        |
| **Description**    | Optional. A free-form description of the table's contents. May not exceed 5000 characters.                                                                                                                                                                                                                                                                                                                                                                                                |
| **Bibliography**   | This table's citation, and any recorded related identifiers.                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Variable count** | Total number of variables in the table.                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| **Row count**      | Total number of rows, or records, in the table.                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| **Size**           | Total size of the table, in bytes.                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| **Entity**         | Optional. The concept that one record in this table represents. For example, the table's entity might represent a unique patient, or a specific hospitalization, or a prescription.                                                                                                                                                                                                                                                                                                       |
| **Temporal range** | <p>Optional. The range of time that this table covers. This can either be set manually, or calculated from the min/max of a particular variable.</p><p></p><p>If calculated from a variable, that variable must have <a href="/pages/-LWB1uR_T2-TGoCmPoAN#variable-types">type</a> <code>date</code>, <code>dateTime</code>, or <code>integer</code>. If the variable is an integer, its values will be assumed to represent a year and must be in the range <code>\[0, 9999]</code>.</p> |
| **Sample**         | If this table is sampled, you will see a marker for whether you are looking at the full dataset or the 1% sample. To interact with sampled tables, add the dataset to a workflow.                                                                                                                                                                                                                                                                                                         |

## Table types

*All* data on Redivis is stored within a table, including geospatial data and unstructured files:

### Tabular

Tabular data is, unsurprisingly, stored within a table on Redivis, with its rows and columns mapped to the table's rows and variables. Table contents can be viewed in the [cells viewer](/reference/tables/cells.md), [queried](/reference/tables/queries.md), downloaded, and read into [various programming interfaces](/reference/workflows/notebooks/notebook-concepts.md) as a tabular data frame.

### Geospatial

Geospatial data is also stored within tables on Redivis. Each row maps to a geospatial feature, with various feature metadata encoded as variables, alongside a `geometry` variable that encodes the actual feature (which could be a point, line, polygon, multi-polygon, etc).

When viewing the cells, you can preview a given geographic feature by hovering (or clicking) on the value in the cells view. Geospatial tables can also be queried (taking advantage of various [geography methods](/reference/workflows/transforms/variable-creation-methods/geography.md)), [exported](/reference/tables/exporting-tables/download.md), or read as geospatial data frame in [various programming interfaces](/reference/workflows/notebooks/notebook-concepts.md).&#x20;

{% embed url="<https://redivis.com/embed/tables/demo.us_forest_service_fires:5k9t:current.us_fire_perimeters:9r58#cells>" %}
Embeded view of a table with geospatial data
{% endembed %}

### Files

When data files aren't inherently tabular or geospatial (e.g., a collection of 1 million images), they can still be uploaded to a dataset. In this case, these individual data files are also represented within a table, often referred to as a "file index table". Each record in the table represents a single file, with a globally unique `file_id` variable, as well as other variables containing metadata about the file.

When viewing the cells, you can preview a given file by hovering (or clicking) on the `file_id` value. The metadata in file index tables can also be queried, potentially allowing you to join on file names, or extract a subset of files based on certain characteristics. Finally, these files can be read and downloaded via [various programming interfaces](/reference/workflows/notebooks/notebook-concepts.md), or [exported](/reference/tables/exporting-tables/download.md#downloading-unstructured-data-files) via the interface.&#x20;

{% embed url="<https://redivis.com/embed/tables/demo.example_data_files:yz1s:current.training_images:a62k#cells>" %}
Embedded view of a file index table
{% endembed %}

## Access

Access to a particular table will always be governed by the owner(s) associated with the table's contents.

**For tables within a dataset**, your access to a table will be the same as [access to that dataset](/reference/data-access.md). You must have [metadata](https://docs.redivis.com/reference/tables/pages/-LVpRE_xV5XhQZ2tUTYu#id-2.-metadata) access in order to view variable names and summary statistics, and [data](https://docs.redivis.com/reference/tables/pages/-LVpRE_xV5XhQZ2tUTYu#id-4.-data) access in order to view cells, run queries, and export data.

**For tables within a workflow**, you must both have [view access](/reference/workflows/collaboration-and-sharing.md) to the workflow, as well as corresponding access to *all* datasets whose data is present in that table. For example, if a particular workflow combines content from two datasets into a new output table, you'll need access to both datasets to view the table.

## Bibliography

All tables automatically encode information about their lineage on Redivis. For example, if a table is created within a dataset, then transformed in a workflow, which is then forked into another workflow and joined with a new dataset, *all* of the information about the source datasets and workflows that created the table will be present in its bibliography.&#x20;

This allows you to authoritatively cite any table on Redivis, making sure to credit everyone whose work contributed to a final output!

<figure><img src="/files/UBfMh4b7YkPQsQi68RUj" alt=""><figcaption></figcaption></figure>

*For editors: How to import* [*tabular*](/reference/datasets/create-and-edit-datasets/import-tabular-data.md) *or* [*geospatial*](/reference/datasets/create-and-edit-datasets/import-geospatial-data.md) *data into datasets.*


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.redivis.com/reference/tables/overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
