Storage Locations and Storage Mappings in Coalesce are interrelated concepts but differ in context and use. A Storage Location is a logical destination and a prerequisite for a Storage Mapping, which is a physical destination in your database (Snowflake).
A comparison of the two objects is provided below:
A logical destination for the objects you use as sources for and/or create within Coalesce (e.g. views and tables in the form of Nodes); each Coalesce Node is mapped to a single Storage Location, but a single Storage Location may be mapped to many Nodes.
|A physical destination--database and schema--in Snowflake, that is defined for a Storage Location for a given Workspace / Environment.
Example of Storage Locations mapped (Storage Mappings) within an Environment (UAT):