Castodia automatically imports fresh data from your Redshift Data Warehouse to your Google Sheets on a highly customizable schedule. Auto-refresh data as often as every 1 minute for near real-time data.
Castodia lets you pull data from your Redshift data warehouse directly into Google Sheets.
To connect your Redshift data warehouse, follow the steps below:
Step 1: Open the Castodia Admin Dashboard
Step 2: From the Databases Menu, click on Create
Step 3: Add a nickname for your database connection
Step 4: From the dropdown menu, select Redshift
Step 5: Gather and enter your data warehouse connection information. Note that you must whitelist our IP (220.127.116.11) if your database isn't open. Contact your IT team for help with this.
Step 6: Click the "Test" button to verify your credentials
Step 7: Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.
And that's it! Enjoy running your queries.