Integration Model and Core Concepts

A PawSQL integration begins with a repository change and ends with a traceable SQL quality decision. The following objects form the contract between the source platform, the pipeline, and PawSQL.

Core Concepts

Concept	Purpose
Trigger event	A push, pull request, merge request, or manual pipeline run
SQL change set	SQL files and statements added or modified by the change
Integration configuration	Maps repositories and branches to PawSQL projects
Workspace	Supplies the database engine, version, schema, indexes, and optional statistics
Review policy	Selects rules, parameters, and severities
Review job	Stores input SQL, findings, recommendations, and processing state
Quality gate	Converts review evidence into pass, warn, or block
External run identity	Links the PawSQL job to a commit, review, or pipeline execution

Prerequisites

No special prerequisites.

Steps

Understand how the trigger event, SQL change set, integration configuration, workspace, review policy, review job, quality gate, and external run identity form the contract between the source platform, the pipeline, and PawSQL.

Review scope

Mode	Best for	Consideration
Incremental	Routine pull requests	Requires a reliable comparison baseline
Full repository	Initial onboarding or scheduled baselines	More complete but slower
Selected paths	Centralized migration directories	Keep path rules under change control
Selected files	Manual verification and diagnostics	Should not replace the automated gate

Idempotency and freshness

Treat repeated delivery of the same repository event as one logical run. Use the platform event ID when available. A new head commit must invalidate the previous decision, and only the latest commit may satisfy a merge requirement.

A passing review means the SQL satisfies the active policy. It does not execute the SQL or replace business validation, change approval, or database release controls.

Expected Result

You can map any repository change to a traceable SQL quality decision through the objects described on this page.

Verification

Confirm each concept on this page maps to your platform, pipeline, and PawSQL configuration.

Integration Model and Core Concepts

Core Concepts

Prerequisites

Steps

Review scope

Idempotency and freshness

Expected Result

Verification

Prerequisites and Security

SQL Quality Gates and Feedback

Workspaces

​Core Concepts

​Prerequisites

​Steps

​Review scope

​Idempotency and freshness

​Expected Result

​Verification

​Related documents

Prerequisites and Security

SQL Quality Gates and Feedback

Workspaces

Core Concepts

Prerequisites

Steps

Review scope

Idempotency and freshness

Expected Result

Verification

Related documents