# Tables

Tables are brought into a workflow via its Data sources, and are then created as the output of various [transforms](https://docs.redivis.com/reference/workflows/transforms) and [notebooks](https://docs.redivis.com/reference/workflows/notebooks) in the workflow. Tables often serve to materialize intermediary results, sanity check an output, as well as final data derivative representing the culmination of your analysis pipeline.

Workflow tables follow the behavior and functionality of [tables across Redivis](https://docs.redivis.com/reference/tables).

<figure><img src="https://1672950126-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LVodLwUXgJUGcm5Cvso%2Fuploads%2FQnjK3aQYPuft10FFvv1d%2FScreenshot%202024-12-03%20at%2012.21.33%E2%80%AFPM_out.png?alt=media&#x26;token=3c77497c-b235-453f-a57c-10851cb30c97" alt=""><figcaption></figcaption></figure>

## Usage in workflows

All table nodes have one upstream parent, either a data source, a transform, or a notebook.&#x20;

On each table, you can create any number of transforms or notebooks, which then reference that table as their "source". Tables can also be joined into transforms and notebooks that do not have the table as their primary source.

## Table node states

As you work in a workflow, nodes colors and symbols will change on the tree view to help you keep track of your work progress.

<table><thead><tr><th width="162.33333333333331">State</th><th width="136">Display</th><th>Details</th></tr></thead><tbody><tr><td><strong>Empty</strong></td><td>White background</td><td>A table node will be empty when it contains no data because the upstream node has not been executed.</td></tr><tr><td><strong>Executed</strong></td><td>Grey background</td><td>A table node will be grey when it has data that aligns with the contents of its upstream node. </td></tr><tr><td><strong>Stale</strong></td><td>Yellow background</td><td>A table node will be stale when an upstream change has been made. This means the content of the node does not match the content of the node above it.</td></tr><tr><td><strong>Sampled</strong></td><td>Black circle with 1% icon</td><td>Only relevant to dataset tables: This means that you are using a 1% <a href="../datasets/samples">sample</a> of the table. When a dataset has a sample, it will automatically default to it when added to a workflow. You can change this to the full sample and back at any time in the <a href="data-sources">dataset node</a>.</td></tr><tr><td><strong>Incomplete access</strong></td><td>All black background, or dashed borders</td><td>You don't have full access the table. Click on the <strong>Incomplete access</strong> button in the top bar to begin applying for access to the relevant datasets.</td></tr><tr><td><strong>Archived</strong></td><td><code>archived</code> pill</td><td>The table has been <a href="../archival-and-deletion#archival">archived</a>, and only its metadata is available. You'll need to re-run the upstream node in order to unarchive the table.</td></tr></tbody></table>