Adding a Data Source

New in Version 6.1

Only Workspace Admins & Platform Admins can add, edit or delete a Source

Before anyone can import tables, profile data, or create rules, a Workspace Admin needs to connect KDQ Agentic to a data source. Everything downstream — tables, profiles, rules — depends on this first step.


Supported source types

Read access to data is required to perform a DQ Test.

Source type

What you'll need

Authentication method supported

PostgreSQL

Host, port, database name, username, password


SQL Server

Host, port, database name, username, password


Snowflake

Account, username, and either a key pair or OAuth credentials


Amazon Redshift

Host, port, database name, and credentials


Databricks

Server hostname, HTTP path, and catalog name



Adding a source

  • Open the workspace and go to Sources.

  • Click Add Source and choose the source type.

  • Enter the connection details for your source.

  • Run the connection test before saving — KDQ Agentic checks it can actually reach the source with the details you've entered, and flags anything wrong before you commit to it.

  • Save the source once the test passes.

⚠️ The authentication method can't be changed after a source is created. Confirm you're using the right method (e.g. key pair vs OAuth for Snowflake) before saving.

Connection secrets are encrypted and masked — they're never shown again once saved, including to Workspace Admins. If you need to rotate a credential, edit the source and re-enter it; this re-encrypts and re-tests the connection.


Keeping a source in sync

  • Rescan a source to detect schema drift (new, changed, or removed columns) since it was last imported. Anyone in the workspace can view scan run history; only a Workspace Admin can trigger a rescan.

  • Re-discover a saved source to refresh the list of tables and databases available to import from.


Deleting a source

Before you delete a source, KDQ Agentic shows a cascade impact view — everything that depends on it (imported tables, rules, schedule groups) so you know what you're about to affect before you confirm.


Change history

Version 6.1 ·

  • NEW   Adding and managing KDQ Agentic data sources (PostgreSQL, Snowflake, SQL Server, Redshift, Databricks).

Last updated: