Amazon Redshift connection

To access your data in Amazon Redshift, create a connection asset for it.

Amazon Redshift is a data warehouse product that forms part of the larger cloud-computing platform Amazon Web Services (AWS).

Create a connection to Amazon Redshift

To create the connection asset, you need these connection details:

  • Hostname or IP address: The hostname or IP address of the database.
  • Port number: The port of the database.
  • Database name: The name of the database.
  • Extended column metadata: Enable this option to request extended column metadata from the driver. This option will provide you with actual values from the database for column metadata like nullability and signedness.
    Note: Enabling this option will negatively impact performance as an additional call is made to the database to gather that column metadata.

Credentials

  • Username and password

Certificates

  • Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.

If the Port is SSL-enabled option is enabled, fill in the following fields:

  • SSL certificate: Enter the SSL certificate of the host to be trusted
  • Hostname in SSL certificate: The hostname in SubjectAlternativeName or Common Name (CN) part of the SSL certificate
  • Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.

Additional propterties

  • Time Type: Choose the required time type for time values in the data source. There are several types you can choose:
    • Varchar: Choose this type to store text or string data. This is ideal for storing time values as strings when the format is non-standard or when time is part of a larger text field.
    • Time: Choose this type to store the time of day (without the date). This is ideal when you only care about the time portion of the data.
    • Timestamp: Choose this type to store both date and time. This is ideal for logging events, tracking changes, or any scenario where both date and time are needed.

Amazon Redshift setup

See Amazon Redshift setup prerequisites for setup information.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Amazon Redshift documentation for the correct syntax.

Learn more