You can create and manage datastores from the Datastore page.

Create a datastore

To create a datastore:

1. Navigate to the Datastore page.

2. Click + New Datastore.

3. Enter a Name for your datastore.

4. Enter a Primary Key or toggle the option to Autogenerate a Primary Key if a primary key is not essential to your use case.

   • If you choose to enter a primary key, the key must be a column name in your data where each key has a unique value.
   • Choosing to Autogenerate a key removes your ability to provide your own keys for new items in the datastore, but you can still update existing items by specifying their keys.

5. Optionally, enter a Description for your datastore.

6. Optionally, you can seed your datastore with initial data from a JSON or CSV file. Use one of the following methods to upload the contents of the file:

   • Drag and drop the file into the UI.
   • Click browse files to browse and select a file from your computer.
   • Copy a CSV file on your computer and use Ctrl/Cmd + V to paste it.

   The CSV or JSON file must include a header row with a column that matches your Primary Key.

7. Click Create. A confirmation pop-up window appears with options to create a workflow or app from your datastore, or view the datastore.

Create from an app or workflow

You can create a datastore from an app or workflow by clicking the Datastore ID button in a datastore action and selecting New Datastore.

Edit a datastore

Manually edit your data

To manually edit a row in your datastore:

1. On the Datastore page, locate your datastore and click to open it.
2. Hover over the row you want to change and click the pencil (Edit) icon.
3. Use the JSON or Raw text tabs to edit keys in the row.

Note: You cannot manually edit the primary key in a row. If you need to edit a primary key, delete the row and re-add it or re-upload the data from a file.

Update using a file

To update a datastore using a file:

1. On the Datastore page, locate your datastore and click to open it.
2. Click Add Data.
3. Select an option for how your data should be handled.
   • Overwrite replaces existing rows in your table with the data for your file.
   • Append adds the rows in your file to the existing dataset. The append option does not allow you to add duplicate entries to your dataset.
4. Click Add.

View a datastore

To view a datastore, locate your datastore on the Datastore page and click to open it.

After you’ve opened a datastore, you can:

• Export the dataset to a JSON or CSV file.
• Click Columns to show or hide table columns.
• Click Create to create a workflow or app from the datastore.
• Click Add data to add data from a CSV or JSON file.

The Table Options button allows you to:

• Edit the datastore permissions.
• Copy the datastore UUID, which is useful for apps with multiple datastore references.
• Clone the datastore.
• Delete the datastore.

Limitations

Datastores have the following limitations:

• A datastore can contain up to 5,000 rows.
• A primary key column of type string is required and must uniquely identify each row.
• Each row can be up to 100 KB in size.
• The primary-key value is immutable, it cannot be changed after the row is created.

Reach out to support if you have a use case that exceeds these limits.

Further reading

Additional helpful documentation, links, and articles:

Build AppsDOCUMENTATION Build WorkflowsDOCUMENTATION Enhance your automated workflows and apps with DatastoreBLOG