> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dqlabs.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Integration

> How Prizm pushes quality data to Alation catalog pages, what Prizm pulls from Alation, and how to manage catalog sync jobs.

<script type="application/ld+json">
  {`{
            "@context": "https://schema.org",
            "@type": "TechArticle",
            "headline": "Alation Integration",
            "description": "How Prizm pushes quality data to Alation catalog pages, what Prizm pulls from Alation, and how to manage catalog sync jobs.",
            "url": "https://docs.dqlabs.ai/integrations/alation/integration",
            "publisher": {
              "@type": "Organization",
              "name": "DQLabs Inc",
              "logo": "https://media.brand.dev/332adc35-5bc4-4d2b-bf78-256aa4a5e414.svg"
            }
            }`}
</script>

## How the Alation integration works

Once the Alation integration is configured and active, Prizm runs a `CATALOG_SYNC` job to synchronize quality data with your Alation catalog. On the push side, quality scores, alerts, issues, and measure results appear on Alation table and column pages — visible to anyone browsing the catalog. On the pull side, Alation domain assignments and tags are imported into Prizm and surface as metadata on asset detail pages.

Sync jobs can be monitored and managed from the Prizm integration log. You can kill a running job, restart a completed or failed job, and view per-job logs.

***

## What appears in Alation after a push

### Asset (table) pages

When Asset push is enabled, the following quality data appears on Alation table catalog pages:

**Deprecation and Warning flags** — visible as flag indicators on the table overview row. A Deprecation flag appears when Prizm has identified open issues with the table. A Warning flag appears when Prizm has identified active alerts.

**DQLABS custom field section** — a rich text custom field named DQLABS appears in the table Overview tab and is populated with the following metrics:

| DQLabs Metric      | Description                                              |
| ------------------ | -------------------------------------------------------- |
| **DQ Score**       | Overall data quality score for the asset (e.g., 0.0%)    |
| **Total Rows**     | Total row count of the table                             |
| **Freshness**      | Time elapsed since the last data load (e.g., 59d 8h 21m) |
| **Passed Rules**   | Number of quality rules that passed                      |
| **Failed Rules**   | Number of quality rules that failed                      |
| **Valid Rows**     | Number of rows that passed all quality checks            |
| **Invalid Rows**   | Number of rows that failed one or more quality checks    |
| **Duplicate Rows** | Count of duplicate rows detected                         |
| **Total Alerts**   | Total number of active alerts on the asset               |
| **Total Issues**   | Total number of open issues on the asset                 |

**Health tab** — a dedicated Health tab is added to the Alation asset page and populated with all data quality checks from Prizm. The Health tab shows each quality check as a row with Rule name, Object Name, Status, Value, Description, and Last Updated timestamp. This gives catalog users a comprehensive view of all quality rules evaluated against the table.

### Attribute (column) pages

When Attribute push is enabled, the following quality data appears on Alation column catalog pages:

**Warning and Deprecation indicators** — flag indicators appear on the column overview row to surface active alerts or issues at the column level.

**DQLABS custom field section** — the DQ Score for the column appears in the column's DQLABS custom field, allowing analysts to see the quality score for individual attributes directly on the column catalog page.

### Domain pages

When Domain push is enabled, Prizm pushes domain-level metrics and semantic context to Alation domain catalog entries. The push mode (Auto, Semantics, Custom) controls how Prizm maps data to Alation domain fields.

***

## What Prizm pulls from Alation

When PULL is enabled, Prizm imports the following on each sync cycle:

**Domains** — Alation domain assignments are imported into Prizm as domain metadata on the corresponding assets.

**Tags** — Alation tags are imported and applied to the corresponding assets in Prizm.

Pulled metadata appears on the **Semantics** page for each object in Prizm with the source type labeled **"Alation"**. This context helps data engineers working in Prizm understand the business classification and ownership of an asset without cross-referencing the catalog.

***

## Metrics pushed per sync event

For every standalone measure evaluation, Prizm pushes the following to Alation:

* **Alert Details** — details of any active alerts triggered by the measure
* **Issue Details** — details of any open issues linked to the measure
* **Summary Update** — updated quality summary reflecting the latest evaluation
* **Standalone Measure** — the measure result itself (value, threshold, pass/fail status)

***

## Job management

Every Alation sync run creates a `CATALOG_SYNC` job in Prizm. You can view, manage, and diagnose jobs from the integration log page.

### Accessing the job log

Navigate to **Organization** → **Integration**, find the Alation entry, and click the log icon to open the job log. You can also navigate directly from the integration list view.

### Job log columns

| Column              | Description                                       |
| ------------------- | ------------------------------------------------- |
| **Name**            | Job identifier                                    |
| **Type**            | Job type — always `CATALOG_SYNC` for Alation jobs |
| **Start Time**      | When the job started                              |
| **End Time**        | When the job completed or was killed              |
| **Duration**        | Total elapsed time for the job                    |
| **Completed Tasks** | Number of sync tasks that completed successfully  |
| **Failed Tasks**    | Number of sync tasks that failed                  |
| **Status**          | Current job status (Running, Completed, Failed)   |
| **Action**          | Available actions for the job                     |

### Job overview metrics

The top of the log page shows aggregate counts across all jobs:

* **Total Runs** — number of times the sync has run
* **Failed Runs** — number of runs that ended with one or more failed tasks
* **Pending Runs** — number of jobs currently queued or running
* **Completed Runs** — number of runs that finished without failures

### Job actions

**Kill** — stops a currently running job. Use this if a sync job is running longer than expected or consuming excessive resources.

**Restart** — reruns a completed or failed job. Useful after fixing a connectivity issue or updating push configuration.

<Note>
  Killing a running job stops it mid-sync. Assets that were already updated in Alation before the job was killed retain their changes. Assets not yet reached by the job remain at their previous state until the next sync.
</Note>

***

## Scheduling

Sync jobs can run on a fixed schedule independent of individual asset or measure evaluation events.

**Schedule intervals:** Minutes, Hours, Days, Weeks, Month

When a schedule is configured:

* Automatic per-asset and per-measure sync triggers are disabled
* The integration runs a full push of all configured metrics on each schedule interval
* Scheduled job runs appear in the job log alongside manually triggered runs

<Tip>
  Schedule the Alation sync to run shortly after your metric evaluation jobs complete. If metrics evaluate at midnight, setting the Alation sync to run at 1 AM ensures the quality scores pushed to Alation always reflect the most recent results rather than scores from the previous cycle.
</Tip>

***

## Manual sync

To trigger a sync outside the schedule, navigate to **Organization** → **Integration**, find the Alation entry, and use the available sync action. Prizm creates a new `CATALOG_SYNC` job immediately and adds it to the job log.

***

## Viewing Alation metadata in Prizm

After a PULL sync, Alation metadata is available on each Prizm asset detail page under the **Semantics** section. Each pulled item shows:

* The field name (domain or tag)
* The value imported from Alation
* The source type, labeled **"Alation"**

This gives data engineers working in Prizm direct visibility into the catalog classification and tagging of each asset without needing to open Alation.