This chapter explains how to link Redshift as an external data source to the Morph platform.

​
How to set it up

To set up a connection to Redshift, open the Connections tab on the home screen, open the Connection Settings modal via the Create New Connection button and select Redshift.

​
## Connection configuration (Account)

This section describes the entries in the Account section. Enter the following connection configuration items as required and press the Create button in the bottom left-hand corner of the scroll down side panel.

  1. Host
    • IP address or hostname of the database server (e.g. db.example.com). localhost or 127.0.0.1 is invalid; make sure it is accessible from the static IP address of the Morph platform (35.79.243.33).
  2. Username
    • User name used to connect to the database server.
  3. Password
    • Password used to connect to the database server.
  4. Database
    • Name of the database you want to connect to.
  5. Port
    • Port number of the database server you want to connect to.
  6. SSH Host
    • IP address or hostname when going through a stepping-stone server (relay host). localhost or 127.0.0.1 is invalid; make sure it is accessible from the Morph platform’s fixed IP address (35.79.243.33).
  7. SSH Username
    • User name used to connect to the stepping-stone server.
  8. SSH Password
    • Password to be used when connecting to the stepping-stone server. Not required when using a private key (SSH Private Key) with the public key authentication method.
  9. SSH Port
    • Port number of the stepping-stone server.
  10. SSH Private Key
    • Private key used when connecting to a stepping-stone server. Not required if a password is used.
  11. SSH Passphrase
    • Enter if a passphrase has been set for the private key (SSH Private Key). Not required if a password is used.

​
Complete the connection settings.

Once you have completed the Account section and pressed the Create button in the bottom left-hand corner of the screen, you can now enter the Connection slug to complete the connection settings.

  1. Connection slug
    • Uniquely identifies the connection to the external data source and cannot be empty. Use only letters, numbers and underscores as desired.

Connections一覧に接続設定が表示されたら設定完了となります。

BigQueryMySQL