Amazon Redshift

amazonaws · Cloud

Cloud No Auth Free & Open cloud Sandbox

Amazon Redshift Overview This is an interface reference for Amazon Redshift. It contains documentation for one of the programming or command line interfaces you can use to manage Amazon Redshift clusters. Note that Amazon Redshift is asynchronous, which means that some interfaces may require techniques, such as polling or asynchronous callback handlers, to determine when a command has been applied. In this reference, the parameter descriptions indicate whe

Authentication

No authentication requiredFree to use with no key needed.

Sample Requests

GET GET_AcceptReservedNodeExchange

Exchanges a DC1 Reserved Node for a DC2 Reserved Node with no changes to the configuration (term, payment type, or number of nodes) and no additional costs.

https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange?Action=AcceptReservedNodeExchange&Version=2012-12-01&ReservedNodeId=example&TargetReservedNodeOfferingId=example

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange?Action=AcceptReservedNodeExchange&Version=2012-12-01&ReservedNodeId=example&TargetReservedNodeOfferingId=example"

import requests
params = {
    "Action": "AcceptReservedNodeExchange",
    "Version": "2012-12-01",
    "ReservedNodeId": "example",
    "TargetReservedNodeOfferingId": "example"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange');
url.searchParams.set('Action', 'AcceptReservedNodeExchange');
url.searchParams.set('Version', '2012-12-01');
url.searchParams.set('ReservedNodeId', 'example');
url.searchParams.set('TargetReservedNodeOfferingId', 'example');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange")
	q := baseURL.Query()
	q.Set("Action", "AcceptReservedNodeExchange")
	q.Set("Version", "2012-12-01")
	q.Set("ReservedNodeId", "example")
	q.Set("TargetReservedNodeOfferingId", "example")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange")
uri.query = URI.encode_www_form({
  "Action" => "AcceptReservedNodeExchange",
  "Version" => "2012-12-01",
  "ReservedNodeId" => "example",
  "TargetReservedNodeOfferingId" => "example"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AcceptReservedNodeExchange?" . http_build_query([
    "Action" => "AcceptReservedNodeExchange",
    "Version" => "2012-12-01",
    "ReservedNodeId" => "example",
    "TargetReservedNodeOfferingId" => "example"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET GET_AddPartner

Adds a partner integration to a cluster. This operation authorizes a partner to push status updates for the specified database. To complete the integration, you also set up the integration on the partner website.

https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner?Action=AddPartner&Version=2012-12-01&AccountId=example&PartnerName=example&DatabaseName=example&ClusterIdentifier=example

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner?Action=AddPartner&Version=2012-12-01&AccountId=example&PartnerName=example&DatabaseName=example&ClusterIdentifier=example"

import requests
params = {
    "Action": "AddPartner",
    "Version": "2012-12-01",
    "AccountId": "example",
    "PartnerName": "example",
    "DatabaseName": "example",
    "ClusterIdentifier": "example"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner');
url.searchParams.set('Action', 'AddPartner');
url.searchParams.set('Version', '2012-12-01');
url.searchParams.set('AccountId', 'example');
url.searchParams.set('PartnerName', 'example');
url.searchParams.set('DatabaseName', 'example');
url.searchParams.set('ClusterIdentifier', 'example');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner")
	q := baseURL.Query()
	q.Set("Action", "AddPartner")
	q.Set("Version", "2012-12-01")
	q.Set("AccountId", "example")
	q.Set("PartnerName", "example")
	q.Set("DatabaseName", "example")
	q.Set("ClusterIdentifier", "example")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner")
uri.query = URI.encode_www_form({
  "Action" => "AddPartner",
  "Version" => "2012-12-01",
  "AccountId" => "example",
  "PartnerName" => "example",
  "DatabaseName" => "example",
  "ClusterIdentifier" => "example"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AddPartner?" . http_build_query([
    "Action" => "AddPartner",
    "Version" => "2012-12-01",
    "AccountId" => "example",
    "PartnerName" => "example",
    "DatabaseName" => "example",
    "ClusterIdentifier" => "example"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET GET_AssociateDataShareConsumer

From a datashare consumer account, associates a datashare with the account (AssociateEntireAccount) or the specified namespace (ConsumerArn). If you make this association, the consumer can consume the datashare.

https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer?Action=AssociateDataShareConsumer&Version=2012-12-01&ConsumerArn=example&DataShareArn=example&ConsumerRegion=example&AssociateEntireAccount=true

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer?Action=AssociateDataShareConsumer&Version=2012-12-01&ConsumerArn=example&DataShareArn=example&ConsumerRegion=example&AssociateEntireAccount=true"

import requests
params = {
    "Action": "AssociateDataShareConsumer",
    "Version": "2012-12-01",
    "ConsumerArn": "example",
    "DataShareArn": "example",
    "ConsumerRegion": "example",
    "AssociateEntireAccount": "true"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer');
url.searchParams.set('Action', 'AssociateDataShareConsumer');
url.searchParams.set('Version', '2012-12-01');
url.searchParams.set('ConsumerArn', 'example');
url.searchParams.set('DataShareArn', 'example');
url.searchParams.set('ConsumerRegion', 'example');
url.searchParams.set('AssociateEntireAccount', 'true');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer")
	q := baseURL.Query()
	q.Set("Action", "AssociateDataShareConsumer")
	q.Set("Version", "2012-12-01")
	q.Set("ConsumerArn", "example")
	q.Set("DataShareArn", "example")
	q.Set("ConsumerRegion", "example")
	q.Set("AssociateEntireAccount", "true")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer")
uri.query = URI.encode_www_form({
  "Action" => "AssociateDataShareConsumer",
  "Version" => "2012-12-01",
  "ConsumerArn" => "example",
  "DataShareArn" => "example",
  "ConsumerRegion" => "example",
  "AssociateEntireAccount" => "true"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/amazonaws.com/redshift/2012-12-01/#Action=AssociateDataShareConsumer?" . http_build_query([
    "Action" => "AssociateDataShareConsumer",
    "Version" => "2012-12-01",
    "ConsumerArn" => "example",
    "DataShareArn" => "example",
    "ConsumerRegion" => "example",
    "AssociateEntireAccount" => "true"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

Postman Setup Guide

Get Postman ↗

See official documentation for authentication and setup.

What can you build with Amazon Redshift?

Amazon Redshift is a Cloud API. Developers commonly use cloud APIs for:

provisioning and managing cloud infrastructure
automating deployments and container orchestration
monitoring uptime and performance metrics
managing storage buckets and databases
setting up auto-scaling and load balancing

No authentication required. This API is open — no signup or key needed. Ideal for quick prototypes and public-facing features. Amazon Redshift is free to use, making it a low-risk choice to experiment with.

New to APIs? Read our beginner's guide · Learn about API keys · What is REST?

Open documentation ↗