exports

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

Overview

Name	exports
Type	Resource
Id	azure.cost_management.exports

Fields

vw_exports

Name	Datatype	Description
id	text	Resource Id.
name	text	Resource name.
definition	text	field from the properties object
delivery_info	text	field from the properties object
e_tag	text	field from the properties object
exportName	text	field from the properties object
format	text	field from the properties object
identity	text	Managed service identity (either system assigned, or none)
location	text	The location of the Export's managed identity. Only required when utilizing managed identity.
next_run_time_estimate	text	field from the properties object
partition_data	text	field from the properties object
run_history	text	field from the properties object
schedule	text	field from the properties object
scope	text	field from the properties object
type	text	Resource type.

exports

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.
identity	object	Managed service identity (either system assigned, or none)
location	string	The location of the Export's managed identity. Only required when utilizing managed identity.
properties	object	The properties of the export.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	exportName, scope	The operation to get the export for the defined scope by export name.
list	SELECT	scope	The operation to list all exports at the given scope.
create_or_update	INSERT	exportName, scope	The operation to create or update a export. 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	exportName, scope	The operation to delete a export.
execute	EXEC	exportName, scope	The operation to run an export.

SELECT examples

The operation to list all exports at the given scope.

vw_exports

SELECT
id,
name,
definition,
delivery_info,
e_tag,
exportName,
format,
identity,
location,
next_run_time_estimate,
partition_data,
run_history,
schedule,
scope,
type
FROM azure.cost_management.vw_exports
WHERE scope = '{{ scope }}';

exports

SELECT
id,
name,
eTag,
identity,
location,
properties,
type
FROM azure.cost_management.exports
WHERE scope = '{{ scope }}';

INSERT example

Use the following StackQL query and manifest file to create a new exports resource.

All Properties

/*+ create */
INSERT INTO azure.cost_management.exports (
exportName,
scope,
eTag,
identity,
location,
properties
)
SELECT 
'{{ exportName }}',
'{{ scope }}',
'{{ eTag }}',
'{{ identity }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: eTag
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
    - name: location
      value: string
    - name: properties
      value:
        - name: format
          value: string
        - name: deliveryInfo
          value:
            - name: destination
              value:
                - name: resourceId
                  value: string
                - name: container
                  value: string
                - name: rootFolderPath
                  value: string
                - name: sasToken
                  value: string
                - name: storageAccount
                  value: string
        - name: definition
          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: runHistory
          value:
            - name: value
              value:
                - - name: id
                    value: string
                  - name: name
                    value: string
                  - name: type
                    value: string
                  - name: eTag
                    value: string
                  - name: properties
                    value:
                      - name: executionType
                        value: string
                      - name: status
                        value: string
                      - name: submittedBy
                        value: string
                      - name: submittedTime
                        value: string
                      - name: processingStartTime
                        value: string
                      - name: processingEndTime
                        value: string
                      - name: fileName
                        value: string
                      - name: runSettings
                        value:
                          - name: format
                            value: string
                          - name: partitionData
                            value: boolean
                          - name: nextRunTimeEstimate
                            value: string
                      - name: error
                        value:
                          - name: code
                            value: string
                          - name: message
                            value: string
        - name: partitionData
          value: boolean
        - name: nextRunTimeEstimate
          value: string
        - name: schedule
          value:
            - name: status
              value: string
            - name: recurrence
              value: string
            - name: recurrencePeriod
              value:
                - name: from
                  value: string
                - name: to
                  value: string

DELETE example

Deletes the specified exports resource.

/*+ delete */
DELETE FROM azure.cost_management.exports
WHERE exportName = '{{ exportName }}'
AND scope = '{{ scope }}';