Comments (16)
Bonus points: it would be pretty neat if when switching from GUI to SQL mode we could pre-populate the SQL editor with the SQL that would be generated by the GUI question. That said, I know the SQL queries we generate can be pretty verbose, so I'm not sure we want to show the user (even power users) "how the sausage is made", so to speak.
from metabase.
+1!
from metabase.
+1
from metabase.
+1
from metabase.
@tlrobinson +100
from metabase.
Most of the time the SQL we generate is parameterized, e.g. something like
SELECT *
FROM "my.table"
WHERE "my.table.field" = ?
So it's not like you can run the SQL we generate anyway 🙀
from metabase.
well, presumably, we could take the parameterized sql and insert the parameters in place of the ?
. Maybe we could find a javascript model on npm that could deal with that sort of craziness
from metabase.
+1
from metabase.
+1
from metabase.
This has no UX features, so aside from the difficulty of replacing parameterized SQL with the values (via string interpolation), this is ready to be worked on.
from metabase.
I think there are still some real UX implications with this one. The most obvious of which is where to put the toggle between SQL and GUI mode when it would need to be on the screen at all times. Currently it only needs to be there briefly on a new question and takes the place of several other buttons which aren't relevant on a new question. Or maybe there is a different UI mechanic for making this transition after a GUI card is formed?
We'll also want to be very clear about the UX around what happens after you do this and are looking at the SQL view, such as if there is any way to get back to GUI mode, etc.
from metabase.
This issue is limited to just the movement from GUI -> SQL and is a one-way transition.
In my mind, the toggle would remain on the GUI query builder. @kdoh + @mazameli, could we take a look at this?
from metabase.
+1
from metabase.
+1
from metabase.
Here's a prototype with a proposal for where to put the toggle and how this will all work. Once the prototype loads, click on the flashing blue dot to start the tour:
https://invis.io/WK77GMQM8#/156383432_New_Question
@kdoh @salsakran: let me know if you have any final thoughts.
from metabase.
I think it works. I would want to revisit the icon placement and reduce the number of different kinds of icons as we get into working on QB3 =)
from metabase.
Related Issues (20)
- Unable to edit metadata of model HOT 1
- Unreferenced columns in pivot table queries
- Support custom fonts in embedding SDK
- FE: support mixed stacking on line/bar/combo charts when series have suitable display types
- Events do not appear for current week when filtering on previous weeks
- The filter by time dialogue at the bottom of the screen should include "Include This X"
- Window function does not generate a correct inner query
- Overflow menu on collections list are not disappearing
- [BE] Metrics aren't working for Druid
- `PgConnection` has a `cancelQuery()` method, we should call it if the thread its running on gets killed
- Error message is ambiguous for running native queries with required parameters and no default value
- Params search endpoint is broken in stats HOT 1
- [dc.js migration] Tooltip shows data for a different x-value
- Cannot change the temporal unit or binning strategy for columns with long display names
- Ingest multiple MySQL schemas/databases from the same server HOT 1
- Comparing metrics is slow (joining metrics and selecting them in aggregation clause)
- Combining metrics does not work (joining metrics and using a custom expression to combine the metrics in the aggregation clause)
- Ignored schemas are not ignored
- Aggregation per Week on Metabase when using it integrated to Cube
- Removing a private key and adding a password results in connection failure on Snowflake
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from metabase.