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

# Getting started with data observability

> This guide will show how to set up an alert metric, define its threshold and receive an alert if it falls outside of this threshold.

## Create a Connection

Data observability supports the following data warehouses and databases for monitoring.

### Data Warehouses

* Redshift
* Snowflake
* BigQuery

### Databases

* Postgres
* MySQL
* SQL Server (coming soon)

*You can create these connections in the Source or Destination page. See Data Stores for more setup details.*

<Frame>
  <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-2.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=6ce1fed48dfdbd1188ab61d321043aed" alt="Supported data warehouse and database connections in Data Observability" width="1200" height="439" data-path="images/cdc/data-observability/image-2.png" />
</Frame>

## Create an Alert

<Steps>
  <Step>
    On your dashboard sidebar, go to Observability. Click **+ New Alert** or **Add on Alert +**

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-3.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=509feae65f66df3bd50c67638f202876" alt="Observability sidebar with New Alert button" width="1200" height="644" data-path="images/cdc/data-observability/image-3.png" />
    </Frame>
  </Step>

  <Step>
    On Create new alert page, you can specify the following details

    * Alert name : Name of the alert
    * Alert priority : Preference on how alert will be categorized
    * Run frequency : How often the metric is run and check to be within the threshold
    * Alert Notification : List of emails to be notified

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-4.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=515be2ba8d6d6c17a3b89abaa94970a8" alt="Create new alert form with name, priority, frequency, and notification fields" width="1200" height="1264" data-path="images/cdc/data-observability/image-4.png" />
    </Frame>
  </Step>

  <Step>
    Add an **Alert trigger**. You may select an existing metric or create a new metric. Here we are going to create a new metric.

    Specify which **Data store** you wish to connect. Then select a **Table** and **Column** to be used in the metric. Here, we selected **Null** as **Metric type** to detect nulls. See Available Metric Types page to see list of metrics.

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-5.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=bd9f4bcea97919862d9035a12048a476" alt="Alert trigger setup selecting data store, table, column, and Null metric type" width="1200" height="1112" data-path="images/cdc/data-observability/image-5.png" />
    </Frame>
  </Step>

  <Step>
    You can add **conditions** specific to columns available in the table. For this example, only rows with column id of 1 will be checked for nulls.

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-6.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=800ac0a8a8ddd8e4e5dad8e9070894c5" alt="Adding a column condition to filter which rows are checked" width="1200" height="295" data-path="images/cdc/data-observability/image-6.png" />
    </Frame>
  </Step>

  <Step>
    **Threshold** is the level a metric needs to cross to generate an alert. Specify either of the two thresholds values (Alert if below, Alert if above) or both.

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/data-observability/image-7.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=9bd8e85b96f641089b404ba95b44057b" alt="Threshold configuration with Alert if below and Alert if above fields" width="1200" height="556" data-path="images/cdc/data-observability/image-7.png" />
    </Frame>
  </Step>
</Steps>

## Related

<CardGroup cols={2}>
  <Card title="What is Data Observability" icon="arrow-right" href="/cdc/what-is-data-observability" horizontal />

  <Card title="Metrics" icon="arrow-right" href="/cdc/data-observability-metrics" horizontal />

  <Card title="Alerts" icon="arrow-right" href="/cdc/data-observability-alerts" horizontal />

  <Card title="Nomenclature" icon="arrow-right" href="/cdc/nomenclature" horizontal />
</CardGroup>
