Hi all, I have a question about the `Queries` tab....
# ingestion
a
Hi all, I have a question about the
Queries
tab. Since the default timeframe for ingesting usage (I am working with BigQuery) is the past day, if the database is not frequently used, all the
Queries
tab has is the ingestion queries, which is not very useful. I was wondering if there is a way to modify the default timeframe (instead of hard-coding `start_time`and
end_time
) to like 5 days. Also wondering if there is a way to ignore the queries ran by the ingestion job
m
@agreeable-hamburger-38305, Just trying to understand your use case. What is the cadence with which you plan on running the usage source? If you are scheduling the usage ingestion for everyday, the 1 day granularity would suffice. (Although, I agree that a configurable window can be a handy feature)
a
I am scheduling the usage ingestion everyday, my concern is that the database is not queried that often, so something like a 1 week window should be more representative of how the users actually use the tables
My understanding is that the usage ingestion only looks at the queries ran in the past day, is that right?
m
If the start and end date is not specified, the default window is a day.
e
@miniature-tiger-96062 This is an issue with the frontend client only using the data from the last bucket
We should instead aggregate the sample queries and sample from them
cc @helpful-optician-78938