Environment
-
Version:
v0.10.4
-
OS: macOS - x86
What's wrong?
The refreshExpression seems to not function. It does not invalidate the cache and refresh it based on the SQL expression.
Backend DB : BigQuery
The following is the example YAML config :
....
sql: |
SELECT
*
FROM
mytable
profile: bq
refreshExpression:
expression: "MAX(_processed_at)"
every: "30s"
Please note that just using the refreshTime works without problems.
What's the correct behavior?
A SQL request should be sent every 30 s based on the above config to BigQuery to check and invalidate the cache.
Reproducing steps
Environment
Version:
v0.10.4
OS: macOS - x86
What's wrong?
The
refreshExpressionseems to not function. It does not invalidate the cache and refresh it based on the SQL expression.Backend DB : BigQuery
The following is the example YAML config :
Please note that just using the
refreshTimeworks without problems.What's the correct behavior?
A SQL request should be sent every 30 s based on the above config to BigQuery to check and invalidate the cache.
Reproducing steps