4 ms·

I have been wondering how to support interactive / real-time web apps based on Snowflake data. I suppose pushing down to DuckDB a subset of data needed for a ch

• hipadev23 3y ago
  If you’re pushing down the data, you’re losing the real-time capability no? If you want fast, adhoc, real-time querying, load the data as it’s created directly into duckdb or clickhouse. Now you’ll have sub-100ms responses for most of your queries.
  • alextheparrot 3y ago
    I'd assume they mean users interacting with the chart vs first load. So the user sees the base chart (Let's say 1MB of data on the server, less depending what gets pushed to the user) and then additional filters, aggregations, etc. are pretty cheap because the server has a local copy to query against
    • izyda 3y ago
      Yes -- sorry, I meant exactly the above.