Connect to your Amazon Redshift instance.

AmazonRedshiftReader Properties

  • databaseName (Env First): The name of the database.
  • endpoint (Env First): The endpoint to the database.
  • password (Env First): The password for the database.
  • sqlQuery (Inline Only): The SQL query to run in the database.
  • username (Env First): The username for the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: AmazonRedshiftReader
    properties:
      sqlQuery:  SELECT * FROM test 
    #schemaRef: schemaName # optional from "schemas:"
Example with Inline Credentials
-
    name: myConnectorName
    type: AmazonRedshiftReader
    properties:
      databaseName: myDatabase 
      endpoint: abc.com 
      password: password 
      sqlQuery: SELECT * FROM test 
      username: username 
    #schemaRef: schemaName # optional from "schemas:"

AmazonRedshiftWriter Properties

  • databaseName (Env First): The name of the database.
  • endpoint (Env First): The endpoint to the database.
  • password (Env First): The password for the database.
  • tableName (Inline Only): The tablename associated with the action. Required for both read and write. For reading data, the query is used for selection.
  • username (Env First): The username for the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: AmazonRedshiftWriter
    properties:
      tableName:  myTable 

Example with Inline Credentials
-
    name: myConnectorName
    type: AmazonRedshiftWriter
    properties:
      databaseName:  myDatabase 
      endpoint:  abc.com 
      password:  password 
      tableName:  myTable 
      username:  username