Connect GX Cloud to PostgreSQL

Prerequisites

• You have a GX Cloud account with Workspace Editor permissions or greater.

• You have a PostgreSQL database, schema, and table or view.

• Optional. pgAdmin.

Connect to a PostgreSQL Data Source and add a Data Asset

1. In GX Cloud, select the relevant Workspace and then click Data Assets > New Data Asset > New Data Source > PostgreSQL.

2. Enter a meaningful name for the Data Source in the Data Source name field.

3. Enter a connection string in the Connection string field. The connection string format is:

   PostgreSQL connection string

   postgresql+psycopg2://YourUserName:YourPassword@YourHostName:5432/YourDatabaseName?options=-csearch_path%3DYourSchemaName

4. Click Connect.

5. Select one or more tables or views to import as Data Assets.

6. Click Add x Asset(s).

7. Decide which Anomaly Detection options you want to enable. By default, GX Cloud adds warning-severity Expectations to detect Schema and Volume anomalies. You can de-select recommendations you’d like to opt out of. You can choose to generate Expectations to detect Completeness anomalies.

8. Click Start monitoring or Finish.

Next steps

• Add an Expectation.
• Run a Validation.