– Massive data from Redshift can be helpfully utilised to leverage business growth
– Import the data from Redshift to Google Sheets for minute analysis to gain better insights
– Use Amigo Data to effortlessly import the data by following these steps:
1. Connect Redshift to Amigo Data
2. Select the data set to import and choose the metrics
3. Filter, sort, and import
Import all the data you need in a couple of minutes.
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 pull the data from Redshift 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 Amazon 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.
Connecting Amazon Redshift to Amigo Data
Step 1. Go to Extensions→Amigo Data→Connect.
Step 2. Select Amazon Redshift→Import from Tables.
Step 3. Enter your credentials and click Connect.
Selecting 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).
Adding filter and sort
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 Filter→Add filter. 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.
Once all that is done, click the IMPORT button.
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 to report(s) 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). 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.
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: