Skip to main content

SYS.ORGANIZATION.USAGE

The sys.organization.usage table contains data about an organization's usage.

Syntax
SELECT * 
FROM sys.organization.usage
note

Queries to sys.organization.usage will return 365 days of usage data, if available.

Example Output

replica_idengine_identity_identity_typestart_timeend_timeinstance_countinstance_typeinstance_hourly_cost_dcustotal_usage_dcus
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 03:45:05.8972021-12-21 04:00:00.0001m5d.4xlarge4.00.9934477777777778
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 04:00:00.0002021-12-21 05:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 05:00:00.0002021-12-21 06:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 06:00:00.0002021-12-21 07:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 07:00:00.0002021-12-21 08:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 08:00:00.0002021-12-21 09:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 09:00:00.0002021-12-21 10:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 10:00:00.0002021-12-21 11:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 11:00:00.0002021-12-21 12:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 12:00:00.000 2021-12-2113:00:00.0001m5d.4xlarge4.04.0
1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe2049e2a8-fc8d-48bd-98ed-c1554dfaef0b0c6e634e-0546-4da8-8e81-6b7b9f15530cPROJECT2021-12-21 13:00:00.0002021-12-21 14:00:00.0001m5d.4xlarge4.04.0
91a27226-147b-4c26-bbf4-0dcb583d21ab21f9ff22-6ef6-4ae7-9d7c-dc753c626e36613db1ea-5bff-4f15-9c93-16c1558b3cedPROJECT2021-12-21 14:00:00.0002021-12-21 15:00:00.0001STANDARD_D16S_V34.04.0
91a27226-147b-4c26-bbf4-0dcb583d21ab21f9ff22-6ef6-4ae7-9d7c-dc753c626e36613db1ea-5bff-4f15-9c93-16c1558b3cedPROJECT2021-12-21 15:00:00.0002021-12-21 16:00:00.0001STANDARD_D16S_V34.04.0

Fields

FieldData TypeDescription
replica_idvarcharThe UUID to identify the engine replica that this usage data point is for.
engine_idvarcharThe UUID to identify the engine that that this usage data point is for.
entity_idvarcharThe UUID to identify the project or catalog that this usage data point is for.
entity_typevarcharENUM = PROJECT, CATALOG
start_timetimestampThe engine replica start time.
end_timetimestampThe engine replica stop time.
instance_typevarcharThe virtual machine instance type that makes up the engine (for example, m5d.4xlarge or STANDARD_B8MS)
instance_hourly_cost_dcusdoubleThe cost of the instance type in DCUs.
total_usage_dcusdoubleThe cost in DCUs for the time that the engine was running. This is calculated by the time that the engine replica was running multiplied by the hourly cost of the instance type.
instance_countintegerThe number of virtual machine instances that are provisioned for the replica.