Reference organizational listings in queries

Note

Organizational listings can be queried without mounting.

To reference an organizational listing’s datasets in a SQL query, use the Uniform Listing Locator (ULL). The ULL serves as a unique identifier that points to a listing in the Internal Marketplace, making it easy to query its datasets directly.

  1. Sign in to Snowsight.

  2. In the navigation menu, select Data Products » Marketplace » Internal Marketplace.

  3. Browse or search for a data product.

  4. Select a listing and select Copy ULL.

  5. In the navigation menu, select Projects » Notebooks or another project tool.

  6. Write a SQL query, using the ULL in place of the database name.