Skip to content
dbx tools

Variable: GenieQueryAttachmentSchema

const GenieQueryAttachmentSchema: ZodObject<{ description: ZodOptional<ZodString>; id: ZodOptional<ZodString>; last_updated_timestamp: ZodOptional<ZodNumber>; parameters: ZodOptional<ZodArray<ZodObject<{ keyword: ZodOptional<ZodString>; sql_type: ZodOptional<ZodString>; value: ZodOptional<ZodString>; }, $strip>>>; query: ZodOptional<ZodString>; query_result_metadata: ZodOptional<ZodObject<{ is_truncated: ZodOptional<ZodBoolean>; row_count: ZodOptional<ZodNumber>; }, $strip>>; statement_id: ZodOptional<ZodString>; thoughts: ZodOptional<ZodArray<ZodObject<{ content: ZodString; thought_type: ZodString; }, $strip>>>; title: ZodOptional<ZodString>; }, $strip>

GenieQueryAttachment widened with the thoughts[] field the Genie wire exposes but the SDK doesn’t currently type. Every other field (description, query, statement_id, query_result_metadata, title, parameters, last_updated_timestamp, id) flows through verbatim from the SDK schema.

GenieQueryAttachment fields

Section titled “GenieQueryAttachment fields”
  • description (optional): Description of the query
  • last_updated_timestamp (optional): Time when the user updated the query last
  • query (optional): AI generated SQL query
  • query_result_metadata (optional): Metadata associated with the query result.
  • query_result_metadata.is_truncated (optional): Indicates whether the result set is truncated.
  • query_result_metadata.row_count (optional): The number of rows in the result set.
  • statement_id (optional): Statement Execution API statement id. Use Get status, manifest, and result first chunk to get the full result data.
  • title (optional): Name of the query