Connection creation for DB / Warehouse

This is a first step in the uArrow Data Quality.

We need to create a connection for a target cloud warehouse / database and need to specify the database parameters.

Once we create the connection we can define DataQuality rules for datasets / tables.

Create Connection
Below are the steps to create snowflake connection in the uArrow Application:
1. Click on Connections menu

2. Choose relevant database / warehouse (+)  button, In this example I am using snowflake warehouse to register connection in uArrow.

3. Provide the connection details to register in uArrow

Parameter Name Description
Connection name Specify the name of the source connection.
Host Enter the name of machine where the snowflake cloud warehouse  instance is located, it should be computer name, fully qualified domain name, or IP address.
Port Enter the port number to connect to this snowflake cloud warehouse. Four digit integer, Default: 443
User Enter the user name of the snowflake cloud warehouse, The user name to use for authentication on the snowflake warehouse.
Password Enter the snowflake user’s password. The password to use for authentication on the snowflake warehouse.
Advanced JDBC properties
db Enter an existing snowflake database name
schema Name of the existing snowflake database schema
role Provide snowflake warehouse role name
warehouse Specify existing snowflake warehouse name

4. Select existing Jira Connection in Jira Connection Id if jira connection registered in uArrow already.

5. After connection details, validate connection to verify connection details provided are correct.

6. Save the connection.

View Connections
In order to see the list of existing connections and their details we need to click on relevant warehouse / database icon (As highlighted in below image).

Once we click on the card we can see the list of connections created under the target warehouse.

  • For each connection, uArrow provides following information from database / warehouse metadata like below
    • Tables count,
    • Connection description,
    • Created user,
    • Last Modified time
    • Last refresh time
  • You can also able to perform below Actions
    • Metadata: uArrow would fetch latest metadata information about datasets from database / warehouse configured in connection.
    • Edit: To edit the existing connection.

 

View DataSets
Click on View Tables -> To see the list of datasets under the connection configured.

For each dataset / table, you can able to

DataQuality: Create/View Data Quality rules
DQ Report: To view data quality job dashboard report if already run.
Metadata: To refresh table / dataset level metadata refresh if any changes in database.

Menu