Connect SQL
Redshift
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.
- 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).
- Username
- User name used to connect to the database server.
- Password
- Password used to connect to the database server.
- Database
- Name of the database you want to connect to.
- Port
- Port number of the database server you want to connect to.
- 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).
- SSH Username
- User name used to connect to the stepping-stone server.
- 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.
- SSH Port
- Port number of the stepping-stone server.
- SSH Private Key
- Private key used when connecting to a stepping-stone server. Not required if a password is used.
- 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.
- Connection slug
- Uniquely identifies the connection to the external data source and cannot be empty. Use only letters, numbers and underscores as desired.
Connections一覧に接続設定が表示されたら設定完了となります。