Storage Locations represent a logical destination location in Snowflake for your database objects (views and tables). Each node in the graph you build is mapped to a single storage location.
When configuring workspaces, each of these Storage Locations are then mapped to physical locations (database.schema).
This allows for granular customization of where database objects are stored for each environment/workspace.
These should be a short but descriptive name for the purpose of the storage location.
A best practice is to separate your nodes into different storage locations that represent different groupings of datasets and to name them appropriately.
When adding sources in the build interface, only physical locations that are mapped to a storage location for that environment/workspace are available to be added.
This means that you will need to define a storage location for source tables and map that to a physical location for that environment/workspace.
To set as default or delete the storage location, click on the edit icon on the storage location card.
Default Storage Locations
Users can configure default storage locations for specific node types in specific workspaces. See Node Types for more details.
Once Storage Locations are configured, one can set Storage Mappings for them.
Updated about 2 months ago