
* Docs: Quick Start Images Updation in 1.7 & 1.8 * Docs: Quick Start Images Updation in 1.7 & 1.8 --------- Co-authored-by: Rounak Dhillon <rounakdhillon@Rounaks-MacBook-Air.local>
2.4 KiB
title | slug |
---|---|
Database service setup | /quick-start/getting-started/day-1/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:
-
Log in to OpenMetadata SaaS
- Navigate to Settings > Services > Databases.
- Click on Add New Service.
{% image src="/images/v1.8/getting-started/add-service.png" alt="Adding Database Service" caption="Adding Database Service" /%}
-
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.
{% image src="/images/v1.8/getting-started/select-service.png" alt="Selecting Database Service" caption="Selecting Database Service" /%}
-
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 documentationfor more information.
{% image src="/images/v1.8/getting-started/configure-connector0.png" alt="Configure Service" caption="Updating Connection Service" /%}
{% image src="/images/v1.8/getting-started/configure-connector.png" alt="Updating Connection Details" caption="Updating Connection Details" /%}
-
Test the Connection
Click Test Connection to verify the setup. This will check if OpenMetadata can reach the Snowflake service.
{% image src="/images/v1.8/getting-started/test-connection.png" alt="Verifying the Test Connection" caption="Verifying the Test Connection" /%}
-
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 pressEnter
.
Default Schema Filter Pattern
- Includes / Excludes:
To add a filter pattern, simply type it in and pressEnter
.
Default Table Filter Pattern
- Includes / Excludes:
To add a filter pattern, simply type it in and pressEnter
.
These filters help streamline the ingestion process by targeting only the relevant data assets.