ONoneuptime
Warehouse Job

Get Warehouse Job

Endpoint to retrieve a single Warehouse Job by ID

post/data-warehouse-job/{id}/get-item

Request

Path parameters

idstring uuid required

ID of the Warehouse Job to retrieve

Request body

Example request

{
  "select": {
    "_id": true,
    "createdAt": true,
    "updatedAt": true,
    "jobKey": true,
    "userName": true,
    "warehouseName": true,
    "team": true
  }
}

Response

Successful response

Example response

{
  "data": {
    "_id": "123e4567-e89b-12d3-a456-426614174000",
    "createdAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "updatedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "deletedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "version": 42,
    "projectId": "123e4567-e89b-12d3-a456-426614174000",
    "dataStoreId": "123e4567-e89b-12d3-a456-426614174000",
    "jobKey": "Example short text",
    "name": "INSERT analytics.orders_daily",
    "userName": "Example short text",
    "warehouseName": "Example short text",
    "team": "Example short text",
    "runCount": 42,
    "failedRunCount": 42,
    "credits": 42,
    "bytesBilled": 1000000,
    "writtenTables": {
      "key": "value",
      "nested": {
        "data": 123
      }
    },
    "writesOnlyUnusedTables": true,
    "lastRunAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "createdByUserId": "123e4567-e89b-12d3-a456-426614174000"
  }
}

Changes

No recorded changes to this operation across all 1 revision of this API.