You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "ErikIgnatiev (via GitHub)" <gi...@apache.org> on 2023/08/07 15:30:50 UTC
[GitHub] [superset] ErikIgnatiev opened a new issue, #24907: Redshift late-binding views cannot be added as datasets
ErikIgnatiev opened a new issue, #24907:
URL: https://github.com/apache/superset/issues/24907
When adding Redshift's [late-binding views](https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_VIEW.html) as datasets a "Table [`table name`] could not be found" error is raised, even though the view is seen in the loaded schema and access is granted to the parent table of the view. This stops adding new datasets from views and updating existing ones as the schema is not being loaded.
The vies can be explicitly queried in SQL Lab successfully, but the column list cannot be loaded in the side panel with an `Issue 1030 - The query has a syntax error.`
#### How to reproduce the bug
1. Go to `Datasets`
2. Click on `+Dataset`
3. Select a late-binding view from the populated list in `SEE TABLE SCHEMA` and click Add
4. See `An error occurred while creating datasets: (table_name) Table [*table name*] could not be found, please double check your database connection, schema, and table name`
### Expected results
Expected a new dataset to be created linked to the existing view.
### Actual results
Cannot create dataset as the table is listed as missing.
#### Screenshots
<img width="960" alt="Screenshot 2023-08-07 at 15 03 14" src="https://github.com/apache/superset/assets/28051792/dae1341a-0c70-4fac-827f-fe85ef9b9d5f">
<img width="1263" alt="Screenshot 2023-08-07 at 15 03 05" src="https://github.com/apache/superset/assets/28051792/cf1076e6-5231-4456-b9a0-6d3f99ffae44">
### Environment
(please complete the following information):
- browser type and version: `Chrome v115.0.5790.114`
- superset version: `v2.0.1`
- python version: `N/A`
- node.js version: `N/A`
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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] mdeshmu commented on issue #24907: Redshift late-binding views cannot be added as datasets
Posted by "mdeshmu (via GitHub)" <gi...@apache.org>.
mdeshmu commented on issue #24907:
URL: https://github.com/apache/superset/issues/24907#issuecomment-1668752849
@ErikIgnatiev Which redshift driver are you using pyscopg2 or redshift-connector? what is the version of sqlalchemy-redshift?
--
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] Redshift late-binding views cannot be added as datasets [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #24907: Redshift late-binding views cannot be added as datasets
URL: https://github.com/apache/superset/issues/24907
--
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] sfirke commented on issue #24907: Redshift late-binding views cannot be added as datasets
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24907:
URL: https://github.com/apache/superset/issues/24907#issuecomment-1668401534
@cbuffevant I see you are listed as a Redshift user, is this something you could validate/examine/help with?
--
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] Redshift late-binding views cannot be added as datasets [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24907:
URL: https://github.com/apache/superset/issues/24907#issuecomment-1989201495
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] mdeshmu commented on issue #24907: Redshift late-binding views cannot be added as datasets
Posted by "mdeshmu (via GitHub)" <gi...@apache.org>.
mdeshmu commented on issue #24907:
URL: https://github.com/apache/superset/issues/24907#issuecomment-1699423280
I am able to create a dataset using a late binding view.
--
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] ErikIgnatiev commented on issue #24907: Redshift late-binding views cannot be added as datasets
Posted by "ErikIgnatiev (via GitHub)" <gi...@apache.org>.
ErikIgnatiev commented on issue #24907:
URL: https://github.com/apache/superset/issues/24907#issuecomment-1669204254
> I can query late binding views properly in superset version 2.1.0 @ErikIgnatiev Which redshift driver are you using pyscopg2 or redshift-connector? what is the version of sqlalchemy-redshift?
Our Superset version is `2.0.1`. We're using `psycopg2 = "==2.9.3"` and `sqlalchemy-redshift = "==0.7.1"` in the image. By querying you mean adding a dataset? I can run successful queries in SQL Lab as well but getting the schema for creating new datasets fails.
--
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