View in #general on Slack
@Joe_Chandler: I’m running CubeJS using a docker-compose file. In development mode, my preaggregations are still being stored in my database and not the instance of cubestore running locally even thought I set
external: true on the preaggregations. Anyone else have this issue?
@Spencer_E: When I use it, preaggregations are still created in my database, but they get synced to Cubestore afterwards. Future queries will hit cubestore instead
The response from CubeJS will have
external: true if the data came from your external storage instead of the preagg table.
@Joe_Chandler: Is this only in development mode or will this happen in production too
@Spencer_E: I believe this is how it works
The preagg table is a staging area before it gets synced into Cubestore
I’m using Snowflake so I just created a completely separate database to store the pre aggregations.
@ovr: > I believe this is how it works
You are right. We are using CREATE TABLE AS SELECT to create tables for pre-aggregations in source storage. Next, Cube.js uses downloading/streaming/unloading to transfer tables between source & external storage.
@Igor_Lukanin: @Spencer_E Thanks for your help! You’re right