Redshift is a fast and powerful, fully managed cloud data warehouse service offered by Amazon Web Service (AWS). It gives users the choice of a few gigabytes of data and has the capacity to scale to petabytes.
You can export bits of the data from Redshift to Google Sheets for more granular and detailed analyses, develop actionable insights and make better decisions.
Mining this massive data–the new oil, as it is often called–so that it can be put to use requires more than a bit (or byte) of effort, however. It requires the technical expertise of data scientists and data analysts. You could write a few codes and run the script to pull the data to Google Sheets but that is a tedious and soul-breaking task, is prone to error–and so it’s hardly worth the effort.
Why use Amigo Data
There is a solution to this daunting process, fortunately. You can use Amigo Data to effortlessly and efficiently connect Redshift data to Google Sheets. You don’t need to write a single life of code, and neither do you need data analysts.
And once set up and connected, it will automatically update the data periodically and send you alerts to make sure that you don’t miss a thing. Installing Amigo Data in your Google Sheets is, it may be said, tantamount to installing a drilling rig in your backyard.
How to import data from Redshift to Google Sheets
Let me walk you through how you can import data from Redshift to Google Sheets with Amigo Data. Using Amigo Data is very easy and straightforward contrary to what the analogy might suggest.
Before we proceed, install the Amigo Data add-on so that the following steps will be much easier to follow–and more fun.
You can get it from the Google Workspace Marketplace here. Install and give the permissions.
Alternatively, you can get it from within Google Sheets itself.
- Open a Google Sheets document
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install
Once the installation is complete, the Amigo Data add-on should appear in your Extensions tab. And we can move on to the steps to connect Redshift to Google Sheets and export data from Redshift to Google Sheets.
Step 1: Connect Redshift to Amigo Data
We can connect Redshift to Google Sheets in a few steps:
- Go to Extensions→Amigo Data→Connect.
- Select Amazon Redshift→Import from Tables.
- Enter your credentials and click Connect.
Step 2: Select the data set and the metrics to import
On the dashboard that appears, there will be a list of data tables. Select the one that you want to import. Then select the metrics you want to import from Redshift to Google Sheets (or in our case since all the metrics are selected by default, unselect the ones you want to exclude).
Step 3: Filter and sort the data to import and add limit (optional)
You can also filter the data by certain parameters to exclude non-useful values from the table, such as null values.
To add a filter, click the Filter option. Then select the metric and add the condition. You can add as many filters as there are metrics in the selected table.
You can likewise add sort to arrange the data in ascending or descending order of any of the metrics.
If you want to import only a certain number of items, then you can specify the number of rows from the Limit option.
Step 4: Import the data
Once all that is done, click the IMPORT button. In a few moment the data from Redshift will be imported into Google Sheets.
With the data imported, you can make reports with it or create tables and charts to get better analytical information and insights. Below is an example of sales trend for the current year created with the imported data.
And underneath is the visualisation of customers segmented by age group.
Setting automatic refresh schedule
Amigo can refresh the data retrieved from Redshift to Google Sheets periodically–hourly, daily, weekly or on certain days of your choice; for example 10 am, Monday–so that you do not have to export the data each time you want to make a report or perform an analysis. To do so, select or customise the time period and click Yes, set the refresh timing.
You can also set this up later. To edit the report or set the refresh schedule, expand the View Reports tab, set the options and switch the toggle. Then click Save & Run.
Amigo will also send you alerts to your email or Slack channel with snapshots of the report so that you don’t even have to open the spreadsheet to see your data.
To set up an alert, click Get Alerts→Add data alert and customise the alert, add the email(s) to which you want the alert sent and/or Slack channel(s). Here you can add the emails of all your teammates or anyone you may need to share with. Once done, click Set Alert
Amigo will send you a snapshot of the report periodically, and you always have the latest information wherever you are.
Importing data from Amazon Redshift to Google Sheets is a piece of cake with Amigo Data and not the daunting, tedious task it normally is. And with the various importing options available, you can have your data as you like thus making it easier to make a report or analyse the data.
If you didn’t install Amigo Data earlier on, you can get it from here and try it yourself to export data from redshift.
How do I connect Redshift to Google Sheets?
Follow these steps to connect Redshift to Google Sheets:
- Install the Amigo Data add-on.
- Launch Amigo Data in Google Sheets.
- Click Amazon Redshift and select “Import from tables”.
- Enter the Redshift login credentials.
- Click the “Connect” button.
How do I export data from Redshift?
To export data from Redshift to Google Sheets
- Connect Redshift to Google Sheets
- Choose the table to export
- Select the metrics
- Export the data
- Set a refresh schedule to auto-update the data
Can you connect Google Sheets to access database?
You can use Amigo to connect Google Sheets to various databases such as MySQL, PostgreSQL, and Microsoft SQL Server and easily retrieve data from databases and import the data to Google Sheets.
You can also use Amigo Data to export data from various other sources such as Snowflake, PostgreSQL, and Google Analytics among others. For tutorials on them and other Google Sheets guides, you can find them here.
Some similar articles you may be interested in: