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

# Database service setup

> Configure a database service connection in OpenMetadata and prepare it for metadata ingestion.

# 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/openmetadata-fix-mcp-oauth-security-docs/FRpiRXpaqp9C1EB8/public/images/getting-started/add-service.png?fit=max&auto=format&n=FRpiRXpaqp9C1EB8&q=85&s=73f79bb82bc1085142c0c806c8353a94" 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/openmetadata-fix-mcp-oauth-security-docs/FRpiRXpaqp9C1EB8/public/images/getting-started/select-service.png?fit=max&auto=format&n=FRpiRXpaqp9C1EB8&q=85&s=531f2cc2ccd27c0a336f18aa293ca0bc" 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](/v1.12.x/connectors)for more information.

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/FRpiRXpaqp9C1EB8/public/images/getting-started/configure-connector.png?fit=max&auto=format&n=FRpiRXpaqp9C1EB8&q=85&s=0c77cd0a15a69362c0dcb109118db272" alt="Configure Service" width="2733" height="1271" data-path="public/images/getting-started/configure-connector.png" />

<img src="https://mintcdn.com/openmetadata-fix-mcp-oauth-security-docs/FRpiRXpaqp9C1EB8/public/images/getting-started/configure-connector.png?fit=max&auto=format&n=FRpiRXpaqp9C1EB8&q=85&s=0c77cd0a15a69362c0dcb109118db272" 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/openmetadata-fix-mcp-oauth-security-docs/FRpiRXpaqp9C1EB8/public/images/getting-started/test-connection.png?fit=max&auto=format&n=FRpiRXpaqp9C1EB8&q=85&s=42b6b45fe7ffe3cea1d9fbd05fb81b6e" 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.
