List

List

curl --request GET \
  --url https://developer.synq.io/api/changes/v1 \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://developer.synq.io/api/changes/v1', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://developer.synq.io/api/changes/v1",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://developer.synq.io/api/changes/v1"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://developer.synq.io/api/changes/v1")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "changes": [
    {
      "entityId": {
        "airflowDag": {
          "integrationId": "<string>",
          "dagId": "<string>"
        },
        "entityId": "<string>"
      },
      "changeId": "<string>",
      "changeDetectedAt": "2023-01-15T01:30:15.01Z",
      "gitCommit": {
        "hash": "<string>",
        "author": {
          "name": "<string>",
          "email": "<string>",
          "createdAt": "2023-01-15T01:30:15.01Z"
        },
        "committer": {
          "name": "<string>",
          "email": "<string>",
          "createdAt": "2023-01-15T01:30:15.01Z"
        },
        "message": "<string>",
        "shortMessage": "<string>",
        "fileChangeStats": {},
        "changedFilePaths": [
          "<string>"
        ],
        "relatedChangedFilePaths": [
          "<string>"
        ],
        "branchName": "<string>",
        "cloneUrl": "<string>",
        "webCommitUrl": "<string>",
        "directoryChanges": [
          {
            "directoryPath": "<string>",
            "filesChanged": 123,
            "totalLinesAdded": 123,
            "totalLinesRemoved": 123,
            "subdirs": "<array>",
            "topFiles": [
              {
                "filePath": "<string>",
                "linesAdded": 123,
                "linesRemoved": 123
              }
            ]
          }
        ],
        "changesByFileType": {},
        "statistics": {
          "totalFiles": 123,
          "totalLinesAdded": 123,
          "totalLinesRemoved": 123,
          "distribution": {
            "filesWithSmallChanges": 123,
            "filesWithMediumChanges": 123,
            "filesWithLargeChanges": 123,
            "filesAdded": 123,
            "filesModified": 123,
            "filesDeleted": 123
          },
          "topChanges": [
            {
              "filePath": "<string>",
              "linesAdded": 123,
              "linesRemoved": 123,
              "totalLinesChanged": 123
            }
          ]
        }
      },
      "entitySynqPath": "<string>",
      "affectedEntities": [
        {
          "airflowDag": {
            "integrationId": "<string>",
            "dagId": "<string>"
          },
          "entityId": "<string>"
        }
      ],
      "affectedEntitiesSynqPaths": [
        "<string>"
      ]
    }
  ],
  "pageInfo": {
    "totalCount": 123,
    "count": 123,
    "lastId": "<string>"
  }
}

GET

api

changes

List

curl --request GET \
  --url https://developer.synq.io/api/changes/v1 \
  --header 'Authorization: Bearer <token>'

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://developer.synq.io/api/changes/v1', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://developer.synq.io/api/changes/v1",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://developer.synq.io/api/changes/v1"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://developer.synq.io/api/changes/v1")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "changes": [
    {
      "entityId": {
        "airflowDag": {
          "integrationId": "<string>",
          "dagId": "<string>"
        },
        "entityId": "<string>"
      },
      "changeId": "<string>",
      "changeDetectedAt": "2023-01-15T01:30:15.01Z",
      "gitCommit": {
        "hash": "<string>",
        "author": {
          "name": "<string>",
          "email": "<string>",
          "createdAt": "2023-01-15T01:30:15.01Z"
        },
        "committer": {
          "name": "<string>",
          "email": "<string>",
          "createdAt": "2023-01-15T01:30:15.01Z"
        },
        "message": "<string>",
        "shortMessage": "<string>",
        "fileChangeStats": {},
        "changedFilePaths": [
          "<string>"
        ],
        "relatedChangedFilePaths": [
          "<string>"
        ],
        "branchName": "<string>",
        "cloneUrl": "<string>",
        "webCommitUrl": "<string>",
        "directoryChanges": [
          {
            "directoryPath": "<string>",
            "filesChanged": 123,
            "totalLinesAdded": 123,
            "totalLinesRemoved": 123,
            "subdirs": "<array>",
            "topFiles": [
              {
                "filePath": "<string>",
                "linesAdded": 123,
                "linesRemoved": 123
              }
            ]
          }
        ],
        "changesByFileType": {},
        "statistics": {
          "totalFiles": 123,
          "totalLinesAdded": 123,
          "totalLinesRemoved": 123,
          "distribution": {
            "filesWithSmallChanges": 123,
            "filesWithMediumChanges": 123,
            "filesWithLargeChanges": 123,
            "filesAdded": 123,
            "filesModified": 123,
            "filesDeleted": 123
          },
          "topChanges": [
            {
              "filePath": "<string>",
              "linesAdded": 123,
              "linesRemoved": 123,
              "totalLinesChanged": 123
            }
          ]
        }
      },
      "entitySynqPath": "<string>",
      "affectedEntities": [
        {
          "airflowDag": {
            "integrationId": "<string>",
            "dagId": "<string>"
          },
          "entityId": "<string>"
        }
      ],
      "affectedEntitiesSynqPaths": [
        "<string>"
      ]
    }
  ],
  "pageInfo": {
    "totalCount": 123,
    "count": 123,
    "lastId": "<string>"
  }
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

id.entityId

string

Opaque id of the entity, set on every identifier the API returns. Round-trip it verbatim; the format is not part of this contract and may change, and it is never constructed by hand.

OUTPUT ONLY. On a request this field is ignored — the structured variant is what resolves. That is what lets you hand an identifier straight back unchanged, or edit its structured fields, without the two disagreeing about which entity you meant. To name an entity BY opaque id on a request, set the synq_path variant to that id: it carries exactly this string, and it is also how an entity whose platform has no structured variant is named.

Maximum string length: 1024

id.dbtCoreNode.integrationId

string

required

Opaque identifier of the dbt Core project. Usually the Coalesce Quality integration id (a UUID), but may also be the dbt project name from manifest.json when the integration is configured to identify assets by project name. Treat it as an opaque string, not a UUID.

id.dbtCoreNode.nodeId

string

required

Dbt node_id that identifies one of dbt DAG nodes (model, test, etc)

id.dbtCloudNode.projectId

string

required

Your dbt Cloud project id

id.dbtCloudNode.accountId

string

Your dbt Cloud account id

id.dbtCloudNode.nodeId

string

required

Dbt node_id that identifies one of dbt DAG nodes (model, test, etc)

id.bigqueryTable.project

string

required

BigQuery project

id.bigqueryTable.dataset

string

required

BigQuery dataset id

id.bigqueryTable.table

string

required

BigQuery table name

id.snowflakeTable.account

string

required

Snowflake account

id.snowflakeTable.database

string

required

Snowflake database

id.snowflakeTable.schema

string

required

Snowflake schema

id.snowflakeTable.table

string

required

Snowflake table

id.redshiftTable.cluster

string

Required. Host of the Redshift endpoint, as in the connection, for example my-cluster.abc123.eu-west-1.redshift.amazonaws.com. A port suffix is accepted and ignored. The bare cluster name (my-cluster) is not enough, because one name can exist in more than one account or region. A response returns the host in its normalized form, which is also accepted on input.

The rule below also refuses an empty value. It is not required, because required stops the other rules and its error does not say what to send. Required. Host of the Redshift endpoint, as in the connection, for example my-cluster.abc123.eu-west-1.redshift.amazonaws.com. A port suffix is accepted and ignored. The bare cluster name (my-cluster) is not enough, because one name can exist in more than one account or region. A response returns the host in its normalized form, which is also accepted on input.

The rule below also refuses an empty value. It is not required, because required stops the other rules and its error does not say what to send. redshift_table.cluster.full_host // cluster must be the full host of the Redshift endpoint from the connection, for example my-cluster.abc123.eu-west-1.redshift.amazonaws.com

id.redshiftTable.database

string

required

Redshift database

id.redshiftTable.schema

string

required

Redshift schema

id.redshiftTable.table

string

required

Redshift table

id.postgresTable.host

string

required

Postgres hostname without port

id.postgresTable.database

string

required

Postgres database

id.postgresTable.schema

string

required

Postgres schema

id.postgresTable.table

string

required

Postgres table

id.mysqlTable.host

string

required

Mysql hostname without port

id.mysqlTable.schema

string

required

Mysql database

id.mysqlTable.table

string

required

Mysql table

id.clickhouseTable.host

string

required

Clickhouse hostname without port

id.clickhouseTable.schema

string

required

Clickhouse database

id.clickhouseTable.table

string

required

Clickhouse table

id.airflowDag.integrationId

string

required

Coalesce Quality integration_id that identifies the Airflow instance

id.airflowDag.dagId

string

required

Airflow dag_id that identifies the DAG

id.airflowTask.integrationId

string

required

Coalesce Quality integration_id that identifies the Airflow instance

id.airflowTask.dagId

string

required

Airflow dag_id that identifies the DAG

id.airflowTask.taskId

string

required

Airflow task_id that identifies the task within the DAG

id.custom.id

string

required

Id that identifies the custom entity The Id should be unique within the custom entity Identifier.

id.dataproduct.id

string<uuid>

required

Dataproduct id that identifies the Dataproduct

id.synqPath.path

string

required

Coalesce Quality path that identifies the Coalesce Quality entity, needs to be one of supported paths

id.databricksTable.workspace

string

required

URL of Databricks workspace

id.databricksTable.catalog

string

required

Databricks catalog

id.databricksTable.schema

string

required

Databricks schema

id.databricksTable.table

string

required

Databricks table or view

id.trinoTable.host

string

required

Hostname of the Trino instance

id.trinoTable.catalog

string

required

Trino catalog

id.trinoTable.schema

string

required

Trino schema

id.trinoTable.table

string

required

Trino table or view

id.sqlMeshModel.integrationId

string<uuid>

required

Coalesce Quality integration_id that identifies the dbt Core project

id.sqlMeshModel.fqn

string

required

SQLMesh model fully qualified name

id.sqlMeshAudit.integrationId

string<uuid>

required

Coalesce Quality integration_id that identifies the dbt Core project

id.sqlMeshAudit.fqn

string

required

SQLMesh model fully qualified name

id.sqlMeshAudit.auditId

string

required

Identifier of the audit

id.monitor.monitoredId.mssqlTable.host

string

required

Hostname of the SQL Server instance

id.monitor.monitoredId.mssqlTable.database

string

required

SQL Server database

id.monitor.monitoredId.mssqlTable.schema

string

required

SQL Server schema (e.g. "dbo")

id.monitor.monitoredId.mssqlTable.table

string

required

SQL Server table or view

id.monitor.monitoredId.oracleTable.host

string

required

Hostname of the Oracle instance

id.monitor.monitoredId.oracleTable.serviceName

string

required

Oracle service name (PDB)

id.monitor.monitoredId.oracleTable.schema

string

required

Oracle schema (= owning user)

id.monitor.monitoredId.oracleTable.table

string

required

Oracle table or view

id.monitor.monitoredId.athenaTable.instance

string

required

AWS account and region the Athena workgroup runs in, formatted as "." (e.g. "123456789012.eu-west-1"). Auto-derived from sts:GetCallerIdentity at integration setup time.

id.monitor.monitoredId.athenaTable.catalog

string

required

Glue Data Catalog name. Almost always "AwsDataCatalog" — the default catalog for Athena unless the customer registered a federated catalog.

id.monitor.monitoredId.athenaTable.database

string

required

Glue database (the namespace users typically filter on).

id.monitor.monitoredId.athenaTable.table

string

required

Glue table or view name.

id.monitor.monitoredId.savedView.id

string<uuid>

required

Saved view id (client-supplied UUID) that identifies the saved view

id.monitor.monitoredId.fabricTable.instance

string

required

Workspace SQL analytics endpoint host, e.g. ".datawarehouse.fabric.microsoft.com".

id.monitor.monitoredId.fabricTable.database

string

required

Fabric warehouse / lakehouse (database).

id.monitor.monitoredId.fabricTable.schema

string

required

Schema within the database.

id.monitor.monitoredId.fabricTable.table

string

required

Table or view name.

id.monitor.monitoredId.fabricTable.workspaceId

string

Fabric workspace GUID, decoded from the endpoint host in instance. Optional and informational: the table is addressed by instance/database/schema/table, so leave it empty if you don't have it — it does not affect how the identifier resolves.

id.monitor.monitoredId.fabricTable.tenantId

string

Entra (Azure AD) tenant GUID, decoded from the endpoint host in instance. Optional and informational, like workspace_id.

id.monitor.monitoredId.db2Table.host

string

required

Host name of the Db2 server

id.monitor.monitoredId.db2Table.database

string

required

Database name or alias, as in CONNECT TO <database>

id.monitor.monitoredId.db2Table.schema

string

required

Db2 schema (e.g. "DB2INST1")

id.monitor.monitoredId.db2Table.table

string

required

Db2 table or view

id.monitor.monitorId

string

required

Identifier of the monitor

id.monitor.segment

string

Optional monitor segmentation identifier

id.monitor.integrationId

string

deprecated

Coalesce Quality integration_id of the monitored identifier

changeBefore.seconds

Represents seconds of UTC time since Unix epoch 1970-01-01T00:00:00Z. Must be between -315576000000 and 315576000000 inclusive (which corresponds to 0001-01-01T00:00:00Z to 9999-12-31T23:59:59Z).

changeBefore.nanos

integer<int32>

Non-negative fractions of a second at nanosecond resolution. This field is the nanosecond portion of the duration, not an alternative to seconds. Negative second values with fractions must still have non-negative nanos values that count forward in time. Must be between 0 and 999,999,999 inclusive.

limitToChangeTypes

enum<string>[]

Return only changes of specific types.

Available options:

ENTITY_CHANGE_TYPE_UNSPECIFIED,

ENTITY_CHANGE_TYPE_GIT_COMMIT,

ENTITY_CHANGE_TYPE_SQL_DEFINITION_CHANGE,

ENTITY_CHANGE_TYPE_SCHEMA_CHANGE

pagination.cursor

string

Opaque cursor token for the next page of results. If not provided, returns the first page. This is an encoded token that should be passed as-is from the previous PageInfo.last_id.

pagination.pageSize

integer<int32>

Maximum number of items to return in a single page. If not provided, defaults vary per API.

Required range: x >= 0

Response

200 - application/json

Success

ListResponse contains the list of changes made to the requested entity.

changes

EntityChange · object[]

List of recent changes to the state of entity. Changes are returned from newest to oldest. Each change includes:

The type of change (git commit, schema change, SQL definition change)
When the change occurred
Details specific to the type of change
Metadata about who made the change

EntityChange represents a change detected in an entity within the system. It tracks modifications to entities like Git commits, SQL definitions, and database schemas.

EntityChange
EntityChange
EntityChange

Show child attributes

pageInfo

PageInfo · object | null

Pagination information for navigating through results.

Show child attributes

Get Started

Alerts

Monitors

Monitors Types

Reconciliations

Data Products

Scout AI

Ownership

Incidents

Analytics

Query activity

Lineage

BI Integrations

Data Warehouse Integrations

Transactional databases

Code Integrations

dbt Integrations

SQLMesh Integrations

Coalesce Integrations

Orchestration Tool Integrations

Alerting Integrations

Catalogs

Google Cloud Integrations

Admin

Security

Support

Developer API

Authorizations

Query Parameters

Response