RedShift Service

PreviousRedShift NextAmazonMQ

Last updated 4 years ago

Kubemq aws-redshift target connector allows services using kubemq server to access aws redshift service.

Prerequisites

The following required to run the aws-redshift service target connector:

kubemq cluster
aws account with redshift active service(Not rds, see rds/redshift)
kubemq-source deployment

Configuration

redshift target connector configuration properties:

Example:

bindings:
  - name: kubemq-query-aws-redshift-service
    source:
      kind: kubemq.query
      name: kubemq-query
      properties:
        address: "kubemq-cluster:50000"
        client_id: "kubemq-query-aws-redshift-connector-svc"
        auth_token: ""
        channel: "query.aws.redshift.service"
        group:   ""
        auto_reconnect: "true"
        reconnect_interval_seconds: "1"
        max_reconnects: "0"
    target:
      kind: aws.redshift.service
      name: aws-redshift-service
      properties:
        aws_key: "id"
        aws_secret_key: 'json'
        region:  "region"
        token: ""

Usage

Create Tags

create a tag for a resource ,must be accessible to redshift cluster.

Create Tags:

Example:

{
  "metadata": {
    "method": "create_tags",
    "resource_arn": "arn:aws:redshift:region:account_id:cluster:cluster_name"
  },
  "data": "eyJ0ZXN0MS1rZXkiOiJ0ZXN0MS12YWx1ZSJ9"
}

Delete Tags

delete tag from resource,must be accessible to redshift cluster.

Delete Tags:

Example:

{
  "metadata": {
    "method": "delete_tags",
    "resource_arn": "arn:aws:redshift:region:account_id:cluster:cluster_name"
  },
  "data": "WyJ0ZXN0MS1rZXkiXQ=="
}

list all tags on the redshift cluster

List Tags:

Example:

{
  "metadata": {
    "method": "list_tags"
  },
  "data": null
}

List Snapshots

list all redshift snapshots.

List Snapshots:

Example:

{
  "metadata": {
    "method": "list_snapshots"
  },
  "data": null
}

List Snapshots By Tag Keys

list all redshift snapshots with the matching tag keys.

List Snapshots By Tag Keys:

Example:

{
  "metadata": {
    "method": "list_snapshots_by_tags_keys"
  },
  "data": "WyJ0ZXN0MS1rZXkiXQ=="
}

List Snapshots By Tag Values

list all redshift snapshots with the matching tag Values.

List Snapshots By Tag Values:

Example:

{
  "metadata": {
    "method": "list_snapshots_by_tags_keys"
  },
  "data": "WyJ0ZXN0MS1rZXkiXQ=="
}

Describe Clusters

Describe Clusters:

Example:

{
  "metadata": {
    "method": "list_snapshots_by_tags_keys",
    "resource_name": "my_cluster_name",
  },
  "data": null
}

List Clusters

list clusters under redshift service

List Clusters:

Example:

{
  "metadata": {
    "method": "list_clusters"
  },
  "data": null
}

List Clusters By Tag Keys

list clusters under redshift service by tag keys

List Clusters By Tag Keys:

Example:

{
  "metadata": {
    "method": "list_clusters_by_tags_keys"
  },
  "data": "WyJ0ZXN0MS1rZXkiXQ=="
}

List Clusters By Tag Values

list clusters under redshift service by tag values

List Clusters By Tag Values:

Example:

{
  "metadata": {
    "method": "list_clusters_by_tags_values"
  },
  "data": "WyJ0ZXN0MS1rZXkiXQ=="
}