Redshift to Spreadsheet

Connect your Redshift database to a spreadsheet in Row Zero and import data straight into a blazingly fast spreadsheet.

Connect Row Zero to Redshift

In Row Zero click on the 'connections' icon in the upper right-hand corner and then click the button to '+ Add connection.'Databricks new data source screen in Row ZeroDatabricks add new connection screen in Row Zero

The connection requires 6 pieces of information defined below.

  1. Name - This field can be anything that helps identify the data source being connected. (e.g. "Production Data" or "Product Metrics")
  2. Host - This is the Redshift address that typically takes the form of a string like '12345xyz.redshift.amazonaws.com'.
  3. Port - This is always 5439.
  4. User - This is the username for your Redshift database.
  5. Password - The password used to log into your Redshift Database.
  6. Database - The name of the Redshift database being connected to.Redshift creds in Row Zero

Once all the information is entered, hit 'Test connection' to ensure the information is correct. If the test connection icon turns green and says 'Connected', proceed by clicking on '+ Add Source.'

Add Redshift as data source screen in Row Zero

Write a query to import data

Now that Redshift is connected to a spreadsheet in Row Zero, write a SQL query to pull data into the spreadsheet. First select the 'Schema' from the drop down. Write a query in the query editor. The easiest query to write is the 'select *' statement, which pulls in the entire table. Example:

select * from TABLENAME

Row Zero is equipped to handle large data sets and will easily ingest the entirety of a table. Write more complicated queries to pull in various subsets of data stored in a Redshift Database. All results will be displayed in the connected data table in the spreadsheet.

Write a Redshift query in Row Zero

You're connected to the most powerful spreadsheet!

Now that Row Zero is connected to Redshift, you can easily export Redshift data to a spreadsheet in Row Zero. Row Zero is powerful enough to pull in entire Redshift tables, so you can create live pivot tables, build models, and run your favorite spreadsheet fuctions on top of your Redshift data without writing complex SQL queries. Easily adjust your query or refresh to get the latest data from Redshift without overwriting your work.