resource_quotas

Operations on a resource_quotas resource.

Overview

Name	resource_quotas
Type	Resource
Id	databricks_workspace.unitycatalog.resource_quotas

Fields

Name	Datatype
last_refreshed_at	integer
parent_full_name	string
parent_securable_type	string
quota_count	integer
quota_limit	integer
quota_name	string

Methods

Name	Accessible by	Required Params	Description
getquota	SELECT	parent_full_name, parent_securable_type, quota_name, deployment_name	The GetQuota API returns usage information for a single resource quota, defined as a child-parent pair. This API also refreshes the quota count if it is out of date. Refreshes are triggered asynchronously. The updated count might not be returned in the first call.
listquotas	SELECT	deployment_name	ListQuotas returns all quota values under the metastore. There are no SLAs on the freshness of the counts returned. This API does not trigger a refresh of quota counts.

SELECT examples

resource_quotas (listquotas)

SELECT
last_refreshed_at,
parent_full_name,
parent_securable_type,
quota_count,
quota_limit,
quota_name
FROM databricks_workspace.unitycatalog.resource_quotas
WHERE deployment_name = '{{ deployment_name }}';

resource_quotas (getquota)

SELECT
last_refreshed_at,
parent_full_name,
parent_securable_type,
quota_count,
quota_limit,
quota_name
FROM databricks_workspace.unitycatalog.resource_quotas
WHERE parent_full_name = '{{ parent_full_name }}' AND
parent_securable_type = '{{ parent_securable_type }}' AND
quota_name = '{{ quota_name }}' AND
deployment_name = '{{ deployment_name }}';