2 ms·
> How? Largely “join indexes” and “aggregation indexes” which seem to smell like cubes. Just curious. What stops snowflake from adding these too. Trying to un
by dominotw 5y ago
> How? Largely “join indexes” and “aggregation indexes” which seem to smell like cubes.
Just curious. What stops snowflake from adding these too. Trying to understand what innovation firebolt is doing.
- willvarfar 5y agoHopefully nothing. I only understand these systems about as well as you can without actually fighting them in production, so ymmv ;) There are things that Firebolt are doing regards SSD caching that its easy to see are going to massively help performance but also hinder one nice aspect of Snowflake which is that one Snowflake region can read-only access the storage of another. I'm guessing that this is via direct S3 access, but the moment there is tiered storage, inter-cluster and inter-region access would have to be inter-compute-cluster instead etc.