Skip to main content
POST
/
api
/
datawarehouse
/
v1
/
connection
/
{connection_id}
/
upload
/
{upload_id}
/
sql-definitions
IngestSqlDefinitions
curl --request POST \
  --url https://developer.synq.io/api/datawarehouse/v1/connection/{connection_id}/upload/{upload_id}/sql-definitions \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "stateAt": "2023-11-07T05:31:56Z",
  "sqlDefinitions": [
    {
      "fqn": {
        "objectName": "<string>",
        "instanceName": "<string>",
        "databaseName": "<string>",
        "schemaName": "<string>"
      },
      "sql": "<string>"
    }
  ]
}
'
{}

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
​
stateAt
string<date-time>
required

Time at which state was collected timestamp.gt = 2022-01-01T00:00:00Z timestamp.gt_lt = 2022-01-01T00:00:00Z timestamp.gt_lt_exclusive = 2022-01-01T00:00:00Z timestamp.gt_lte = 2022-01-01T00:00:00Z timestamp.gt_lte_exclusive = 2022-01-01T00:00:00Z timestamp.lt_now = true

​
sqlDefinitions
SqlDefinition · object[]

Response

200 - application/json

Success

The response is of type IngestSqlDefinitionsResponse · object.