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 by Snowflake instance, and click Data & integrations > 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 edit a reference table:

1. In the left nevigation, click Datasets to access the Datasets Explorer.
2. Find the reference table you want to edit.
3. Hover on the row of the reference table you want to edit and click the table cells icon () to open the Dataset page.

You can update this reference table by uploading a new CSV, or by making edits to individual cells.

Click Save reference table when you are done with your updates.

Delete a reference table

Perform the following steps to delete a reference table.

1. In the left nevigation, click Datasets to access the Datasets Explorer.
2. Find the reference table you want to delete.
3. Hover on the row of the reference table you want to delete and click the table cells icon () to open the Dataset page.
4. Click the vertical ellipsis icon () and select Delete.