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

# Database service setup

## Setting Up a Database Service for Metadata Extraction

You can quickly set up a database service for metadata extraction in OpenMetadata SaaS. Below is an example of how to configure a connection using the `Snowflake` Connector:

1. ### Log in to OpenMetadata SaaS

* Navigate to **Settings > Services > Databases**.
* Click on **Add New Service**.

<img src="https://mintcdn.com/collatedocs/x9hR_QWXd39IXESB/public/images/getting-started/add-service.png?fit=max&auto=format&n=x9hR_QWXd39IXESB&q=85&s=e425fc1fe7fb288dba32f979a5ee5d81" alt="Adding Database Service" width="2876" height="1000" data-path="public/images/getting-started/add-service.png" />

2. ### Select Database Type

* Choose the database type for your service. In this example, select `Snowflake`.
* Enter the required details, such as the **Name** and **Description**, to identify the database.

<img src="https://mintcdn.com/collatedocs/x9hR_QWXd39IXESB/public/images/getting-started/select-service.png?fit=max&auto=format&n=x9hR_QWXd39IXESB&q=85&s=9a04a1c18ce01413c13201b8c26d886a" alt="Selecting Database Service" width="870" height="1212" data-path="public/images/getting-started/select-service.png" />

3. ### Enter Connection Details

* Provide the necessary connection parameters, such as hostname, port, credentials, etc.
* The side panel offers guidance with available documentation, and you can also refer to the specific `Snowflake` Connector [documentation](/connectors)for more information.

<img src="https://mintcdn.com/collatedocs/x9hR_QWXd39IXESB/public/images/getting-started/configure-connector.png?fit=max&auto=format&n=x9hR_QWXd39IXESB&q=85&s=d1a3142f9c3204c07129cb15cb361332" alt="Configure Service" width="2733" height="1271" data-path="public/images/getting-started/configure-connector.png" />

<img src="https://mintcdn.com/collatedocs/x9hR_QWXd39IXESB/public/images/getting-started/configure-connector.png?fit=max&auto=format&n=x9hR_QWXd39IXESB&q=85&s=d1a3142f9c3204c07129cb15cb361332" alt="Updating Connection Details" width="2733" height="1271" data-path="public/images/getting-started/configure-connector.png" />

4. ### Test the Connection

Click Test Connection to verify the setup. This will check if OpenMetadata can reach the Snowflake service.

<img src="https://mintcdn.com/collatedocs/x9hR_QWXd39IXESB/public/images/getting-started/test-connection.png?fit=max&auto=format&n=x9hR_QWXd39IXESB&q=85&s=e152b3290f68dbcfc410b47cf71bba55" alt="Verifying the Test Connection" width="994" height="754" data-path="public/images/getting-started/test-connection.png" />

5. ### Set Default Data Filters

Configure default filters to control which databases, schemas, and tables are included or excluded during ingestion.

#### Default Database Filter Pattern

* **Includes / Excludes**:
  To add a filter pattern, simply type it in and press `Enter`.

#### Default Schema Filter Pattern

* **Includes / Excludes**:
  To add a filter pattern, simply type it in and press `Enter`.

#### Default Table Filter Pattern

* **Includes / Excludes**:
  To add a filter pattern, simply type it in and press `Enter`.

These filters help streamline the ingestion process by targeting only the relevant data assets.
