Source Datastores Overview
Source Datastores are the foundation of data quality management in Qualytics. A source datastore represents a connection to your data — whether it's a relational database (JDBC), a distributed file system (DFS), or a cloud storage service.
In this section you will find:
- Datastore — Learn the fundamentals (JDBC and DFS), set up connections, browse supported connectors, use multi-schema creation, and add, edit, or delete datastores.
- Operations — Run Sync, Profile, Scan, and External Scan operations to catalog your data, infer quality checks, and detect anomalies.
- Enrichment Datastore — Link an enrichment datastore to persist scan results, anomalies, source record examples, and remediation data to your own infrastructure.
- Data Quality Score — Configure scoring weights, decay periods, and thresholds to measure and track the health of your data over time.
- Grouping — Organize datastores into custom groups by environment, team, domain, or priority for easier navigation in the tree view.
- Tags — Assign tags to datastores to categorize, filter operations by tag, and influence quality score weighting.
- Tips & Tricks — Discover right-click options and keyboard shortcuts to navigate and manage datastores faster.
Datastore
Understanding
-
Getting Started
Understand what a datastore is, the architecture behind it, and how to get started.
-
JDBC
Connect relational databases using JDBC connectors like PostgreSQL, Snowflake, Oracle, and more.
-
DFS
Connect distributed file systems like Amazon S3, Azure Data Lake Storage, and Google Cloud Storage.
Connections
-
Connection Introduction
Learn what connections are, their role in datastore setup, and key concepts.
-
How Connections Work
Connection lifecycle, authentication methods, secrets management, and network requirements.
-
Available Connectors
Browse the full list of supported JDBC and DFS connectors.
Multiple-Schema
-
Multiple-Schema Introduction
Discover and onboard multiple schemas from a single connection in one step.
-
How Multi-Schema Works
Schema discovery flow, name templates, catalog/schema hierarchy, and validation.
-
Supported Connectors (Multi-Schema)
Which connectors support multi-schema discovery and their catalog/schema mappings.
-
Multi-Schema Permissions
Roles and team permissions required for multi-schema creation and validation.
-
Multi-Schema FAQ
Connectors, enrichment linking, naming, batch limits, and troubleshooting.
Managing
-
Add with New Connection
Create a new source datastore by setting up a new connection from scratch.
-
Add with Existing Connection
Create a new source datastore by reusing credentials from an existing connection.
-
Edit Datastore
Modify your datastore's connection scope, teams, or other properties.
-
Delete Datastore
Permanently remove a datastore and all its associated data.
-
Datastore API
Create, update, delete, bulk create, link enrichment, and manage datastores programmatically.
-
Datastore FAQ
Connections, creating, managing, enrichment, operations, and troubleshooting.
Operations
-
Sync
Detect new, changed, or removed containers and fields in the source datastore.
-
Profile
Analyze records to assess data quality, generate metadata, and infer quality checks.
-
Scan
Enforce data quality checks and identify anomalies at the record and schema levels.
-
External Scan
Run scan operations using externally provided data files.
Enrichment Datastore
-
Getting Started
Overview of enrichment datastores, supported connectors, and all managing pages.
-
Introduction
How enrichment works, settings, remediation strategies, side effects, and sharing.
-
Permissions
Roles and team permissions for linking, unlinking, and configuring enrichment.
-
Link Enrichment Datastore
Link a source datastore to an enrichment datastore through the Settings menu or tree footer.
-
Link on Datastore Creation
Link an enrichment datastore during the datastore creation wizard.
-
Unlink Enrichment Datastore
Remove the enrichment link from a source datastore.
-
Supported Enrichment Datastores
Which connectors support enrichment and their write-back capabilities.
-
Enrichment API
Link, unlink, and update enrichment settings programmatically.
-
Enrichment FAQ
Remediation strategies, prefix conflicts, storage, re-linking, and troubleshooting.
Data Quality Score
-
Getting Started
Overview of quality scores, dimensions, settings, weighting, and all managing pages.
-
Introduction
Score hierarchy, the 8 dimensions, decay period, weights, independent settings, and recalculations.
-
Permissions
Roles and team permissions for viewing scores and editing settings.
-
Settings
Configure decay period and dimension weights for your datastore.
-
Quality Score API
Retrieve and update score settings and access historical score snapshots.
-
Quality Score FAQ
Baseline, dimensions, decay, independent settings, troubleshooting, and more.
Grouping
-
Getting Started
Overview of datastore grouping, permissions, and all managing pages.
-
Introduction
How groups work, key characteristics, favorites interaction, and best practices.
-
Permissions
Two permission layers for group management and datastore assignment.
-
Create a Group
Create a new datastore group with a custom name and icon.
-
Edit a Group
Rename a group or change its icon.
-
Delete a Group
Remove a group — datastores in the group become ungrouped.
-
Assign a Datastore to a Group
Assign a datastore to an existing group from the tree view.
-
Unassign a Datastore from a Group
Unassign a datastore from its current group. The datastore moves to Ungrouped.
-
Filter by Group
Filter the Source Datastores listing page to show only datastores in specific groups.
-
Grouping API
Create, update, delete groups and assign/unassign datastores programmatically.
-
Grouping FAQ
Groups vs tags, favorites, permissions, limits, filter behavior, and more.
Tags
-
Getting Started
Overview of datastore tags, permissions, and all managing pages.
-
Introduction
Tag inheritance, operation filtering, quality score impact, and weight modifiers.
-
Permissions
Roles and team permissions for viewing, assigning, and unassigning tags.
-
Assign a Tag
Assign an existing tag to a source datastore from the tree view footer.
-
Unassign a Tag
Remove a tag from a source datastore without deleting the tag itself.
-
Tags API
Assign, unassign, and query tags on datastores via the datastore update endpoint.
-
Tags FAQ
Inheritance, permissions, weight modifiers, storage, re-linking, and troubleshooting.
Tips & Tricks
-
Right Click Options
Quick actions available via right-click on datastores in the tree view, listing, and breadcrumb.
-
Keyboard Shortcuts
Speed up common datastore actions with keyboard shortcuts and the Command Bar.