.svg?alt=media&token=22229f15-f796-4c11-a928-049c59e13a36)
AWS Redshift
Last updated
Was this helpful?
Last updated
Was this helpful?
If your database is hosted behind a Firewall, you need to add our IP addresses to the Firewall whitelist.
To connect your Redshift database, follow the below steps:
Go to the Data sources - Connect.
Select Redshift from the list of the available sources.
Specify your credentials and click Test connection:
4. When the test connection is successful, click Connect Datasource.
If you need to be able to override the default data source database with a custom value in an action, you can enable the setting Allow override database name in action:
Once enabled, when configuring the action, you will be able to specify the custom database. In case a database is not specified, the default data source database will be used.
Once you establish the connection between UI Bakery and Redshift database, you can interact with the data.
Add a new action, choose your data source, and select SQL query from the actions list. Specify your query and click Execute action to launch it.
Note that pre-defined actions, such as Load Table, Create Row, etc. are not supported for Redshift datasource.
2. Check the Result section to make sure the data is loaded.
