I’m on version 9.0.0-beta and my main goal here is to query Redash usage data (what are the most viewed dashboards? which objects have not been used a long time and could probably be deprecated? etc).
I found evidence that this is or has been possible in the past:
select * from events where object_type='dashboard' and action='view' order by created_at desc
from this thread.
I have tried querying the Query Results data source for an
events table and found nothing (slightly related, I’m unable to see what tables/schemas are even available in this data source; I tried SQLite’s syntax to no avail:
.tables all failed).
If I am looking in the wrong place or if having an
events table depends on whether I’m self-hosted or not, I would love to know.
Hope this yields insight and helps others.