managed_accounts

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

Overview

Name	managed_accounts
Type	Resource
Id	snowflake.managed_account.managed_accounts

Fields

Name	Datatype	Description
name	string	A Snowflake object identifier. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
account_locator_url	string	Account URL that is used to connect to the account, in the legacy account locator format.
account_type	string	Type of the account.
admin_name	string	Name of the account administrator.
admin_password	string	Password for the account administrator.
cloud	string	Cloud in which the managed account is located. For reader accounts, this is always the same as the cloud for the provider account.
comment	string	Optional comment in which to store information related to the account.
created_on	string	Date and time the account was created.
locator	string	Legacy identifier for the account.
region	string	Region in which the managed account is located. For reader accounts, this is always the same as the region for the provider account.
url	string	Account URL that is used to connect to the account, in the account name format. The account identifier in this format follows the pattern {orgname}-{account_name}.

Methods

Name	Accessible by	Required Params	Optional Params	Description
list_managed_accounts	SELECT	endpoint	like	Lists the accessible managed accounts.
create_managed_account	INSERT	data__account_type, data__admin_name, data__admin_password, data__name, endpoint	-	Creates a managed account. You must provide the full managed account definition when creating a managed account.
delete_managed_account	DELETE	name, endpoint	-	Removes a managed account, including all objects created in the account, and immediately restricts access to the account. Currently used by data providers to create reader accounts for their consumers. For more details, see Manage reader accounts.

Optional Parameter Details

Name	Description	Type	Default
like	Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters.	string	-

SELECT examples

Lists the accessible managed accounts.

SELECT
name,
account_locator_url,
account_type,
admin_name,
admin_password,
cloud,
comment,
created_on,
locator,
region,
url
FROM snowflake.managed_account.managed_accounts
WHERE endpoint = '{{ endpoint }}';

INSERT example

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

Required Properties

/*+ create */
INSERT INTO snowflake.managed_account.managed_accounts (
data__name,
data__comment,
data__admin_name,
data__admin_password,
data__account_type,
endpoint
)
SELECT 
'{{ name }}',
'{{ comment }}',
'{{ admin_name }}',
'{{ admin_password }}',
'{{ account_type }}',
'{{ endpoint }}'
;

All Properties

/*+ create */
INSERT INTO snowflake.managed_account.managed_accounts (
data__name,
data__admin_name,
data__admin_password,
data__account_type,
endpoint
)
SELECT 
'{{ name }}',
'{{ admin_name }}',
'{{ admin_password }}',
'{{ account_type }}',
'{{ endpoint }}'
;

Manifest

- name: managed_accounts
  props:
    - name: data__account_type
      value: string
    - name: data__admin_name
      value: string
    - name: data__admin_password
      value: string
    - name: data__name
      value: string
    - name: endpoint
      value: string
    - name: name
      value: string
    - name: comment
      value: string
    - name: admin_name
      value: string
    - name: admin_password
      value: string
    - name: account_type
      value: string

DELETE example

Deletes the specified managed_accounts resource.

/*+ delete */
DELETE FROM snowflake.managed_account.managed_accounts
WHERE name = '{{ name }}'
AND endpoint = '{{ endpoint }}';