Schemas:

ACCOUNT_USAGE

OPENFLOW_USAGE_HISTORY view

This Account Usage view returns the hourly runtime credit usage for an account within the last 365 days (1 year).

Columns

Column NameData TypeDescription
START_TIMETIMESTAMP_LTZThe date and beginning of the hour (in the local time zone) in which the usage took place.
END_TIMETIMESTAMP_LTZThe date and end of the hour (in the local time zone) in which the usage took place.
DATA_PLANE_IDVARCHARID of the data plane which incurred the credit usage.
DATA_PLANE_NAMEVARCHARName of the data plane which incurred the credit usage.
DATA_PLANE_TYPEVARCHAR

Type of the data plane. Supported values include:

  • BYOC
  • SNOWFLAKE
DATA_PLANE_CREDITS_USEDNUMBER

Number of compute credits the data plane used in the hour. The data plane credits are only incurred for SNOWFLAKE data planes. For BYOC, there are no credits incurred for data planes and customers are charged credits only for runtime usage.

RUNTIME_IDVARCHARID of the runtime which incurred the credit usage.
RUNTIME_NAMEVARCHARName of the runtime which incurred the credit usage.
RUNTIME_TYPEVARCHAR

Type of the runtime. Supported values include:

  • RUNTIME
  • READ_ONLY RUNTIME
RUNTIME_CREDITS_USEDNUMBERNumber of compute credits the runtime used in the hour. This does not include the credits used by the data plane or the credits used to ingest the data in Snowflake.