Connect Google Sheets to Redshift

Connect Google Sheets to Amazon Redshift

About Amazon Redshift

Amazon Redshift is a fully managed data warehousing service in the cloud. Designed for large scale data set storage and analysis, Redshift is used by some of the largest companies in the world including Ford Motor Company and Lyft. The data warehouse offers features such as flexibility, scalability, high performance, and efficient data compression.

Integrate Amazon Redshift

The easiest and fastest way to connect your Redshift data warehouse to Google Sheets. With Castodia, you can test the limits by analyzing stored data from relational databases, running and scheduling queries, and auto-refreshing data from a yearly basis down to a 1-minute frequency. LEARN MORE

[Update: December 2020] Users will no longer need to individually share each sheet with the Castodia service account as described in the video. Users will instead be required to authenticate with their Google Account only once and this will automatically enable auto-refresh for any sheet.

How to Connect Redshift Data Warehouse to Google Sheets

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: Install the Castodia GSuite Marketplace Database Connector

Step 2: Create a Google Sheet and click "Add-Ons" within the toolbar section to access the Castodia Database Connector

Step 3: Two options will appear when you hover over the add-on: launch and settings. Click "Settings."

Step 4: Type in a name to help identify your data warehouse

Step 5: Click the drop-down menu to access the Redshift data warehouse

Step 6: Gather and enter your data warehouse connection information. There are five components needed:

  • Database Name
  • Host
  • Port
  • Username
  • Password

Step 7: Click the "Test" button to run the data warehouse and verify your credentials

Step 8: 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.

Use Case

Scenario

Suppose an operations analyst is looking to compile customer data in an efficient and organized way. The company currently has a comprehensive master file but is unable to sort information within the sheet. Any updated data has to be emailed to colleagues on a weekly basis, making it easy to lose track of the most updated version.

In compiling the data, the operations analyst is looking to answer three questions:

  1. What is the breakdown of customer segments?
  2. What is the current account balance of Customer #000000001 and #000000002?
  3. What is the monthly breakdown of customer sign-ups within the past year?

Solution

Rather than manually exporting CSV files to derive insightful analytics, the operations analyst can use Castodia's Database Connector to connect their Redshift data warehouse to Google Sheets, run and save important queries, and auto-refresh their data every two weeks based on their custom schedule.

To get started, install the Castodia GSuite Add-On and access a new Google sheet. Once you have connected your Redshift data warehouse, you can begin to run SQL queries.

Castodia also gives users the freedom to create custom schedules for databases. The operations analyst can set data to auto-refresh onto the master file on a weekly basis to avoid manual inputs. To do so, set the data to repeat every Friday on a 2-hour frequency between 8:30 am and 4:30 pm. The Google Sheet can also be shared with the operations analyst's colleagues to prevent the misplacement of the important file when emailed.


Master file - Castodia connect Redshift to Google Sheets

Now let's answer the three questions:

1. What is the breakdown of customer segments?

The operations analyst can pull data directly from the Redshift warehouse using a SQL query. After doing so, a chart can be created to visualize the breakdown of customer segments. Products sold at the company are primarily used for buildings, following with automobile and household as the second-largest segments.


Customer segment breakdown

2. What is the current account balance of Customer #000000001 and #000000002?

To search for a particular customer's account balance, the operations analyst can run a SQL query onto Google Sheets. Now, the current account balances are available for the team to view. To view a particular customer, the operations analyst can specify the query to search for an individual account balance. Customer #000000001 has an account balance of $711.56, and customer #000000002 has an account balance of $121.65.


Current account balance


3. What is the monthly breakdown of customer sign-ups within the past year?

Lastly, the operations analyst can reconfigure the SQL query to depict a growth rate graph for the company's customer sign-ups. There is a general upwards trend, with a notable spike from October to November. The operations analyst can further look into these two months to derive any important insights.


Customer sign-up growth rate



Connectors

All Castodia Database Connector Features

1 minute auto-refresh

1 Minute Auto-Refresh

Set refresh frequency to every day, every few hours, or every few minutes. Down to once every 1 minute

Advanced scheduling

Advanced Scheduling

Auto refresh data daily, weekly, monthly or yearly with fully customizable schedules

Intuitive UI Castodia

Intuitive UI

Run, save and schedule queries all from within Google Sheets using a clean and intuitive interface

Long query run time

Long Query Time

Run long/complex queries that take minutes to run. Fearlessly run large queries without unexpected errors

Append vs overwrite

Append and Overwrite

Choose how to auto-refresh data on your spreadsheet. Smart Overwrite prevents calculations intact

Direct SQL query

Direct SQL Query

Paste any SQL query and run them directly from Google Sheets. If it runs on your editor it will also run here

Start free trial

Try Castodia free for 14 days, no credit card required.