kusto_pool_databases

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

Overview

Name	kusto_pool_databases
Type	Resource
Id	azure.synapse.kusto_pool_databases

Fields

Name	Datatype	Description
kind	string	Kind of the database
location	string	Resource location.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Returns a database.
list_by_kusto_pool	SELECT	kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Returns the list of databases of the given Kusto pool.
create_or_update	INSERT	databaseName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName, data__kind	Creates or updates a database.
delete	DELETE	databaseName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName	Deletes the database with the given name.
update	UPDATE	databaseName, kustoPoolName, resourceGroupName, subscriptionId, workspaceName, data__kind	Updates a database.

SELECT examples

Returns the list of databases of the given Kusto pool.

SELECT
kind,
location,
systemData
FROM azure.synapse.kusto_pool_databases
WHERE kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.kusto_pool_databases (
databaseName,
kustoPoolName,
resourceGroupName,
subscriptionId,
workspaceName,
data__kind,
location,
kind
)
SELECT 
'{{ databaseName }}',
'{{ kustoPoolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__kind }}',
'{{ location }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: kind
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a kusto_pool_databases resource.

/*+ update */
UPDATE azure.synapse.kusto_pool_databases
SET 
location = '{{ location }}',
kind = '{{ kind }}'
WHERE 
databaseName = '{{ databaseName }}'
AND kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}'
AND data__kind = '{{ data__kind }}';

DELETE example

Deletes the specified kusto_pool_databases resource.

/*+ delete */
DELETE FROM azure.synapse.kusto_pool_databases
WHERE databaseName = '{{ databaseName }}'
AND kustoPoolName = '{{ kustoPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';