SubStatementData

import type { SubStatementData } from "https://aws-api.deno.dev/v0.3/services/redshiftdata.ts?docs=full";

Information about an SQL statement.

interface SubStatementData {

CreatedAt?: Date | number | null;

Duration?: number | null;

Error?: string | null;

HasResultSet?: boolean | null;

Id: string;

QueryString?: string | null;

RedshiftQueryId?: number | null;

ResultRows?: number | null;

ResultSize?: number | null;

Status?: StatementStatusString | null;

UpdatedAt?: Date | number | null;

}

§Properties

CreatedAt?: Date | number | null

[src]

The date and time (UTC) the statement was created.

Duration?: number | null

[src]

The amount of time in nanoseconds that the statement ran.

Error?: string | null

[src]

The error message from the cluster if the SQL statement encountered an error while running.

HasResultSet?: boolean | null

[src]

A value that indicates whether the statement has a result set. The result set can be empty. The value is true for an empty result set.

Id: string

[src]

The identifier of the SQL statement. This value is a universally unique identifier (UUID) generated by Amazon Redshift Data API. A suffix indicates the number of the SQL statement. For example, d9b6c0c9-0747-4bf4-b142-e8883122f766:2 has a suffix of :2 that indicates the second SQL statement of a batch query.

QueryString?: string | null

[src]

The SQL statement text.

RedshiftQueryId?: number | null

[src]

The SQL statement identifier. This value is a universally unique identifier (UUID) generated by Amazon Redshift Data API.

ResultRows?: number | null

[src]

Either the number of rows returned from the SQL statement or the number of rows affected. If result size is greater than zero, the result rows can be the number of rows affected by SQL statements such as INSERT, UPDATE, DELETE, COPY, and others. A -1 indicates the value is null.

ResultSize?: number | null

[src]

The size in bytes of the returned results. A -1 indicates the value is null.

Status?: StatementStatusString | null

[src]

The status of the SQL statement. An example is the that the SQL statement finished.

UpdatedAt?: Date | number | null

[src]

The date and time (UTC) that the statement metadata was last updated.