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>"
}
]
}
Get multiple DatabaseCoordinates for identifiers.
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>"
}
]
}
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
OK
BatchGetEntitiesResponse is the response message for the BatchGetEntities method.