> ## 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.

# Import Data Assets

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

# Import Data Assets

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

## How to Import a Database Service

To import a Database Service:

1. Click the **Profile** icon and navigate to **Settings** > **Services** > **Database**.

2. Select a database service you want to import. For example, we are importing the `Snowflake` service.

3. Click **Settings** and select **Import** to download the Database Service file.

   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/import-database-service.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=38318bdc7632f644e8e1aed71e34e18f" alt="Import a Database Service" width="2804" height="1320" data-path="public/images/ai-2.0/data-discovery/import-database-service.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/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/upload-database-service.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=62a49f8dc077363785ad18dfb193157b" alt="Upload the Database Service CSV file" width="2758" height="1330" data-path="public/images/ai-2.0/data-discovery/upload-database-service.png" />

5. Review the preview of your uploaded data. Make any additions or corrections directly in the table if needed. A **Passed** and **Failed** count is displayed above the table to help you quickly identify any rows with validation errors before proceeding.

   Click **Next**.

   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/preview-db-service.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=0fa0be91836c077706217c099c767b83" alt="Preview of the Database Service" width="2740" height="1580" data-path="public/images/ai-2.0/data-discovery/preview-db-service.png" />

6. After the database service is uploaded, you can view the changes in the database service.

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

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

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

   <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 **Import** to upload the database CSV file.

   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/import-database.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=9354ab5764cf6b0bf8ae4685aaadb6c5" alt="Import a Database" width="2782" height="1104" data-path="public/images/ai-2.0/data-discovery/import-database.png" />

5. 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/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/upload-database.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=82aa13578328f6d8fce97f2f3beb6983" alt="Upload the Database CSV file" width="2766" height="1296" data-path="public/images/ai-2.0/data-discovery/upload-database.png" />

6. Review the preview of your uploaded data. Make any additions or corrections directly in the table if needed. A **Passed** and **Failed** count is displayed above the table to help you quickly identify any rows with validation errors before proceeding.

   Click **Next**.

   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/preview-db-service.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=0fa0be91836c077706217c099c767b83" alt="Preview of the Database Service" width="2740" height="1580" data-path="public/images/ai-2.0/data-discovery/preview-db-service.png" />

7. After the database is uploaded, you can view the uploaded database in the **Databases** tab.

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

2. In the **Database Schema** tab, select the schema you want to import. 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 **Import** to upload the database schema CSV file.
   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/select-schema-import.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=91660c832a72ba4ef42059bda74f36f7" alt="Import a Database Schema" width="2780" height="1058" data-path="public/images/ai-2.0/data-discovery/select-schema-import.png" />

4. 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/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/upload-db-schema.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=d9207f7c92515d3762e4855c3e70c097" alt="Upload the Database Schema CSV file" width="2778" height="1340" data-path="public/images/ai-2.0/data-discovery/upload-db-schema.png" />

   Click **Next Preview**.

5. Review the preview of your uploaded data. Make any additions or corrections directly in the table if needed. A **Passed** and **Failed** count is displayed above the table to help you quickly identify any rows with validation errors before proceeding.

   Click **Next**.

   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/preview-db-schema.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=3512d44183a00be4dd762076b58bb45b" alt="Preview of the Database Schema" width="2637" height="1340" data-path="public/images/ai-2.0/data-discovery/preview-db-schema.png" />

6. After successful import, you can view the uploaded database schemas listed under the **Database Schema** tab.

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

2. In the **Tables** tab, select the table you want to import.
   <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 **Import** to upload the table CSV file.
   <img src="https://mintcdn.com/collatedocs/-lrw-eBbNcdV_Qdw/public/images/ai-2.0/data-discovery/import-db-table.png?fit=max&auto=format&n=-lrw-eBbNcdV_Qdw&q=85&s=10cd2130f18c6a864ba3facca7fe4a6b" alt="Import Database Table" width="2822" height="1236" data-path="public/images/ai-2.0/data-discovery/import-db-table.png" />

4. 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 specifies 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 it.

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

   Click **Next Preview**.

   <img src="https://mintcdn.com/collatedocs/LUQwLPA4Y6ndbf92/public/images/ai-2.0/data-discovery/upload-db-table.png?fit=max&auto=format&n=LUQwLPA4Y6ndbf92&q=85&s=53b46eecc760625e7b488893e229ec22" alt="Preview of the Table" width="2798" height="1310" data-path="public/images/ai-2.0/data-discovery/upload-db-table.png" />

5. Review the preview of your uploaded data. Make any additions or corrections directly in the table if needed. A **Passed** and **Failed** count is displayed above the table to help you quickly identify any rows with validation errors before proceeding.

   Click **Next**.

6. After successful import, you can view the uploaded database tables listed under the **Tables** tab.

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