IngestQueryLogs

POST /api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs

IngestQueryLogs

cURL

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>"
      },
      "sqlObfuscationMode": "SQL_OBFUSCATION_MODE_NONE",
      "hasCompleteNativeLineage": true,
      "isTruncated": true,
      "metadata": {},
      "nativeLineage": {
        "inputTables": [
          {
            "objectName": "<string>",
            "instanceName": "<string>",
            "databaseName": "<string>",
            "schemaName": "<string>"
          }
        ],
        "outputTables": [
          {
            "objectName": "<string>",
            "instanceName": "<string>",
            "databaseName": "<string>",
            "schemaName": "<string>"
          }
        ]
      }
    }
  ]
}
'

200

{}

Authorizations

Authorization · string · header · required

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

Path Parameters

connection_id · string · required

upload_id · string<uuid> · required

Body

application/json

queryLogs · QueryLog · object[]

Show child attributes

Response

200 - application/json

Success

The response is of type IngestQueryLogsResponse · object.