> ## 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 Export Data Assets via CSV in OpenMetadata

> Learn to bulk export database services, databases, schemas, and tables in OpenMetadata as CSV files using the UI or API.

# Export Data Asset

Exporting a Data Asset is simple. Below are the steps to bulk export various data assets, such as Database Services, Databases, Schemas, and Tables.

## How to Bulk Export a Database Service

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

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

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

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

## How to Bulk Export a Database

1. In this example, we are exporting in the `DEMO` database under **Snowflake**.
2. Click on the **⋮** icon and select **Export** to download the Database CSV file.

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

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

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

## How to Bulk Export a Database Schema

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

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

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

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

## How to Bulk Export a Tables

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

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

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

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

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