Query Amazon Redshift with SQL statement

First, connect to the Amazon Redshift cluster:

%%sql project.redshift --name external-rs-secret.redshift —language sql

You can replace %%sql project.redshift by using the dropdown to select the connection name and language. After connecting to the Amazon Redshift cluster, you can run an SQL query directly:

select * from public.users limit 5