memory_stores

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

Overview

Name	memory_stores
Type	Resource
Id	databricks_workspace.agentkit.memory_stores

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Resource name in the form ``memory-stores/{managed_memory_store_id}``.
creator_user_id	string	Workspace-local user ID of the authenticated principal that created the store. This is immutable server-set attribution and does not grant access; authorization is evaluated from the authenticated request context.
owner_user_id	string	Deprecated alias for ``creator_user_id``. This identifies the original creator, not a transferable owner. Use ``creator_user_id`` instead.
workspace_id	integer	Workspace that owns the memory store.
display_name	string	Deprecated compatibility alias for the caller-provided memory store ID. Canonical clients provide the ID through ``CreateMemoryStoreRequest.managed_memory_store_id`` and use ``name`` as the resource identifier.
create_time	string (date-time)	Time when the store was created.
description	string	Human-readable description of the memory store.
▶storage_backend	object	Service-managed storage backing this memory store.
update_time	string (date-time)	Time when the store was last updated.

list

Name	Datatype	Description
name	string	Resource name in the form ``memory-stores/{managed_memory_store_id}``.
creator_user_id	string	Workspace-local user ID of the authenticated principal that created the store. This is immutable server-set attribution and does not grant access; authorization is evaluated from the authenticated request context.
owner_user_id	string	Deprecated alias for ``creator_user_id``. This identifies the original creator, not a transferable owner. Use ``creator_user_id`` instead.
workspace_id	integer	Workspace that owns the memory store.
display_name	string	Deprecated compatibility alias for the caller-provided memory store ID. Canonical clients provide the ID through ``CreateMemoryStoreRequest.managed_memory_store_id`` and use ``name`` as the resource identifier.
create_time	string (date-time)	Time when the store was created.
description	string	Human-readable description of the memory store.
▶storage_backend	object	Service-managed storage backing this memory store.
update_time	string (date-time)	Time when the store was last updated.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	managed_memory_store_id, deployment_name, workspace_domain		Retrieves a memory store by resource name. Returns NOT_FOUND when the store does not exist in the
list	select	deployment_name, workspace_domain	page_size, page_token	Lists memory stores in the caller's workspace.
create	insert	managed_memory_store_id, deployment_name, workspace_domain		Creates a memory store in the caller's workspace.
update	update	managed_memory_store_id, update_mask, deployment_name, workspace_domain		Updates a memory store's description and metadata.
delete	delete	managed_memory_store_id, deployment_name, workspace_domain		Deletes a memory store by resource name. Returns NOT_FOUND when the store does not exist in the

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.

Name	Datatype	Description
deployment_name	string	The Databricks workspace deployment name: the host prefix of the workspace URL (dbc-abcd0123-a1bc on AWS, adb-1234567890123456.7 on Azure, 1234567890123456.7 on GCP). Set DATABRICKS_DEPLOYMENT_NAME to default it for the session. (default: dbc-abcd0123-a1bc, x-stackQL-envVar: DATABRICKS_DEPLOYMENT_NAME)
managed_memory_store_id	string	The managed_memory_store_id segment of the name resource name (memory-stores/{managed_memory_store_id}). Resource name in the form memory-stores/{managed_memory_store_id}.
update_mask	object	Only description and metadata may be updated. Selecting metadata replaces the entire map.
workspace_domain	string	The Databricks workspace domain suffix for the cloud. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws). (default: cloud.databricks.com, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"cloud.databricks.com","azure":"azuredatabricks.net","gcp":"gcp.databricks.com"}})
page_size	integer	Maximum number of stores to return. The service may return fewer stores than requested. Defaults to 10; must be between 1 and 100.
page_token	string	Opaque pagination token from a previous ListManagedMemoryStores response.

SELECT examples

get

Retrieves a memory store by resource name. Returns NOT_FOUND when the store does not exist in the

SELECT
name,
creator_user_id,
owner_user_id,
workspace_id,
display_name,
create_time,
description,
storage_backend,
update_time
FROM databricks_workspace.agentkit.memory_stores
WHERE managed_memory_store_id = '{{ managed_memory_store_id }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND workspace_domain = '{{ workspace_domain }}' -- required
;

list

Lists memory stores in the caller's workspace.

SELECT
name,
creator_user_id,
owner_user_id,
workspace_id,
display_name,
create_time,
description,
storage_backend,
update_time
FROM databricks_workspace.agentkit.memory_stores
WHERE deployment_name = '{{ deployment_name }}' -- required
AND workspace_domain = '{{ workspace_domain }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

INSERT examples

create

Creates a memory store in the caller's workspace.

INSERT INTO databricks_workspace.agentkit.memory_stores (
create_time,
creator_user_id,
description,
display_name,
name,
owner_user_id,
storage_backend,
update_time,
workspace_id,
managed_memory_store_id,
deployment_name,
workspace_domain
)
SELECT 
'{{ create_time }}',
'{{ creator_user_id }}',
'{{ description }}',
'{{ display_name }}',
'{{ name }}',
'{{ owner_user_id }}',
'{{ storage_backend }}',
'{{ update_time }}',
{{ workspace_id }},
'{{ managed_memory_store_id }}',
'{{ deployment_name }}',
'{{ workspace_domain }}'
RETURNING
name,
creator_user_id,
owner_user_id,
workspace_id,
display_name,
create_time,
description,
storage_backend,
update_time
;

Manifest

# Description fields are for documentation purposes
- name: memory_stores
props:
  - name: managed_memory_store_id
    value: "{{ managed_memory_store_id }}"
    description: Required parameter for the memory_stores resource.
  - name: deployment_name
    value: "{{ deployment_name }}"
    description: Required parameter for the memory_stores resource.
  - name: workspace_domain
    value: "{{ workspace_domain }}"
    description: Required parameter for the memory_stores resource.
  - name: create_time
    value: "{{ create_time }}"
    description: |
      Time when the store was created.
  - name: creator_user_id
    value: "{{ creator_user_id }}"
    description: |
      Workspace-local user ID of the authenticated principal that created the store. This is immutable server-set attribution and does not grant access; authorization is evaluated from the authenticated request context.
  - name: description
    value: "{{ description }}"
    description: |
      Human-readable description of the memory store.
  - name: display_name
    value: "{{ display_name }}"
    description: |
      Deprecated compatibility alias for the caller-provided memory store ID. Canonical clients provide the ID through ``CreateMemoryStoreRequest.managed_memory_store_id`` and use ``name`` as the resource identifier.
  - name: name
    value: "{{ name }}"
    description: |
      Resource name in the form ``memory-stores/{managed_memory_store_id}``.
  - name: owner_user_id
    value: "{{ owner_user_id }}"
    description: |
      Deprecated alias for ``creator_user_id``. This identifies the original creator, not a transferable owner. Use ``creator_user_id`` instead.
  - name: storage_backend
    description: |
      Service-managed storage backing this memory store.
    value:
      backend_id: "{{ backend_id }}"
      backend_type: "{{ backend_type }}"
  - name: update_time
    value: "{{ update_time }}"
    description: |
      Time when the store was last updated.
  - name: workspace_id
    value: {{ workspace_id }}
    description: |
      Workspace that owns the memory store.

UPDATE examples

update

Updates a memory store's description and metadata.

UPDATE databricks_workspace.agentkit.memory_stores
SET 
create_time = '{{ create_time }}',
creator_user_id = '{{ creator_user_id }}',
description = '{{ description }}',
display_name = '{{ display_name }}',
name = '{{ name }}',
owner_user_id = '{{ owner_user_id }}',
storage_backend = '{{ storage_backend }}',
update_time = '{{ update_time }}',
workspace_id = {{ workspace_id }}
WHERE 
managed_memory_store_id = '{{ managed_memory_store_id }}' --required
AND update_mask = '{{ update_mask }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND workspace_domain = '{{ workspace_domain }}' --required
RETURNING
name,
creator_user_id,
owner_user_id,
workspace_id,
display_name,
create_time,
description,
storage_backend,
update_time;

DELETE examples

delete

Deletes a memory store by resource name. Returns NOT_FOUND when the store does not exist in the

DELETE FROM databricks_workspace.agentkit.memory_stores
WHERE managed_memory_store_id = '{{ managed_memory_store_id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND workspace_domain = '{{ workspace_domain }}' --required
;