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';
已回答 1 年前
相關內容
AWS 官方已更新 3 年前- AWS 官方已更新 1 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
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!