Configuring Amazon Redshift workspace data connections
During workspace creation, under Connection Type, click Redshift.
In the Source Server section, provide the details about the source database:
- 1.In the Server field, provide the server where the database is located.
- 2.In the Database field, provide the name of the database.
- 3.In the Port field, provide the port to use to connect to the database.
- 4.In the Username field, provide the username for the account to use to connect to the database.
- 5.In the Password field, provide the password for the specified username.
- 6.In the S3 Bucket Path field, specify the S3 bucket where Tonic places temporary CSV files that it uses to load and unload Redshift tables.
- 7.To test the connection to the source database, click Test Source Connection.
By default, data generations are not blocked when schema changes do not conflict with your workspace configuration.
To block data generation when there are any schema changes, regardless of whether they conflict with your workspace configuration, toggle Block data generation on schema changes to the on position.
By default, the source database owner relationships, such as schema and table ownership, are preserved in the destination database. The Preserve source database owners in destination database toggle is in the on position.
To instead have the admin user for the destination database gain ownership of the schema and tables, toggle Preserve source database owners in destination database to the off position.
In the Destination Server section, you specify the connection information for the destination database.
To copy the connection details from the source database:
- 1.Click Copy Settings from Source.
- 2.In the Password field, provide the password.
- 3.To test the connection to the destination database, click Test Destination Connection.
If you do not copy the source connection details, then to specify the connection information for the destination database:
- 1.In the Server field, provide the server where the database is located.
- 2.In the Database field, provide the name of the database.
- 3.In the Port field, provide the port to use to connect to the database.
- 4.In the Username field, provide the username for the account to use to connect to the database.
- 5.In the Password field, provide the password for the specified username.
- 6.To test the connection to the destination database, click Test Destination Connection.