There have been a number of posts recently on Google about the Data Studio PostgreSQL connector successfully connecting to Redshift as a data source. This seems to be a powerful solution for creating visualizations off Snowplow data.
Unfortunately I have not been able to get this to work - I get errors that it was unable to connect. I have added the IP’s to the white-list on AWS side.
Has anyone tried this and been able to use Data Studio with Redshift?
The Data Studio Postgres connector will default to only looking for tables in the public schema. You can work around this to get Redshift working my modifying the search_path for the user you are authenticating as for example:
create user datastudio_test with password '';
alter user datastudio_test set search_path to atomic;
grant usage on schema atomic to datastudio_test;
grant select on all tables in schema atomic to datastudio_test;
Or while connecting, instead of selecting the table from the list, you can select custom query and write the select query: SELECT * from schema_name.table_name; and Add/Reconnect.