Redshift
Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.
ingestr supports Redshift as both a source and destination.
URI Format
The URI format for Redshift is as follows:
plaintext
redshift://user:password@host:port/dbname?sslmode=require
URI parameters:
username
: the user name to connect to the databasepassword
: the password for the userhost
: the host address of the database serverport
: the port number the database server is listening on (default is 5439)database
: the name of the database to connect tosslmode
: the SSL mode to use when connecting to the database (optional)
The same URI structure can be used both for sources and destinations. You can read more about SQLAlchemy's Redshift dialect here.