You can upload a CSV file in the UI to create a reference table. The input CSV file must be well-formed, which means the following:

• Every row must have the same number of columns
• The type of each row must be consistent with the schema, if specified
• Header is optional
• The column names in the header must be a valid dataset column name
• File size can be up to 10 MiB.

Create a reference table

Perform the following steps to upload a CSV file and create a reference table.

1. Log into your Observe instance, and click Add Data from the left menu.
2. Click CSV file.
3. Give a name to your reference table.
4. Upload your CSV file.
5. Select a primary key.
6. Optionally, change the type of columns, such as String, Integer, Float, or Boolean.
7. Click Save changes.

You can also create a reference table from the Dataset page. See Create a reference table from the Dataset page.

Update a reference table

Perform the following steps to upload a new CSV file and update a reference table.

1. Upload a new CSV file to replace the existing one.
2. Click Save changes.

Delete a reference table

Perform the following steps to delete a reference table.

1. Go to the Datasets page
2. Find the reference table you want to delete.
3. Click the pencil icon.
4. Click the three dots on the right side of the reference table.
5. Click Delete.