Catalog, document, and query live data from Redshift by configuring a virtual connection.
When connecting your data systems to data.world, often your system or firewall may have a network policy that only allows access from specific IP addresses--your allowlist. In those cases, you must add data.world to your network policy IP allowlist.
Allow the following IP addresses:
Go to the Redshift integration page and click Enable integration to set up a connection.
In order to create a virtual connection to Redshift you will use the following parameters:
Host/IP - the url for your database: the url for your database
Port (optional) - use if you connect through a special port: use if you connect through a special port
Database (optional) - You can specify it here or you can choose from a dropdown list when you create a dataset: You can specify it here or you can choose from a dropdown list when you create a dataset
Connection username - Your username for your data source: Your username for your data source
Connection password - Your password for your data source: Your password for your data source
Choose a Display name for your connection. This is the name everyone in your organization will see for the connection. Then enter your user credential information into the dialog screen:
Click Test Redshift configuration to make sure it works, and then save it by selecting Configure.
After your connection is configured you can use it anytime you select Add data:
Choose the connection you want to use from My data sources:
Go to the integration page (easily found under My integrations on our Integrations page) and select Manage:
From here you can edit your current connection or add a new one:
You will need your original credentials (password or key file) to make changes to an existing connection.
Database connectors - A full list of our connection integrations