Sign inGet started

Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service. Deepnote integrates with Redshift seamlessly to bring the cloud data warehouse to your notebook.

What can you do with the Redshift integration?

The Redshift integration allows you to query databases and explore the structure of your warehouse. Think "SQL editor" but with all the modern productivity boosters that come with Deepnote's notebook. For example:

  • Write native SQL and Python in the same notebook
  • Search your entire warehouse instantly via the integrated schema explorer
  • Get intelligent autocomplete for columns, tables, and databases
  • Interactively explore data without writing any additional code

How to connect to Redshift

From the right-hand panel, under Integrations, click the + button and choose Create new integration.
create_integration.png

Select Redshift from the list of integrations or search for it using the search bar.
redshift_create.png

Fill out the fields in the pop-up form. You will need to know the Redshift hostname, which can be found on your AWS Redshift console.
redshift_modal.png

Connecting to Redshift with Python

Simple as installing the connector. pip install redshift_connector

import redshift_connector
conn = redshift_connector.connect(
     host='your_host',
     database='your_db',
     port=5439,
     user='your_user',
     password='your_password'
  )
  
# Create a Cursor object
cursor = conn.cursor()

# Query a table using the Cursor
cursor.execute("select * from book")
                
#Retrieve the query result set
result: tuple = cursor.fetchall()
print(result)
 (['One Hundred Years of Solitude', 'Gabriel García Márquez'], ['A Brief History of Time', 'Stephen Hawking'])

Using Redshift in Deepnote

Now that you're connected to Redshift, you can do the following: