LogoLogo
About UsCustomersResourcesGet Started for Free
  • What is Select Star?
  • 🏁Getting Started
    • 1. Data Source Setup
    • 2. Mark Service Accounts
    • 3. Hide Unwanted Datasets
    • 4. Invite Owners
    • 5. Add Documentation
    • Next Steps
  • 🔄Integrations
    • Snowflake
      • Using Key Pair Authentication
      • Using Password Authentication
      • Snowflake Tag Sync
      • Snowflake Key Pair Rotation
    • Databricks
      • Databricks on AWS
      • Databricks on Azure
    • BigQuery
    • AWS Redshift
      • Manual setup
    • Microsoft SQL Server / MS SQL (beta)
      • Query Logs
    • MySQL (beta)
      • Query Logs
    • Oracle (beta)
      • Query Logs
    • Salesforce (beta)
    • DB2 (beta)
    • PostgreSQL
      • AWS Aurora PostgreSQL
      • AWS RDS PostgreSQL
      • PostgreSQL on-prem
    • AWS Glue (beta)
    • dbt
      • dbt Cloud
      • dbt Core (open source)
      • dbt Tags
      • dbt Tests
      • dbt docs Sync
        • Github dbt docs Sync
        • Bitbucket dbt docs Sync
      • dbt Impact Report
      • dbt Project Dependencies
    • Apache Airflow (beta)
    • Tableau
      • Tableau Cloud
      • Tableau Server
    • PowerBI
    • Looker
    • Metabase
    • Fivetran (beta)
    • Mode
    • Sigma Computing
    • Sisense / Periscope (beta)
    • Looker Studio (beta)
    • ThoughtSpot
    • QuickSight (beta)
      • Event Logs
    • Hex (beta)
    • Slack
    • Monte Carlo
    • Private Network
    • Request an Integration
  • ✨Features
    • Search
    • Table Page
    • Database Page
    • Dashboard Page
    • Data Lineage
    • Entity Relationship Diagram (ERD)
    • Queries & Joins
    • Tags
    • Teams
    • Discussion
    • Downstream Notifications
    • Documentation
      • Pages
      • Metrics
        • Metrics Generation
      • Glossary
    • Automated Documentation
    • User Analytics
    • Chrome Extension
    • Source Tables
    • Cost Analysis
    • Schema Change Detection
    • AI Features & Settings
      • Ask AI Chatbot
    • Request a Feature
  • 🧭Data Discovery
    • Where's my data?
    • Where's my dashboard?
    • How can I get the full context of this data?
    • My dashboard looks off
    • Change management
    • I'm new to the team
    • I have a data question
  • 🗃️Data Management
    • Add Documentation
      • CSV Metadata Upload
    • Collections
    • Tags
    • Data Ownership
    • Sensitive / PII Data
    • Automated PII Detection
  • 📚Learning Data
    • Getting Started: Looker
    • Getting Started: Mode
    • Getting Started: Tableau
    • Getting Started: Snowflake
    • Getting Started: Databricks
    • Getting Started: Data Warehouse
    • Getting Started: BigQuery
      • Nested Fields
    • Getting Started: Sigma
    • Getting Started: ThoughtSpot
  • 🛠️Data Source Management
    • Manage Data Sources
    • Connect Data Source Users to Select Star
    • Custom Attributes
    • Recent Queries
  • 👥User Management
    • Invite Users
    • Roles & Permissions
    • SAML SSO
    • Importing Roles and Teams (Okta)
    • Policy Based Access Control
    • Account and User Settings
  • 💻Select Star API
    • Overview
    • API Token
    • Getting Started
    • Rich Text Descriptions via API
    • Troubleshooting
    • API Examples
    • API Reference
  • 🔓Security & Compliance
  • ❓FAQ
    • Icon Map
  • 📰Changelog
    • April 16, 2025 - Semantic Models, AI Metrics, and More!
    • March 12, 2025 - Fivetran Integration, Tableau Updates and More!
    • February 6, 2025 - Collections, Slack App Published, Salesforce Formula Lineage and more!
    • December 10, 2024 - Hex Integration, Impact Score & Snowflake Key Pair Authentication!
    • November 13, 2024 - New Navigation, Airflow and More!
    • September 30, 2024 - Upstream Data Quality Issue Tracking & 5 New Integrations!
    • August 30, 2024 - Monte Carlo, dbt Cross-Project Lineage
    • July 31, 2024 - Glossary Import, Lineage Updates & more!
    • July 9, 2024 - Lineage Explorer 2.0, Slack AI and Notifications
    • February 29, 2024 - AI Chat, Schema Change Notifications
    • February 23, 2024 - Manual Lineage Creation
    • November 23, 2023 - Bulk AI Documentation
    • October 19, 2023 - Downstream Notifications
    • October 16, 2023 - New Homepage
    • October 13, 2023 - dbt Impact Report
    • Historical Changelogs
  • Security & Compliance
  • System Status
Powered by GitBook
On this page
  • Metadata Upload
  • Understanding the CSV Template

Was this helpful?

  1. Data Management
  2. Add Documentation

CSV Metadata Upload

PreviousAdd DocumentationNextCollections

Last updated 9 months ago

Was this helpful?

Metadata Upload

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.

If you want to modify or upload or other information in batches for different datasources, you can do so by using our .

Go to Settings.

Click Metadata Upload under the Data Manager section.

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

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:

DATABASE_NAME
SCHEMA_NAME
TABLE_NAME
COLUMN_NAME
DESCRIPTION
BUSINESS_OWNER
TECHNICAL_OWNER

OLIST

DATASETS

ORDERS

ORDER_ID

Unique identifier of the order.

OLIST

DATASETS

ORDERS

This table has information about all orders.

john.doe@olist.com

jane.doe@olist.com

OLIST

This is database contains all information regarding orders made to the Olist store, including raw data and analytics/reporting data.

If you need help understanding the CSV Template, see .

🗃️
below
Admins and Data Managers
Rest API