Skip to content

Setting up OpenMetadata

Logging into the OpenMetadata UI

To access the OpenMetadata UI, go to http://localhost:8585 and log in using credentials defined in the initial setup step.

  • Email: This will consist of two environment variables from .env.om_server in the form below. The default email is admin@open-metadata.org.

    AUTHORIZER_ADMIN_PRINCIPALS@AUTHORIZER_PRINCIPAL_DOMAIN

  • Password: the default password will be admin. You should probably change that password on your first login.

Note

If you're hosting the ADWH system on another machine, replace localhost with the domain name or IP addess of that remote machine.

Define a Connection to the Data Warehouse Database

  1. Go to Settings > Services > Databases and Add a New Service

  2. Make a Postgres Database Service

    2.a. Enter a name and a brief description of the database.

    2.b. Enter credentials for the DWH database role you want the service to use along with the other connection info. After entering credentials and other info, Test your Connection.

    If all connection checks pass, click OK and Save the connection.

If everything was successful, you should now see your ADWH Data Warehouse Database Service.

Configure Metadata Ingestion

Contuing from the last image, go to the page for the ADWH Data Warehouse Database Service. You will see the different postgres databases in the dwh_db postgres instance.

To scan those databases for Data Assets to catalog, you have to configure an Ingestion.

  1. Click Ingestions > Add Ingestion > Add Metadata Ingestion

  2. Specify the assets to include in this Metadata Ingestion configuration

    Enter regex patterns to specify which database(s), schema(s), and table(s) should be included.

  3. Set the schedule for running this Ingestion then Add & Deploy it

  4. Trigger an initial Run to immediately run the Metadata Ingestion

Now you should have a catalog of metadata for all Data Assets in the main DWH schemas.

Changing your password

  1. From the user profile dropdown in the upper right corner, click your username to addess your user page

  2. Change your password