Amazon Redshift · Schema

StatementData

AnalyticsBig DataCloudData LakeData WarehouseETLMachine LearningServerlessSQL

Properties

Name Type Description
Id string The identifier of the SQL statement
StatementName string The name of the SQL statement
Status string The status of the SQL statement
CreatedAt string The date and time the statement was created
UpdatedAt string The date and time the statement was last updated
QueryString string The SQL statement text
QueryParameters array The query parameters
Database string The name of the database
ClusterIdentifier string The cluster identifier
WorkgroupName string The serverless workgroup name
SecretArn string The secret ARN
IsBatchStatement boolean Whether this is a batch statement
View JSON Schema on GitHub

JSON Schema

amazon-redshift-data-statement-data-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "StatementData",
  "type": "object",
  "properties": {
    "Id": {
      "type": "string",
      "description": "The identifier of the SQL statement"
    },
    "StatementName": {
      "type": "string",
      "description": "The name of the SQL statement"
    },
    "Status": {
      "type": "string",
      "description": "The status of the SQL statement"
    },
    "CreatedAt": {
      "type": "string",
      "description": "The date and time the statement was created"
    },
    "UpdatedAt": {
      "type": "string",
      "description": "The date and time the statement was last updated"
    },
    "QueryString": {
      "type": "string",
      "description": "The SQL statement text"
    },
    "QueryParameters": {
      "type": "array",
      "description": "The query parameters"
    },
    "Database": {
      "type": "string",
      "description": "The name of the database"
    },
    "ClusterIdentifier": {
      "type": "string",
      "description": "The cluster identifier"
    },
    "WorkgroupName": {
      "type": "string",
      "description": "The serverless workgroup name"
    },
    "SecretArn": {
      "type": "string",
      "description": "The secret ARN"
    },
    "IsBatchStatement": {
      "type": "boolean",
      "description": "Whether this is a batch statement"
    }
  }
}