You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In #150, In order to enhance our query performance after users send the API request to run our data endpoint to get the result from the data source. We need to provide a Caching (pre-loading) Layer with the duckDB to enhance query performance.
Describe the solution you’d like
Define the tag scope of {% cache %} ... {% endcache %} to parse the scope of {% cache %} ... {% endcache %} tag and send the SQL to duckDB.
-- The "cache" scope means the SQL statement will send the query to duckDB cache data source
{% cache %}
select*from order
where type = {{ context.params.type }}
andwhere exists (
select*from product where price >= {{ context.params.price }}
andorder.product_id=product.id
)
{% endcache %}
Additional Context
In the build time, define a CacheTagBuilder to parse {% cache %} … {% endcache %} to the AST tree, set the cache metadata name cache.vulcan.com to make schema parser #151 to work, then keep to the artifact.
The text was updated successfully, but these errors were encountered:
What’s the problem you're trying to solve
In #150, In order to enhance our query performance after users send the API request to run our data endpoint to get the result from the data source. We need to provide a Caching (pre-loading) Layer with the duckDB to enhance query performance.
Describe the solution you’d like
Define the tag scope of
{% cache %} ... {% endcache %}
to parse the scope of{% cache %} ... {% endcache %}
tag and send the SQL to duckDB.Additional Context
In the build time, define a
CacheTagBuilder
to parse{% cache %} … {% endcache %}
to the AST tree, set the cache metadata namecache.vulcan.com
to make schema parser #151 to work, then keep to the artifact.The text was updated successfully, but these errors were encountered: