betodealmeida commented on pull request #14225:
URL: https://github.com/apache/superset/pull/14225#issuecomment-822929218
> Sounds interesting! Could you provide some possible Use Cases? Is this a
step towards paving the path to a LookML-like modeling layer?
Yeah, that's my vision. Improving the semantic layer in Superset so we can
do things like:
1. Define dimension tables, declare the relationship ("foreign keys") in
datasets, and have auto-joins in the Explore view, regardless of where the
tables live. There's some performance concerns here, so we'd probably want to
limit the cardinality of the dimensions.
2. Move data between DBs. This dialect supports DML, so you can `SELECT`
from a table in one DB and `INSERT` into a table in another. This could also
help materializing datasets/dimensions in different databases to improve JOINs.
3. Build connectors to APIs. This dialect is built on top of
[shillelagh](https://github.com/betodealmeida/shillelagh/), which helps
building SQL connectors to APIs. We can selectively enable in Superset some of
the adapters supported by shillelagh. Imagine using a Google Calendar to
annotate events on a time series, for example.
--
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
