DataLab Docs
  • What is DataLab?
  • Work
    • Creating a workbook
    • Sharing a workbook
    • Managing a workbook
    • Code cell
      • Working with packages
    • Text cell
      • Including images
    • SQL cell
      • SQL scenarios
      • Parameterize your SQL query
    • Explore Data cell
    • Chart cell
      • Configuring your chart
      • Pivot charts
      • Migration guide
    • AI Assistant
    • Version history
    • Scheduled runs
    • Hiding and showing cells
    • Long-running cells
    • Report view
    • Environment variables
    • Git and GitHub
  • Connect to Data
    • Connect your data to DataLab
    • Sharing a Data Source
    • Airtable
    • Amazon Athena
    • Amazon S3
    • Databricks
    • Dropbox
    • Files
    • Google Drive
    • Google BigQuery
    • Google Sheets
    • MariaDB
    • Microsoft SQL Server
    • MongoDB
    • MotherDuck
    • MySQL
    • Oracle Database
    • PostgreSQL
    • Redshift
    • Snowflake
    • Supabase
  • Guides
    • Publish a notebook
    • Importing data from flat files
    • Resizing plots
    • Show Bokeh and Pyvis plots
  • Resources
    • Pricing
    • Manage group settings
    • Reporting for Group Admins
    • DataLab for education
    • Technical requirements
    • Addressing slow code
    • Address R vulnerability
    • Get help
Powered by GitBook
On this page
  • Set up a Redshift connection
  • Query the database

Was this helpful?

  1. Connect to Data

Redshift

PreviousPostgreSQLNextSnowflake

Last updated 1 year ago

Was this helpful?

Set up a Redshift connection

When inside a workbook, click View > Databases, then click the + icon and follow the on-screen instructions.

For detailed instructions, see Connect your data to DataLab.

Query the database

You can now query the Redshift data warehouse with a SQL cell. Select it in the Select source dropdown in the top left corner of a SQL cell, or select the sample Redshift data warehouse.

If you want to experiment with Redshift without setting up a connection, you can use our sample data warehouse with online ticket sales data ().

source
Create a Redshift connection
Example of a SQL cell using the ticket-sales connection. The query result is available as df.