1 Answer
- Newest
- Most votes
- Most comments
1
You cannot connect to database created from datasharing since it is an external database. Redshift have a cross-database query feature which allows you to access tables in other database by <database>.<schema>.<table> but some BI tools are not compatible with this syntax. In this case, you can create an external schema in your local database which references the external database.
dev <- local database
┗public
┗public_ext <- create this schema
dev_ext <- external database from datasharing
┗public
Query to create the schema:
CREATE EXTERNAL SCHEMA public_ext FROM REDSHIFT DATABASE 'dev_ext' SCHEMA 'public';
answered a year ago
Relevant content
- asked a year ago
- Accepted Answerasked 6 months ago
- Accepted Answerasked 2 months ago
AWS OFFICIALUpdated a year ago- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
Hi Yota, thanks very much for this response. I have just created the external schema(referring to the datasharing DB) in my redshift local DB successfully. Unfortunately, I cannot access redshift vis PowerBI from my Home PC but only from office network. So I cannot wait to go office tomorrow to try this out. After that I will mark your answer as accepted but thank you, thank you, thank you for this!
Tested this with Power BI and confirmed this approach works. Very useful and thanks Yota!
Great, thank you for the update!