Amazon Redshift - Execute Query | Alli Documentation

Amazon Redshift Template - Execute Query

template

amazon redshift

Information about Alli Workflows' low-code Amazon Redshift Execute Query template. Execute any SQL query against your Redshift database.

Amazon Redshift - Execute Query

Overview

Execute any SQL query against your Redshift database. Perfect for creating multi-step SQL jobs, executing DML statements, or running scheduled queries.

Variables

Name	Reference	Type	Required	Default	Options	Description
Host	REDSHIFT_HOST	Alphanumeric	✅	None	-	The domain or the IP address of the database you want to connect to.
Port	REDSHIFT_PORT	Integer	✅	"5439"	-	Port number where the database accepts inbound connections.
Username	REDSHIFT_USERNAME	Alphanumeric	✅	None	-	Username configured as part of the database credentials. See Authorization documentation for more information.
Password	REDSHIFT_PASSWORD	Password	➖	None	-	Password for the provided username
Database	REDSHIFT_DATABASE	Alphanumeric	✅	None	-	Name of the database that you want to connect to
Extra URL Parameters	REDSHIFT_URL_PARAMETERS	Alphanumeric	➖	None	-	Extra parameters that will be placed at the end of the connection string, after the "?". Must be separated by "&"
Query	REDSHIFT_QUERY	Alphanumeric	✅	None	-	Any SQL query that runs a job against the database (CREATE, DROP, INSERT, etc.). Formatting is ignored

YAML

Below is the YAML template

YAML


source:
  blueprint: Amazon Redshift - Execute Query
  inputs:
    REDSHIFT_HOST: null  ## REQUIRED
    REDSHIFT_PORT: '5439' ## REQUIRED
    REDSHIFT_USERNAME: null ## REQUIRED
    REDSHIFT_PASSWORD: null
    REDSHIFT_DATABASE: null  ## REQUIRED
    REDSHIFT_URL_PARAMETERS: null
    REDSHIFT_QUERY: null ## REQUIRED
  type: BLUEPRINT
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - '200'
    - '221'
    - '249'