vw_gpu_capacity

Creates, updates, deletes, gets or lists a vw_gpu_capacity resource.

Overview

Name	vw_gpu_capacity
Type	View
Id	nvidia.nvcf_deployments.vw_gpu_capacity

Fields

The following fields are returned by this view:

Name	Datatype	Description
cluster_group	string	Cluster group name (the backend named in a deployment specification).
cluster_group_id	string	Cluster group id.
gpu	string	GPU type available in the cluster group (for example L40
instance_type	string	Instance type name for the GPU (the instanceType of a deployment specification).
instance_description	string	Vendor description of the instance type.
is_default	boolean	Whether the instance type is the default for the GPU.
cluster	string	Name of the first cluster in the group.
nca_id	string	NVIDIA Cloud Account that owns the cluster group.

SELECT Examples

SELECT
  cluster_group,
  cluster_group_id,
  gpu,
  instance_type,
  instance_description,
  is_default,
  cluster,
  nca_id
FROM nvidia.nvcf_deployments.vw_gpu_capacity;

SQL Definition

Sqlite3

SELECT cg.name AS cluster_group,
       cg.id AS cluster_group_id,
       json_extract(g.value, '$.name') AS gpu,
       json_extract(it.value, '$.name') AS instance_type,
       json_extract(it.value, '$.description') AS instance_description,
       json_extract(it.value, '$.default') AS is_default,
       json_extract(cg.clusters, '$[0].name') AS cluster,
       cg.nca_id
FROM nvidia.nvcf_deployments.cluster_groups cg,
     json_each(cg.gpus) g,
     json_each(json_extract(g.value, '$.instanceTypes')) it

Postgres

SELECT cg.name AS cluster_group,
       cg.id AS cluster_group_id,
       g.value->>'name' AS gpu,
       it.value->>'name' AS instance_type,
       it.value->>'description' AS instance_description,
       (it.value->>'default')::boolean AS is_default,
       cg.clusters::jsonb->0->>'name' AS cluster,
       cg.nca_id
FROM nvidia.nvcf_deployments.cluster_groups cg,
     jsonb_array_elements(cg.gpus::jsonb) AS g(value),
     jsonb_array_elements(g.value->'instanceTypes') AS it(value)