> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Export Data Assets via CSV

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

# Export Data Assets

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. Click the **Profile** icon and select **Settings** > **Services** > **Database**.
2. Select a database service you want to export. For example, we are exporting the `Snowflake` service.
3. Click **Settings** and select **Export** to export the database service.

   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/export-db-service.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=8f47154be644accc9c66744fc31f788a" alt="Export Database Service CSV File" width="2814" height="1404" data-path="public/images/ai-2.0/data-discovery/export-db-service.png" />

<Tip>
  **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. Click the **Profile** icon and select **Settings** > **Services** > **Database**.

2. Select a database service whose database you want to export.

3. Click the **Databases** tab and select the database you want to export.

   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/access-db-service.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=0ab8198c19460e0c9f4a0d662e123ed8" alt="Access Database" width="2792" height="1134" data-path="public/images/ai-2.0/data-discovery/access-db-service.png" />

4. Click the **⋮** icon and select **Export** to export the database.

   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/export-db.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=134d1435a94c5990bf9c83d9cbcb5a44" alt="Export a Database" width="2782" height="1110" data-path="public/images/ai-2.0/data-discovery/export-db.png" />

<Tip>
  **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. Navigate to the database whose schema you want to export.

2. In the **Database Schema** tab, select the schema you want to export. For example, `JAFFLE_SHOP` in the following image.
   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/select-db-schema.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=fd868541259f8d6825cfdcc8151aeb63" alt="Select Database Schema" width="2768" height="1582" data-path="public/images/ai-2.0/data-discovery/select-db-schema.png" />

3. Click the **⋮** icon and select **Export** to download the database schema.
   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/export-db-schema.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=c96c121df3d7c5fdbde4dc8abf9d0299" alt="Export a Database Schema" width="2786" height="1396" data-path="public/images/ai-2.0/data-discovery/export-db-schema.png" />

<Tip>
  **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 Tables

1. Navigate to the database schema whose table you want to export.
2. In the **Tables** tab, select the table you want to export.
   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/select-db-table.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=9a2cbe92ff0c9c785c7f4137bb16159a" alt="Select Database Table" width="2778" height="1330" data-path="public/images/ai-2.0/data-discovery/select-db-table.png" />
3. Click the **⋮** icon and select **Export** to download the table CSV file.
   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/export-db-table.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=700c725a3360be3de81f5138d8552ab4" alt="Export Database Table" width="2798" height="1082" data-path="public/images/ai-2.0/data-discovery/export-db-table.png" />

<Tip>
  **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="/ai-2-0/how-to-guides/data-discovery/import">
  Quickly import data assets from a CSV file.
</Card>