Redshift

Connecting to Redshift

For an overview of the connector, please refer to the following link:

Connecting to DB/SaaS

Dashboard
Local Version

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.

Enter Redshift Credentials

Enter the credentials for the database you want to connect to in the displayed form. If connecting via a remote server, check the “SSH” box and fill in the necessary fields.After entering the information, press the Create button to complete the creation. If there are any errors in the parameters, an error message will be displayed, so please check the connection details again.

Field Name	Description	Required	Example
`Host`	Enter the database host name.	✅	`example.com`
`Port`	Enter the database connection port.	✅	`5439`
`Database`	Enter the database name.	✅	`my_database`
`Username`	Enter the database username.	✅	`db_user`
`Password`	Enter the database user password.	✅	`mypassword`
`SSH`	Specify if using SSH connection.
`SSH Host`	Enter the remote server host name.		`ssh.example.com`
`SSH Port`	Enter the remote server connection port.		`22`
`SSH Username`	Enter the remote server username.		`ssh_user`
`SSH Password`	Enter the remote server user password.		`sshpassword`
`SSH Private Key`	Enter the remote server private key.		`-----BEGIN RSA PRIVATE KEY-----`
`SSH Passphrase`	Enter the passphrase for the private key.		`my_passphrase`

Make sure to allow access from 54.150.149.0/32 in the IP whitelist of the target database.

Connect to the Created Database

Once created successfully, you can get the connector name from the list display. The string next to the icon is connection_name. You can use this to connect to the database in your code.

Enter the created connector name in your SQL or Python code to retrieve data.

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

import morph
from morph import MorphGlobalContext
from morph_lib.database import execute_sql


@morph.func
def main(context: MorphGlobalContext):
    df = execute_sql(
        sql="SELECT * from table_name"
        connection="connection_name"
    )
    return df

Run the morph init Command

Run the morph init command to save the DB connection information in ~/.morph/connections.yml.

Shell

morph init

If you have not installed the morph package, please install it with the following command before proceeding.

shell

pip install morph-data

A list of database types will be displayed in the interactive interface, so select Redshift.

Shell

Select your database type:
1. PostgreSQL
2. MySQL
3. Redshift
4. SQLServer
5. Snowflake (User/Password)
6. BigQuery (Service Account)
Enter the number corresponding to your database type: 3

Redshift selected.

Next, enter the database credentials. slug is treated as the connector name, which you specify in SQL or Python.Replace the following input examples with actual values that can connect.

shell

Create a slug for your connection: redshift-connection
Enter your Redshift host (default: localhost): localhost
Enter your Redshift username: your_user_name
Enter your Redshift password: your_password
Enter your Redshift port (default: 5439): 5439
Enter your Redshift database name: your_database_name
Enter your Redshift schema name (default: public): public
Select if you are using SSH tunneling (y/n): n

Once the credentials are saved, the following message will be displayed.

shell

Successfully initialized! 🎉
You can edit your connection details in `path_to_connections.yml`

connections.yml is saved as follows. If you create other connectors, they will be added under connections.

shell

cat ~/.morph/connections.yml

connections:
  redshift-connection: # Connector name
    dbname: your_database_name
    host: localhost
    password: your_password
    port: 5439
    schema_: public
    ssh_host: null
    ssh_password: null
    ssh_port: null
    ssh_private_key: null
    ssh_user: null
    type: redshift # Fixed
    user: your_user_name

Retrieve Data Using the Connector in Code

Enter the created connector name in your SQL or Python code to retrieve data.

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

import morph
from morph import MorphGlobalContext
from morph_lib.database import execute_sql


@morph.func
def main(context: MorphGlobalContext):
    df = execute_sql(
        sql="SELECT * from table_name"
        connection="connection_name"
    )
    return df

When actually specifying the connector and executing the file, the priority is as follows. Also, please note that only connectors created in the dashboard can be used in the environment where morph deploy is performed.

Connectors listed in ~/.morph/connections.yml on the local machine
Connectors registered in the cloud

Getting Started

Quick Start

Framework

Deployment

Tutorials: Data Analysis

Tutorials: LLM Apps

Advanced

Connecting to Redshift

​Connecting to Redshift

Connecting to Redshift