Amazon Redshift Data API
Run SQL on Redshift without a driver (SigV4).
OCNORA ships 4 typed Amazon Redshift Data API operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.
Before you connect Amazon Redshift Data API
- Authentication
- API key
- Credential
- {"access_key_id", "secret_access_key"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Amazon Redshift Data API
Operations, grouped by what they do to your data.
Create and send 1
Other operations 3
A sample Amazon Redshift Data API workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Amazon Redshift Data API trigger is needed.
- 2Write Actionredshift_data.callRun one of 3 write actions on Redshift Data.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 4
- Write ActionRun one of 3 write actions on Redshift Data.redshift_data.call
- Statement StatusCheck whether a statement has finished.redshift_data.describe_statement
- Execute SQLRun SQL on Redshift without a driver.redshift_data.execute_statement
- Statement ResultRead a finished statement's rows.redshift_data.get_statement_result
Amazon Redshift Data API questions
- How does OCNORA authenticate with Amazon Redshift Data API?
- With a stored API key credential, shaped {"access_key_id", "secret_access_key"}. A connection test can check it when you add it.
- What can I automate with Amazon Redshift Data API?
- 4 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Amazon Redshift Data API operation I need is not listed?
- Where Amazon Redshift Data API has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Amazon Redshift Data API?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Amazon Redshift Data API calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
See your first Amazon Redshift Data API workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.