IngestQueryLogs
curl --request POST \
--url https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"queryLogs": [
{
"queryId": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"workspace": "<string>",
"integrationId": "<string>",
"connectionId": "<string>",
"startedAt": "2023-11-07T05:31:56Z",
"finishedAt": "2023-11-07T05:31:56Z",
"sql": "<string>",
"sqlHash": "<string>",
"normalizedQueryHash": "<string>",
"sqlDialect": "<string>",
"queryType": "<string>",
"status": "<string>",
"dwhContext": {
"instance": "<string>",
"database": "<string>",
"schema": "<string>",
"warehouse": "<string>",
"user": "<string>",
"role": "<string>",
"cluster": "<string>"
},
"hasCompleteNativeLineage": true,
"isTruncated": true,
"metadata": {},
"nativeLineage": {
"inputTables": [
{
"objectName": "<string>",
"instanceName": "<string>",
"databaseName": "<string>",
"schemaName": "<string>"
}
],
"outputTables": [
{
"objectName": "<string>",
"instanceName": "<string>",
"databaseName": "<string>",
"schemaName": "<string>"
}
]
}
}
]
}
'{}synq.ingest.dwh.v1.DwhService
IngestQueryLogs
POST
/
api
/
datawarehouse
/
v1
/
connection
/
{connection_id}
/
upload
/
{upload_id}
/
query-logs
IngestQueryLogs
curl --request POST \
--url https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"queryLogs": [
{
"queryId": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"workspace": "<string>",
"integrationId": "<string>",
"connectionId": "<string>",
"startedAt": "2023-11-07T05:31:56Z",
"finishedAt": "2023-11-07T05:31:56Z",
"sql": "<string>",
"sqlHash": "<string>",
"normalizedQueryHash": "<string>",
"sqlDialect": "<string>",
"queryType": "<string>",
"status": "<string>",
"dwhContext": {
"instance": "<string>",
"database": "<string>",
"schema": "<string>",
"warehouse": "<string>",
"user": "<string>",
"role": "<string>",
"cluster": "<string>"
},
"hasCompleteNativeLineage": true,
"isTruncated": true,
"metadata": {},
"nativeLineage": {
"inputTables": [
{
"objectName": "<string>",
"instanceName": "<string>",
"databaseName": "<string>",
"schemaName": "<string>"
}
],
"outputTables": [
{
"objectName": "<string>",
"instanceName": "<string>",
"databaseName": "<string>",
"schemaName": "<string>"
}
]
}
}
]
}
'{}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Body
application/json
Show child attributes
Show child attributes
Response
200 - application/json
Success
The response is of type IngestQueryLogsResponse · object.
⌘I