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 2020/01/03 17:43:57 UTC
[GitHub] [incubator-superset] FredericoCoelhoNunes opened a new issue #8921:
Allow creating datasources from a custom SQL query,
when using the filter_values function.
FredericoCoelhoNunes opened a new issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
URL: https://github.com/apache/incubator-superset/issues/8921
**Is your feature request related to a problem? Please describe.**
My problem arises when I want to create a chart that responds to filters in the dashboard in a customized way, making use of the templating engine and the filter_values() function.
I usually know what SQL query I need, so I go to SQL Lab, write the query with the filter_values() function already included, and... no values are returned. I can't "explore" the results and create my chart!
What I usually do (which is what frustrates me) is: I create a version of the query which returns some results (with placeholder values for the filters), and then in the chart I edit my datasource and add all the filter_values() lines.
**Describe the solution you'd like**
I would like it to be possible to add datasources directly from SQL code, with a better interface for changing these datasources (currently it's a tiny text box when I click the grey Datasource box in the Chart tab).
I would also like to be able to name these datasources something other than *null.my_username-query_name-random_string*.
**Describe alternatives you've considered**
An alternative would be allowing the user to "explore" queries that return no results directly from SQL Lab, because queries with the filter_values() function can only ever return results when inside a dashboard with the respective filters.
**Additional context**
None.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #8921: Allow
creating datasources from a custom SQL query,
when using the filter_values function.
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
URL: https://github.com/apache/incubator-superset/issues/8921#issuecomment-594099395
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #8921:
Allow creating datasources from a custom SQL query,
when using the filter_values function.
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
URL: https://github.com/apache/incubator-superset/issues/8921#issuecomment-570644615
Issue-Label Bot is automatically applying the label `#enhancement` to this issue, with a confidence of 0.85. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] closed issue #8921: Allow creating
datasources from a custom SQL query, when using the filter_values function.
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
URL: https://github.com/apache/incubator-superset/issues/8921
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] ogrehunter commented on issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
Posted by GitBox <gi...@apache.org>.
ogrehunter commented on issue #8921:
URL: https://github.com/apache/incubator-superset/issues/8921#issuecomment-709703918
Very good feature indeed, I found myself cannot add tables from another schema on my database although the table can be accessed from SQL Editor. Maybe allowing to create data source from SQL Query should solve my problem.
----------------------------------------------------------------
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.
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] [incubator-superset] Provoo commented on issue #8921: Allow creating datasources from a custom SQL query, when using the filter_values function.
Posted by GitBox <gi...@apache.org>.
Provoo commented on issue #8921:
URL: https://github.com/apache/incubator-superset/issues/8921#issuecomment-751809101
I don't understand why is so complicated to allow users, to create custom querys for present as a tables in multiples dashboards or even just only duplicate a virtaul datasource to change database a present multiplo charts. I have to create an entire dashboard with same graphs and the only diference is the Physical Table. I really like superset but has to much problems.
----------------------------------------------------------------
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.
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