You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/05/25 10:37:52 UTC
[GitHub] [superset] amihaygil opened a new issue, #20184: Can't see tables in RedShift that are from datashare
amihaygil opened a new issue, #20184:
URL: https://github.com/apache/superset/issues/20184
A clear and concise description of what the bug is.
#### How to reproduce the bug
1. Create Redshift cluster with datashare to another cluster.
2. Run in sqllab (you'll data)
3. Run in drop-down filter to see schema name (you'll see ) but table filter doesn't work
### Expected results
See table list
### Actual results
List is empty
#### Screenshots
If applicable, add screenshots to help explain your problem.
![image](https://user-images.githubusercontent.com/86407084/170243336-d8fe1b0e-f7da-4223-88c0-b17aa931e38c.png)
### Environment
(please complete the following information):
version Version: 0.0.0dev
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] macsir commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by "macsir (via GitHub)" <gi...@apache.org>.
macsir commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1701950589
I got this too in the same account but different clusters. Can't see the shared tables from consumers side. Is there any update or fix? Thanks.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] BhuviTheDataGuy commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
BhuviTheDataGuy commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1275772765
@amihaygil - we are trying to make the connection to a data share. In the database name - We gave the datashare db name, but its throwing error like, use cross-database querying not creating a connection.
How did you connect the datashare db without mentioning the database name in the SQL query?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] meixikyi commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
meixikyi commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1314732227
@amihaygil hello, did you find some way for this issue?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] mohrman commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
mohrman commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1336991506
@amihaygil This is the same for all database tools right? Like DataGrip, DBeaver etc? So it's actually related to the specific table not being accessible in a redshift shared database?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1337751164
> we are going to work this soon
Let @yousoph , @eschutho or I know if you need any help/input along the way. We look forward to the contribution/resolution!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Can't see tables in RedShift that are from datashare [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #20184: Can't see tables in RedShift that are from datashare
URL: https://github.com/apache/superset/issues/20184
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amihaygil commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
amihaygil commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1306729981
the idea is to map datashare from the sharing side to the shared side
`ALTER DATASHARE prod_datashare ADD SCHEMA mysql_stats_db_statslmn_stats; -- share from
CREATE EXTERNAL SCHEMA prod_mysql_stats_db_statslmn_stats
FROM REDSHIFT DATABASE 'prod_dwh' SCHEMA 'mysql_stats_db_statslmn_stats' -- shared to dev
ALTER DATASHARE prod_datashare ADD ALL TABLES IN SCHEMA mysql_stats_db_statslmn_stats;
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Can't see tables in RedShift that are from datashare [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1986422472
Hi there, and sorry this has gone quiet for so long. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale. If it is still an issue in Superset 3.x, we can re-open this, or feel free to open a new issue with updated context.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] thinhnd2104 commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
thinhnd2104 commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1143781106
Like [#122](https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/122). datashare metadata is in SVV_DATASHARES. So you can query it but can't see it in table schema.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amihaygil commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
amihaygil commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1140992472
latest we are using pip to install:
...
sqlalchemy-redshift \
psycopg2-binary==2.9.1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1137448632
What driver are you using? We've seen a random uptick in redshift issues, but people seem to be using a variety of drivers to connect.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] amihaygil commented on issue #20184: Can't see tables in RedShift that are from datashare
Posted by GitBox <gi...@apache.org>.
amihaygil commented on issue #20184:
URL: https://github.com/apache/superset/issues/20184#issuecomment-1314818161
not yet . we are going to work this soon
בתאריך יום ג׳, 15 בנוב׳ 2022 ב-5:54 מאת meixikyi <
***@***.***>:
> @amihaygil <https://github.com/amihaygil> hello, did you find some way
> for this issue?
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/superset/issues/20184#issuecomment-1314732227>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AUTHPLA3DWG3G2B623RPZV3WIMCNDANCNFSM5W4VHFPA>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org