refreshExpression does not send a SQL request to the backend DB at the specified intervals

[NithinKumaraNT]

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

[onlyjackfrost]

Hi @NithinKumaraNT
refreshExpression is not fully implemented yet, you can only use refreshTime for now.

[NithinKumaraNT]

Hi @onlyjackfrost, If I can ask, when can we expect this feature :) ?

[onlyjackfrost]

I can't tell, since we are focusing on https://github.com/Canner/WrenAI currently. But I'll take a look maybe this weekend or the next...

If you would like to contribute, I'm glad to guide you through the codebase =D You can pin me on Discord