> ## Documentation Index
> Fetch the complete documentation index at: https://openmetadata-fix-mcp-oauth-security-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Import Data Assets via CSV in OpenMetadata

> Learn to bulk import databases, schemas, and tables in OpenMetadata using CSV files. Edit inline, validate changes, and import via UI or API.

# Import Data Asset

Importing a Data Asset is simple. Below are the steps to bulk import various data assets, such as Databases, Schemas, and Tables.

## How to Bulk Import a Database Service

To import a Database Service:

1. Navigate to the Database Service you want to import by going to **Settings > Services > Database**.
2. For this example, we are importing in the `Snowflake` service.
3. Click on the **⋮** icon and select **Import** to download the Database Service file.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import1.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=8a95008149c23b6455d47103d4d0232c" alt="Import a Database Service" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import1.png" />

4. Upload/Drop the Database Service CSV file that you want to import. Alternatively, you can `export` an existing Database Service CSV as a template, make the necessary edits, and then upload the updated file.

Once you have the template, you can fill in the following details:

* **name** (required): This field contains the name of the database.

* **fullyQualifiedName** (required): This field contains the fully qualified name of the database service.

* **displayName**: This field holds the display name of the database.

* **description**: This field contains a detailed description or information about the database.

* **owner**: This field specifies the owner of the database.

* **tags**: This field contains the tags associated with the database.

* **glossaryTerms**: This field holds the glossary terms linked to the database.

* **tiers**: This field defines the tiers associated with the database service.

* **domain**: This field contains the domain assigned to the data asset.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import2.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=c5763df67dae15497020f3c03f15f58c" alt="Upload the Database Service CSV file" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import2.png" />

5. You can now preview the uploaded Database Service CSV file and add or modify data using the inline editor.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import3.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=9b0fe23c1db5fc3defe9403250b423e9" alt="Preview of the Database Service" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import3.png" />

6. Validate the updated Data Assets and confirm the changes. A success or failure message will then be displayed based on the outcome.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import4.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=995e9132d587bbe4485459bab1a0a700" alt="Validate the updated Data Assets" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import4.png" />

7. The Database Service has been updated successfully, and you can now view the changes in the Database Service.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import5.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=c6c431eec311165a9f0dace1b1124c3f" alt="Database Service Import successful" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import5.png" />

<Tip>
  You can also import the Database Service using the API with the following endpoint:

  `/api/v1/services/databaseServices/name/{name}/import`
  Make sure to replace `{name}` with the Fully Qualified Name (FQN) of the Database Service.
</Tip>

## How to Bulk Import a Database

To import a Database:

1. In this example, we are Importing the `DEMO` database under **Snowflake**.
2. Click on the **⋮** icon and select **Import** to upload the Database CSV file.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import6.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=8d9f0ade7372dbad84f12bfe4a4fe91d" alt="Import a Database" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import6.png" />

3. Upload/Drop the Database CSV file that you want to import. Alternatively, you can `export` an existing Database CSV as a template, make the necessary edits, and then upload the updated file.

Once you have the template, you can fill in the following details:

* **name** (required): This field contains the name of the database.

* **fullyQualifiedName** (required): This field contains the fully qualified name of the database.

* **displayName**: This field holds the display name of the database.

* **description**: This field contains a detailed description or information about the database.

* **owner**: This field specifies the owner of the database.

* **tags**: This field contains the tags associated with the database.

* **glossaryTerms**: This field holds the glossary terms linked to the database.

* **tiers**: This field defines the tiers associated with the database.

* **sourceUrl**: This field contains the Source URL of the data asset. Example for the Snowflake database: `https://app.snowflake.com/<account>/#/data/databases/DEMO/`

* **retentionPeriod**: This field contains the retention period of the data asset. Period is expressed as a duration in ISO 8601 format in UTC. Example - `P23DT23H`.

* **domain**: This field contains the domain assigned to the data asset.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import7.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=5cb8d594d84e8f098b35724a50e30619" alt="Upload the Database CSV file" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import7.png" />

4. You can now preview the uploaded Database CSV file and add or modify data using the inline editor.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import8.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=7915c10b8ffda3a94862a3a0044b1071" alt="Preview of the Database" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import8.png" />

5. Validate the updated Data Assets and confirm the changes. A success or failure message will then be displayed based on the outcome.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import9.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=41fab4141a42eadd50f53cb0d939c258" alt="Validate the updated Data Assets" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import9.png" />

6. The Database has been updated successfully, and you can now view the changes in the Database.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import10.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=ff0332b1699e98e83da08da2bea005e8" alt="Database Import successful" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import10.png" />

<Tip>
  You can also import the Database using the API with the following endpoint:

  `/api/v1/databases/name/{name}/import`
  Make sure to replace `{name}` with the Fully Qualified Name (FQN) of the Database.
</Tip>

## How to Bulk Import a Database Schema

To import a Database Schema:

1. In this example, we are importing the `JAFFLE_SHOP` schema under **Snowflake > DEMO**.
2. Click on the **⋮** icon and select **Import** to upload the Database Schema CSV file.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import11.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=88ad0ac948ee05e9b7386fef161f66ed" alt="Import a Database Schema" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import11.png" />

3. Upload/Drop the Database Schema CSV file that you want to import. Alternatively, you can `export` an existing Database Schema CSV as a template, make the necessary edits, and then upload the updated file.

Once you have the template, you can fill in the following details:

* **name** (required): This field contains the name of the database schema.

* **fullyQualifiedName** (required): This field contains the fully qualified name of the database schema.

* **displayName**: This field holds the display name of the database schema.

* **description**: This field contains a detailed description or information about the database schema.

* **owner**: This field specifies the owner of the database schema.

* **tags**: This field contains the tags associated with the database schema.

* **glossaryTerms**: This field holds the glossary terms linked to the database schema.

* **tiers**: This field defines the tiers associated with the database schema.

* **sourceUrl**: This field contains the Source URL of the data asset. Example for the Snowflake database schema: `https://app.snowflake.com/<account>/#/data/databases/DEMO/schemas/JAFFLE_SHOP`

* **retentionPeriod**: This field contains the retention period of the data asset. Period is expressed as a duration in ISO 8601 format in UTC. Example - `P23DT23H`.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import12.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=917f7a45362665ebad32372bee214739" alt="Upload the Database Schema CSV file" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import12.png" />

4. You can now preview the uploaded Database Schema CSV file and add or modify data using the inline editor.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import13.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=c9d717a2475d342ae2fd1c7e84547ec0" alt="Preview of the Database Schema" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import13.png" />

5. Validate the updated Data Assets and confirm the changes. A success or failure message will then be displayed based on the outcome.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import14.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=be4b9a30939341acf0f50c7edb8b79b1" alt="Validate the updated Data Assets" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import14.png" />

6. The Database Schema has been updated successfully, and you can now view the changes in the Database Schema.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import15.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=e70f6d54a0eb9a6a934258ead217b119" alt="Database Schema Import successful" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import15.png" />

<Tip>
  You can also import the Database Schema using the API with the following endpoint:

  `/api/v1/databaseSchemas/name/{name}/import`
  Make sure to replace `{name}` with the Fully Qualified Name (FQN) of the Database Schema.
</Tip>

## How to Bulk Import a Table

To import a Table:

1. In this example, we are importing the `CUSTOMERS` table under **Snowflake > DEMO > JAFFLE\_SHOP**.
2. Click on the **⋮** icon and select **Import** to download the Table CSV file.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import16.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=1e9899ccfdbd4e8e493ddef89fddf799" alt="Import a Table" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import16.png" />

3. Upload/Drop the Table CSV file that you want to import. Alternatively, you can `export` an existing table CSV as a template, make the necessary edits, and then upload the updated file.

Once you have the template, you can fill in the following details:

* **name**: This field contains the name of the table.

* **fullyQualifiedName** (required): This field contains the fully qualified name of the table.

* **displayName**: This field holds the display name of the table.

* **description**: This field contains a detailed description or information about the table.

* **owner**: This field specifies the owner of the table.

* **tags**: This field contains the tags associated with the table.

* **glossaryTerms**: This field holds the glossary terms linked to the table.

* **tiers**: This field defines the tiers associated with the table.

* **sourceUrl**: This field contains the Source URL of the data asset. Example for the Snowflake table: `https://app.snowflake.com/<account>/#/data/databases/DEMO/schemas/JAFFLE_SHOP/table/CUSTOMERS`

* **retentionPeriod**: This field contains the retention period of the data asset. Period is expressed as a duration in ISO 8601 format in UTC. Example - `P23DT23H`.

* **column.fullyQualifiedName** (required): This field holds the fully qualified name of the column.

* **column.displayName**: This field holds the display name of the column, if different from the technical name.

* **column.description**: This field holds a detailed description or information about the column's purpose or content.

* **column.dataTypeDisplay**: This field holds the data type for display purposes.

* **column.dataType**: This field holds the data type of the column (e.g., `VARCHAR`, `INT`, `BOOLEAN`).

* **column.arrayDataType**: If the column is an array, this field will specify the data type of the array elements.

* **column.dataLength**:  This field holds the length or size of the data.

* **column.tags**:  This field holds the Tags associated with the column, which help categorize.

* **column.glossaryTerms**:  This field holds the Glossary terms linked to the column to provide standardized definitions.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import17.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=843dea46959cffc52b1a50b1e46cfa5f" alt="Upload the Table CSV file" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import17.png" />

4. You can now preview the uploaded Table CSV file and add or modify data using the inline editor.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import18.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=a53516bfdda8c4cb71bd216c427db8a4" alt="Preview of the Table" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import18.png" />

5. Validate the updated Data Assets and confirm the changes. A success or failure message will then be displayed based on the outcome.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import19.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=e4cbd4efa05fbe4c3d072b14292f847a" alt="Validate the updated Data Assets" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import19.png" />

6. The Table has been updated successfully, and you can now view the changes in the Table.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/Vkd8Bp7BvQFAFcfr/public/images/how-to-guides/discovery/import20.png?fit=max&auto=format&n=Vkd8Bp7BvQFAFcfr&q=85&s=7e9b867d6241a8d0b4785900d5ac2242" alt="Table Import successful" width="2444" height="1384" data-path="public/images/how-to-guides/discovery/import20.png" />

<Tip>
  You can also import the Tables using the API with the following endpoint:

  `/api/v1/tables/name/{name}/import`
  Make sure to replace `{name}` with the Fully Qualified Name (FQN) of the Table.
</Tip>

<Card title="Data Asset Export" href="/v1.13.x/how-to-guides/data-discovery/export">
  Quickly export data assets as a CSV file.
</Card>