I would like to know if it is possible to see a model defined in Looker from outside, for example with a JDBC connection. For instance, let’s start from a BigQuery connection, and the data model on Looker joins multiple table: I would like to know if there is a way to query the same data model with any other SQL client.
Solved! Go to Solution.
That would be an explore (defined in the model) where we join multiple tables. We do not have result of this joins as data somehow, it is only the code which will be used when query will be created.
And the result of the query is not saved neither - I mean here that there is no some table created/saved, which would have the result of “A join B”.
What we can do here is:
That would be an explore (defined in the model) where we join multiple tables. We do not have result of this joins as data somehow, it is only the code which will be used when query will be created.
And the result of the query is not saved neither - I mean here that there is no some table created/saved, which would have the result of “A join B”.
What we can do here is: