Connecting OpenMetadata to our database

Now that we have configured our Data Discovery tool, let’s create a sample connection to our local database instance. Let’s try to use PostgreSQL to do an easy integration and practice another database usage.

Getting ready

First, ensure our application runs appropriately by accessing the http://localhost:8585/my-data address.

Note

Inside OpenMetadata, the user must have the Data Steward or Administration role to create connections. You can switch to the admin user using the previous credentials we saw.

You can check the Docker status here:

Figure 3.16 – Active containers are shown in the Docker desktop application

Use PostgreSQL for testing. Since we already have a Google project ready, let us create a SQL instance using the PostgreSQL engine.

As we kept the queries to create the database and tables in Chapter 2, we can build it again in Postgres. The queries can also be found...