Skip to main content

storages

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

Overview

Namestorages
TypeResource
Idazure_extras.app_platform.storages

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource Id for the resource.
namestringThe name of the resource.
storageTypestringThe type of the storage. Required. "StorageAccount"
systemDataobjectMetadata pertaining to creation and last modification of the resource.
typestringThe type of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, service_name, storage_name, subscription_idGet the storage resource.
listselectresource_group_name, service_name, subscription_idList all the storages of one Azure Spring Apps resource.
create_or_updateinsertresource_group_name, service_name, storage_name, subscription_idCreate or update storage resource.
create_or_updatereplaceresource_group_name, service_name, storage_name, subscription_idCreate or update storage resource.
deletedeleteresource_group_name, service_name, storage_name, subscription_idDelete the storage resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resource_group_namestringThe name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. Required.
service_namestringThe name of the Service resource. Required.
storage_namestringThe name of the storage resource. Required.
subscription_idstring

SELECT examples

Get the storage resource.

SELECT
id,
name,
storageType,
systemData,
type
FROM azure_extras.app_platform.storages
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND service_name = '{{ service_name }}' -- required
AND storage_name = '{{ storage_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update storage resource.

INSERT INTO azure_extras.app_platform.storages (
properties,
resource_group_name,
service_name,
storage_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ service_name }}',
'{{ storage_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create or update storage resource.

REPLACE azure_extras.app_platform.storages
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND storage_name = '{{ storage_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete the storage resource.

DELETE FROM azure_extras.app_platform.storages
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND storage_name = '{{ storage_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;