Skip to main content
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>"
          }
        ]
      }
    }
  ]
}
'
import requests

url = "https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs"

payload = { "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>"
}
]
}
}
] }
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)
const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
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>'
}
]
}
}
]
})
};

fetch('https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));
<?php

$curl = curl_init();

curl_setopt_array($curl, [
CURLOPT_URL => "https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'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>'
]
]
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}
package main

import (
"fmt"
"strings"
"net/http"
"io"
)

func main() {

url := "https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs"

payload := strings.NewReader("{\n \"queryLogs\": [\n {\n \"queryId\": \"<string>\",\n \"createdAt\": \"2023-11-07T05:31:56Z\",\n \"workspace\": \"<string>\",\n \"integrationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"startedAt\": \"2023-11-07T05:31:56Z\",\n \"finishedAt\": \"2023-11-07T05:31:56Z\",\n \"sql\": \"<string>\",\n \"sqlHash\": \"<string>\",\n \"normalizedQueryHash\": \"<string>\",\n \"sqlDialect\": \"<string>\",\n \"queryType\": \"<string>\",\n \"status\": \"<string>\",\n \"dwhContext\": {\n \"instance\": \"<string>\",\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"user\": \"<string>\",\n \"role\": \"<string>\",\n \"cluster\": \"<string>\"\n },\n \"hasCompleteNativeLineage\": true,\n \"isTruncated\": true,\n \"metadata\": {},\n \"nativeLineage\": {\n \"inputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ],\n \"outputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ]\n }\n }\n ]\n}")

req, _ := http.NewRequest("POST", url, payload)

req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")

res, _ := http.DefaultClient.Do(req)

defer res.Body.Close()
body, _ := io.ReadAll(res.Body)

fmt.Println(string(body))

}
HttpResponse<String> response = Unirest.post("https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"queryLogs\": [\n {\n \"queryId\": \"<string>\",\n \"createdAt\": \"2023-11-07T05:31:56Z\",\n \"workspace\": \"<string>\",\n \"integrationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"startedAt\": \"2023-11-07T05:31:56Z\",\n \"finishedAt\": \"2023-11-07T05:31:56Z\",\n \"sql\": \"<string>\",\n \"sqlHash\": \"<string>\",\n \"normalizedQueryHash\": \"<string>\",\n \"sqlDialect\": \"<string>\",\n \"queryType\": \"<string>\",\n \"status\": \"<string>\",\n \"dwhContext\": {\n \"instance\": \"<string>\",\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"user\": \"<string>\",\n \"role\": \"<string>\",\n \"cluster\": \"<string>\"\n },\n \"hasCompleteNativeLineage\": true,\n \"isTruncated\": true,\n \"metadata\": {},\n \"nativeLineage\": {\n \"inputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ],\n \"outputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ]\n }\n }\n ]\n}")
.asString();
require 'uri'
require 'net/http'

url = URI("https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/query-logs")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"queryLogs\": [\n {\n \"queryId\": \"<string>\",\n \"createdAt\": \"2023-11-07T05:31:56Z\",\n \"workspace\": \"<string>\",\n \"integrationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"startedAt\": \"2023-11-07T05:31:56Z\",\n \"finishedAt\": \"2023-11-07T05:31:56Z\",\n \"sql\": \"<string>\",\n \"sqlHash\": \"<string>\",\n \"normalizedQueryHash\": \"<string>\",\n \"sqlDialect\": \"<string>\",\n \"queryType\": \"<string>\",\n \"status\": \"<string>\",\n \"dwhContext\": {\n \"instance\": \"<string>\",\n \"database\": \"<string>\",\n \"schema\": \"<string>\",\n \"warehouse\": \"<string>\",\n \"user\": \"<string>\",\n \"role\": \"<string>\",\n \"cluster\": \"<string>\"\n },\n \"hasCompleteNativeLineage\": true,\n \"isTruncated\": true,\n \"metadata\": {},\n \"nativeLineage\": {\n \"inputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ],\n \"outputTables\": [\n {\n \"objectName\": \"<string>\",\n \"instanceName\": \"<string>\",\n \"databaseName\": \"<string>\",\n \"schemaName\": \"<string>\"\n }\n ]\n }\n }\n ]\n}"

response = http.request(request)
puts response.read_body
{}

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[]

Response

200 - application/json

Success

The response is of type IngestQueryLogsResponse · object.