Schema:

Data Sharing Usage

MARKETPLACE_PROVIDER_SPCS_USAGE View

The MARKETPLACE_PROVIDER_SPCS_USAGE view in the Data Sharing Usage schema lets providers review their daily Snowpark Container Services (SPCS) usage. In this view, providers can see the number of compute pool hours and credits consumed by applications that the consumers purchased from the provider.

Columns

Column NameData TypeDescription
START_TIMEDATETIME

The date and beginning of the hour (in the local time zone) in which the usage took place.

END_TIMEDATETIME

The date and end of the hour (in the local time zone) in which the usage took place.

LISTING_NAMEVARCHARIdentifier for the listing.
LISTING_DISPLAY_NAMEVARCHARDisplay name of the listing.
LISTING_GLOBAL_NAMEVARCHARGlobal name of the listing.
IDENTIFIERVARCHARThe compute pool name.
CONSUMER_ACCOUNT_NAMEVARCHAR

Account locator of the consumer account. For more information about account identifiers, see Account identifiers.

CONSUMER_ACCOUNT_LOCATORVARCHARAccount locator of the consumer account.
CONSUMER_ORGANIZATION_NAMEVARCHAROrganization name for the consumer.
CREDITSVARCHARCredits consumed by the compute pool.
COMPUTE_HOURSVARCHARThe number of hours consumed by the compute pool.

Usage notes

  • Latency for the view can be up to 48 hours (2 days).
  • The data is retained for 365 days (1 year).

Examples

Retrieve the total number of SPCS compute pool hours consumed by each of your consumers.

SELECT
  start_time,
  end_time,
  listing_name,
  listing_display_name,
  listing_global_name,
  identifier,
  consumer_account_name,
  consumer_account_locator,
  consumer_organization_name,
  credits,
  compute_hours,
FROM snowflake.data_sharing_usage.marketplace_provider_spcs_usage;