Redshift Data Sql Records Structure
SqlRecords schema from Amazon Redshift
SqlRecords is a JSON Structure definition published by AWS Redshift. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.
Meta-schema: https://json-structure.org/meta/core/v0/#
JSON Structure
{
"type": "array",
"items": {
"type": "array",
"items": {
"type": "object",
"properties": {
"blobValue": {
"allOf": [
{
"$ref": "#/components/schemas/Blob"
},
{
"description": "A value of the BLOB data type. "
}
]
},
"booleanValue": {
"allOf": [
{
"$ref": "#/components/schemas/BoxedBoolean"
},
{
"description": "A value of the Boolean data type. "
}
]
},
"doubleValue": {
"allOf": [
{
"$ref": "#/components/schemas/BoxedDouble"
},
{
"description": "A value of the double data type. "
}
]
},
"isNull": {
"allOf": [
{
"$ref": "#/components/schemas/BoxedBoolean"
},
{
"description": "A value that indicates whether the data is NULL. "
}
]
},
"longValue": {
"allOf": [
{
"$ref": "#/components/schemas/BoxedLong"
},
{
"description": "A value of the long data type. "
}
]
},
"stringValue": {
"allOf": [
{
"$ref": "#/components/schemas/String"
},
{
"description": "A value of the string data type. "
}
]
}
},
"description": "A data value in a column. "
}
},
"$schema": "https://json-structure.org/meta/core/v0/#",
"$id": "https://raw.githubusercontent.com/api-evangelist/aws-redshift/refs/heads/main/json-structure/redshift-data-sql-records-structure.json",
"name": "SqlRecords",
"description": "SqlRecords schema from Amazon Redshift"
}
Work with this as data
Every JSON Structure here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for json structure
4 MCP tools reach this
find_json_structuresBrowse and filter every JSON Structure in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
curl "https://apis.io/api/v1/json-structures/redshift-data-sql-records-structure"
curl "https://apis.io/api/v1/json-structures?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.