GET
/
api
/
coordinates
/
v1
/
database
curl --request GET \
  --url https://developer.synq.io/api/coordinates/v1/database \
  --header 'Authorization: Bearer <token>'
{
  "coordinates": [
    {
      "identifiers": [
        {
          "dbtCoreNode": {
            "integrationId": "<string>",
            "nodeId": "<string>"
          },
          "dbtCloudNode": {
            "projectId": "<string>",
            "accountId": "<string>",
            "nodeId": "<string>"
          },
          "bigqueryTable": {
            "project": "<string>",
            "dataset": "<string>",
            "table": "<string>"
          },
          "snowflakeTable": {
            "account": "<string>",
            "database": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "redshiftTable": {
            "cluster": "<string>",
            "database": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "postgresTable": {
            "host": "<string>",
            "database": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "mysqlTable": {
            "host": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "clickhouseTable": {
            "host": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "airflowDag": {
            "integrationId": "<string>",
            "dagId": "<string>"
          },
          "airflowTask": {
            "integrationId": "<string>",
            "dagId": "<string>",
            "taskId": "<string>"
          },
          "custom": {
            "id": "<string>"
          },
          "dataproduct": {
            "id": "<string>"
          },
          "synqPath": {
            "path": "<string>"
          },
          "databricksTable": {
            "workspace": "<string>",
            "catalog": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "trinoTable": {
            "host": "<string>",
            "catalog": "<string>",
            "schema": "<string>",
            "table": "<string>"
          },
          "sqlMeshModel": {
            "integrationId": "<string>",
            "fqn": "<string>"
          },
          "sqlMeshAudit": {
            "integrationId": "<string>",
            "fqn": "<string>",
            "auditId": "<string>"
          },
          "monitor": {
            "monitoredId": {},
            "monitorId": "<string>",
            "segment": "<string>",
            "integrationId": "<string>"
          }
        }
      ],
      "synqPaths": [
        "<string>"
      ],
      "dialectName": "<string>",
      "dialect": 123,
      "dataPlatform": {
        "unknown": {},
        "bigquery": {
          "project": "<string>"
        },
        "clickhouse": {
          "host": "<string>",
          "schema": "<string>"
        },
        "snowflake": {
          "account": "<string>",
          "database": "<string>"
        },
        "redshift": {
          "cluster": "<string>",
          "database": "<string>"
        },
        "postgres": {
          "host": "<string>",
          "database": "<string>"
        },
        "mysql": {
          "host": "<string>"
        },
        "databricks": {
          "workspace": "<string>"
        },
        "dbtCloud": {
          "apiEndpoint": "<string>",
          "accountId": "<string>",
          "projectId": "<string>"
        },
        "sqlMesh": {
          "defaultDatabaseInstance": "<string>"
        },
        "duckdb": {
          "motherduckAccount": "<string>"
        },
        "trino": {
          "coordinator": "<string>"
        },
        "synqIntegrationId": "<string>"
      },
      "dataPlatformType": 123,
      "connectionId": "<string>",
      "instanceName": "<string>",
      "databaseName": "<string>",
      "schemaName": "<string>",
      "objectName": "<string>",
      "sqlFqn": "<string>"
    }
  ]
}

Authorizations

Authorization
string
header
required

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

Response

200
application/json

OK

BatchGetEntitiesResponse is the response message for the BatchGetEntities method.