Get Started
Monitors
Incidents
Analytics
Data Warehouse Integrations
SQLMesh Integrations
Orchestration Tool Integrations
Alerting Integrations
Catalogs
Security
Support
Developer API
- Getting Started
- REST API
- ChangesService
- CodeService
- DatabaseCoordinatesService
- SqlTestsService
- TestSuggestionsService
- DwhService
- EntitiesService
- EntityExecutionsService
- AtlanIntegrationService
- AtlanProviderService
- AtlanWorkflowService
- CommitsService
- ImpactService
- IncidentsService
- IssuesService
- LineageService
- DeploymentRulesService
- HistoryService
- MonitorInfoService
- PlatformsService
- SchemasService
- EntityIncidentsService
- EntityIssuesService
- TriageService
- gRPC API
- Webhooks
SqlTestsService
Post apidatacheckssqltestsv1batch
Upsert SqlTests based on a unique ID.
POST
/
api
/
datachecks
/
sqltests
/
v1
/
batch
Copy
Ask AI
curl --request POST \
--url https://developer.synq.io/api/datachecks/sqltests/v1/batch \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"sqlTests": [
{
"platform": {
"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>"
},
"id": "<string>",
"name": "<string>",
"sqlExpression": "<string>",
"recurrenceRule": "<string>",
"annotations": [
{
"name": "<string>",
"values": [
"<string>"
]
}
],
"saveFailures": true
}
]
}'
Copy
Ask AI
{
"createdIds": [
"<string>"
],
"updatedIds": [
"<string>"
],
"errors": [
{
"id": "<string>",
"reason": "<string>"
}
]
}
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Body
application/json
Response
200
application/json
OK
The response is of type object
.
Copy
Ask AI
curl --request POST \
--url https://developer.synq.io/api/datachecks/sqltests/v1/batch \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"sqlTests": [
{
"platform": {
"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>"
},
"id": "<string>",
"name": "<string>",
"sqlExpression": "<string>",
"recurrenceRule": "<string>",
"annotations": [
{
"name": "<string>",
"values": [
"<string>"
]
}
],
"saveFailures": true
}
]
}'
Copy
Ask AI
{
"createdIds": [
"<string>"
],
"updatedIds": [
"<string>"
],
"errors": [
{
"id": "<string>",
"reason": "<string>"
}
]
}
Assistant
Responses are generated using AI and may contain mistakes.