# Data tables

Data tables can be used to store data in a table format in order to enable such functionality as lookup tables

**Data tables** can be used to store data in a table format in order to enable such functionality as **lookup tables.**
Each project has a data tables tab where you can store multiple tables.
These tables can be edited directly in the UI:
![data-tables](https://tray.ai/documentation/images/connectors/core/data-tables/6GEvMcJqWr0k1woe9iRUsv_Data%20tables-1.png)
To make use of them in your workflows, they can also be accessed programatically using this connector in order to lookup, edit and report on data within the tables.

## Examples

Please see our [main documentation page on data tables](https://tray.ai/documentation/platform/automation-integration/advanced-capabilities/data-tables) for examples of using data tables as a lookup table and for managing status updates.
These show you how to make use of some key operations:

* Look up row
* Update cell in row

## Notes on using Data tables

### Updating column names

When you first go to access the columns in a table you may find that the actual names aren't present in the output schema:
![data-tables-no-col-names-in-output-schema](https://tray.ai/documentation/images/connectors/core/data-tables/5ybw5u5ZO61UvTXMHSEvwZ_data-tables-no-col-names-in-output-schema.png)
To fix this you can put a **Terminate** step after the Data tables connector and trigger a run.
You can then click the 'Use output' button in the debug logs to update the schema:
![data-tables-click-use-output-to-fix-schema](https://tray.ai/documentation/images/connectors/core/data-tables/1wpsaILgneEiY8nf2ayMe7_data-tables-click-use-output-to-fix-schema.png)
Once this is remedied you will be able to reference the columns in the subsequent workflow steps:\
![data-tables-fixed-output-schema](https://tray.ai/documentation/images/connectors/core/data-tables/68xRIELUXAIt3tV7TzUtWM_data-tables-fixed-output-schema.png)

### Data tables and Embedded customers

The current version of data tables cannot be accessed from within an end-user solution instance.

### Exporting and Importing projects with data tables

When exporting projects with data tables please remap the data table in the target workspace after importing

### Storage capacity

Please note the following parameters when working with Data tables:

* Character limit per cell: **255**
* Maximum number of rows: **20,000**
* Columns: **8 by default, 16 max**
* Data limit: 5**0 MB**
* Data type: \*\*String \*\*(use text Helpers 'change type' if required)

### Uploading CSV files

You can import CSV file using **Import CSV** option.
![import csv](https://tray.ai/documentation/images/connectors/core/data-tables/2nayqkp7dvWEN52eVU94GX_import_csv.png)
CSV files are subject to the storage limits:
![import csv-1](https://tray.ai/documentation/images/connectors/core/data-tables/3kKintpjtBVsCwBT8seDTd_import_csv-1.png)
The next modal will display information about the uploaded CSV. Please name your data table to complete the process.
![import csv-2](https://tray.ai/documentation/images/connectors/core/data-tables/3KD4sLd8MfNixXd0J0X4ya_import_csv-2.png)

### Pasting information

It is possible to copy / paste cells and rows from another spreadsheet directly into your Data table. Such as copying and pasting information from a Google Spreadsheet.
However please be aware of the following before doing so:

* You cannot copy / paste into the column headers - they must be entered individually
* You can only copy one row at a time

### Delete a column

You can delete any column from a data table.
![delete-column](https://tray.ai/documentation/images/connectors/core/data-tables/3L46s4YTU6elMdGyt3gDRB_delete-column.png)