views
Creates, updates, deletes, gets or lists a views resource.
Overview
| Name | views |
| Type | Resource |
| Id | azure.cost_management.views |
Fields
- vw_views
- views
| Name | Datatype | Description |
|---|---|---|
id | text | Resource Id. |
name | text | Resource name. |
accumulated | text | field from the properties object |
chart | text | field from the properties object |
created_on | text | field from the properties object |
currency | text | field from the properties object |
date_range | text | field from the properties object |
display_name | text | field from the properties object |
e_tag | text | field from the properties object |
kpis | text | field from the properties object |
metric | text | field from the properties object |
modified_on | text | field from the properties object |
pivots | text | field from the properties object |
query | text | field from the properties object |
scope | text | field from the properties object |
type | text | Resource type. |
viewName | text | field from the properties object |
| Name | Datatype | Description |
|---|---|---|
id | string | Resource Id. |
name | string | Resource name. |
eTag | string | eTag of the resource. To handle concurrent update scenario, this field will be used to determine whether the user is updating the latest version or not. |
properties | object | The properties of the view. |
type | string | Resource type. |
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | viewName | Gets the view by view name. |
get_by_scope | SELECT | scope, viewName | Gets the view for the defined scope by view name. |
list | SELECT | | Lists all views by tenant and object. |
list_by_scope | SELECT | scope | Lists all views at the given scope. |
create_or_update | INSERT | viewName | The operation to create or update a view. Update operation requires latest eTag to be set in the request. You may obtain the latest eTag by performing a get operation. Create operation does not require eTag. |
delete | DELETE | viewName | The operation to delete a view. |
delete_by_scope | DELETE | scope, viewName | The operation to delete a view. |
SELECT examples
Lists all views by tenant and object.
- vw_views
- views
SELECT
id,
name,
accumulated,
chart,
created_on,
currency,
date_range,
display_name,
e_tag,
kpis,
metric,
modified_on,
pivots,
query,
scope,
type,
viewName
FROM azure.cost_management.vw_views
;
SELECT
id,
name,
eTag,
properties,
type
FROM azure.cost_management.views
;
INSERT example
Use the following StackQL query and manifest file to create a new views resource.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.cost_management.views (
viewName,
eTag,
properties
)
SELECT
'{{ viewName }}',
'{{ eTag }}',
'{{ properties }}'
;
- name: your_resource_model_name
props:
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: eTag
value: string
- name: properties
value:
- name: displayName
value: string
- name: scope
value: string
- name: createdOn
value: string
- name: modifiedOn
value: string
- name: dateRange
value: string
- name: currency
value: string
- name: query
value:
- name: type
value: string
- name: timeframe
value: string
- name: timePeriod
value:
- name: from
value: string
- name: to
value: string
- name: dataSet
value:
- name: granularity
value: string
- name: configuration
value:
- name: columns
value:
- string
- name: aggregation
value: object
- name: grouping
value:
- - name: type
value: []
- name: name
value: string
- name: sorting
value:
- - name: direction
value: string
- name: name
value: string
- name: filter
value:
- name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: dimensions
value: []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: or
value:
- - name: and
value:
- []
- name: or
value:
- []
- name: includeMonetaryCommitment
value: boolean
- name: chart
value: string
- name: accumulated
value: string
- name: metric
value: string
- name: kpis
value:
- - name: type
value: string
- name: id
value: string
- name: enabled
value: boolean
- name: pivots
value:
- - name: type
value: string
- name: name
value: string
DELETE example
Deletes the specified views resource.
/*+ delete */
DELETE FROM azure.cost_management.views
WHERE viewName = '{{ viewName }}';