Storage Locations

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.

Storage Locations InterfaceStorage Locations Interface

Storage Locations Interface

New Storage Location

These should be a short but descriptive name for the purpose of the storage location.

New Storage Location Dialog BoxNew Storage Location Dialog Box

New Storage Location Dialog Box

A best practice is to separate your nodes into different storage locations that represent different groupings of datasets and to name them appropriately.

📘

Note

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.

Edit Storage Location

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.

Edit Storage Mapping Dialog BoxEdit Storage Mapping Dialog Box

Edit Storage Mapping Dialog Box


Did this page help you?