DQ + PostgreSQL

DQ connects to PostgreSQL 11 and above, including managed instances on AWS RDS, Google Cloud SQL, Supabase, and Railway. No agent installation required. DQ reads from your database using a standard connection string and read-only credentials.

What You Get

• Full schema profiling. DQ reads information_schema to discover all tables and columns, then profiles each column across all six quality dimensions: completeness, uniqueness, validity, consistency, integrity, and accuracy.
• Row-level sampling. DQ samples up to 1 million rows per table for the initial profile. Configurable sample size for large tables.
• Foreign key integrity. DQ reads declared FK constraints and validates referential integrity automatically.
• Scheduled monitoring. Set a profiling schedule (hourly, daily, weekly) per table. DQ alerts on dimension score degradation via webhook or email.
• Lineage from views. DQ parses pg_views definitions using sqlglot to build table-to-table and column-to-column lineage graphs.

How to Connect

1. Create a read-only PostgreSQL user: CREATE USER dq_reader WITH PASSWORD 'your_password';
2. Grant read access: GRANT CONNECT ON DATABASE your_db TO dq_reader; and GRANT SELECT ON ALL TABLES IN SCHEMA public TO dq_reader;
3. In the DQ dashboard, navigate to Datasources → Add New → PostgreSQL.
4. Enter your connection string: postgresql://dq_reader:your_password@host:5432/your_db
5. Click Test Connection to verify connectivity.
6. Click Run Profile to start the first profiling run. Results appear within 90 seconds for tables under 1 million rows.

For tables in non-public schemas, add ?options=-csearch_path%3Dyour_schema to the connection string or grant access to specific schemas in step 2.

See /pricing for datasource limits per plan. For the full profiling methodology, see /docs.

---

About DQ. DQ is the data quality engine that profiles, validates, and remediates your tables in 90 seconds. Built by K/20X Labs.