Skip to main contentThere are two methods for storing data in Canvas.
You can either use a Save Tables to store data in a table. This table will be available in other models. The table is stored on our secure infrastructure. Enterprise clients can self-host the storage if they want to.
Alternatively, you can set up a Destination and then use the Destination tool to store and send your data to a destination. This destination can be a database like Snowflake, a worksheet like Google Sheets, or even an email like Gmail.
Why is this smart?
There are several reasons why we think this setup is smart.
- Avoid cluttering you destinations. If you use a database Destination like Snowflake, you can avoid storing unnecessary data in your database. Imagine you have a process of 10 models - each outputting one table. The first 9 models can store the table in Less and only the last model will store the table in the destination. Saves costs and avoids cluttering your database.
- Set once once, use everywhere. If you set up a destination once, you can use it in all your models. You don’t have to set it up in each model.
- Optimized for performance and data analytics. Our storage is highly optimized for performance and data analytics. You don’t have to spend time setting it up and you can start using it immediately.
