Hi,
Im exploring Looker for first time, I have a simple requirement to publish query of table as View so that users when access the view can look at data in simple tabluar format. The intention is to basically expose some metadata information of Oracle table as it is to users.
I created a view but view practically cannot be accesses without dimensions or views, how can I just display view as it is as tabular data ?
Hello @okkaduco and welcome ๐
You cannot Explore in Looker without using dimensions/measures created in LookML, that is somewhat the whole point of the platform.
Are you aware of the view wizard that generates all the dimension from an existing table automagically?
Here is the link to the documentation
That may help you on the heavy lifting, then you only need to display the Explore in a table view, et voila!
You can also use the sql runner to query directly against a table and display it as is.
Thank you Cyril will take a look at that.