> For the complete documentation index, see [llms.txt](https://docs.selectstar.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.selectstar.com/data-management/add-documentation/csv-metadata-upload.md).

# CSV Metadata Upload

Streamline metadata management with ease with bulk table and column description CSV uploads. Learn how to upload in our docs.

## Metadata Upload

[Admins and Data Managers](/user-management/user-roles.md) can quickly update table and column descriptions for Data Warehouse connections in bulk by uploading a CSV file.

This comes in handy when you have the DWH available in CSV format or can export it easily from a different tool.

{% hint style="info" %}
If you want to modify or upload or other information in batches for different datasources, you can do so by using our [Rest API](/select-star-api.md).
{% endhint %}

Go to **Settings**.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-869fa9b96c8e2bfb9d4bdc48d1b6d29dd3cea07a%2FSettings%20Menu.png?alt=media\&token=84d93b8a-4c0e-474e-8101-77c426295cd2)

Click **Metadata Upload** under the **Data Manager** section.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-3be88cdc7ce55952a6dd97c507345e4d5bba7ba9%2FMetadata%20Upload?alt=media\&token=8f0960e2-486b-45c8-b6de-5a73e77b158a)

Download the `.csv` template and you can add the metadata you want to change. Then Upload the CSV.

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-2b5cafbc81e2d84ee7d5581d7422582fc5b0ce8f%2FMetadata%20upload%20csv.png?alt=media\&token=63067fad-4e7b-4b9a-8180-0983c2d6b1e2)

If you need help understanding the CSV Template, see [below](#understanding-the-csv-template).

Once descriptions are saved in Select Star, they will be indexed by the search engine and show up in search results right away.

## Understanding the CSV Template

The template currently accepts the following fields:

* DATABASE\_NAME
* SCHEMA\_NAME (**Note:** Currently, documentation cannot be added at the Schema Level)
* TABLE\_NAME
* COLUMN\_NAME
* DESCRIPTION
* BUSINESS\_OWNER
* TECHNICAL\_OWNER

When you fill out the `.csv` template, make sure you understand the following:

1. Each row represents a metadata update
2. Owners can only be applied at the table level
3. Owner fields are emails of individual users with Select Star accounts
4. You can add Descriptions and Owners in the same row
5. **Fields are required up to the level of the documented data**

To explain point #5 further, consider an example where the database structure is as follows:

* **Database** **Name:** `OLIST`
* **Schema Name:** `DATASETS`
* **Table Name:** `ORDERS`
* **Column Name:** `ORDER_ID`

To add a description for a **column**, put a row in the spreadsheet including the **Database Name, Schema Name, Table Name,** and **Column Name**.

To add a description for a **table**, include the **Database Name, Schema Name**, and **Table Name**.

To add a description for a **database**, include only the **Database Name**.

To illustrate points #2-4, Owners are added in this example to the table only:

<table><thead><tr><th width="123">DATABASE_NAME</th><th width="116">SCHEMA_NAME</th><th>TABLE_NAME</th><th width="123">COLUMN_NAME</th><th>DESCRIPTION</th><th>BUSINESS_OWNER</th><th>TECHNICAL_OWNER</th></tr></thead><tbody><tr><td>OLIST</td><td>DATASETS</td><td>ORDERS</td><td>ORDER_ID</td><td>Unique identifier of the order.</td><td></td><td></td></tr><tr><td>OLIST</td><td>DATASETS</td><td>ORDERS</td><td></td><td>This table has information about all orders.</td><td>john.doe@olist.com</td><td>jane.doe@olist.com</td></tr><tr><td>OLIST</td><td></td><td></td><td></td><td>This is database contains all information regarding orders made to the Olist store, including raw data and analytics/reporting data.</td><td></td><td></td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.selectstar.com/data-management/add-documentation/csv-metadata-upload.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.