database_extensions

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

Overview

Name	database_extensions
Type	Resource
Id	azure.sql.database_extensions

Fields

Name	Datatype	Description
properties	object	Contains the operation result properties for import/export operation.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, extensionName, resourceGroupName, serverName, subscriptionId	Gets a database extension. This will return resource not found as it is not supported.
list_by_database	SELECT	databaseName, resourceGroupName, serverName, subscriptionId	List database extension. This will return an empty list as it is not supported.
create_or_update	INSERT	databaseName, extensionName, resourceGroupName, serverName, subscriptionId	Perform a database extension operation, like polybase import

SELECT examples

List database extension. This will return an empty list as it is not supported.

SELECT
properties
FROM azure.sql.database_extensions
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.database_extensions (
databaseName,
extensionName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ databaseName }}',
'{{ extensionName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: operationMode
          value: string
        - name: storageKeyType
          value: string
        - name: storageKey
          value: string
        - name: storageUri
          value: string