How to query semantics in SQL via JDBC
world
is a virtual table that includes as columns every attribute of every entity that is exposed to the SQL interface.
Building the correct JOIN logic happens behind the scenes when world
is queried.
world
is the whole semantic model. If want to use the SQL interace on a subset of the world, for performance or access control reasons,
can instead use the SQL interface on a domain.world
: every domain is a flat table.
All the domains are in the domains
schema:
__branch_name
to the catalog name to connect to a development branch with the name branch_name
.
For example, when the workspace is called tpch_demo
and has a production branch and a development branch called dev
,
the corresponding JDBC catalogs would be called tpch_demo
and tpch_demo__dev
.
SUM
or a COUNT
) can be used.
SUM
) on a metric column the function is ignored,
and the actual metric computation runs instead.
AGG
is special function that when run on a metric, directly invokes its computation.
AGG
function to get metric value, as in the example above.WHERE
and with HAVING
) are applied.
For more details, see order of computation
WHERE
and on metrics using HAVING