1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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';
respondido hace un año
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año
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!