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 environments, 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.
Typical mapping configurations include mapping all storage locations for an environment to the same physical location, or customizing each storage location for that environment to a unique physical location.
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 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.
To set as default or delete the storage location, click on the edit icon on the storage location card.
You can also set which location is the default location on new Nodes as you build your graph.
Updated 4 months ago