1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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';
답변함 일 년 전
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
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!