snowflake.core.managed_account.ManagedAccountCollection¶

class snowflake.core.managed_account.ManagedAccountCollection(root: Root)¶

Bases: AccountObjectCollectionParent[ManagedAccountResource]

Represents the collection operations of the Snowflake ManagedAccount resource.

With this collection, you can create, iterate through, and search for managed accounts that you have access to in the current context.

Examples

Creating a managed account instance:

>>> managed_account_collection = root.managed_accounts
>>> managed_account = ManagedAccount(
...     name="managed_account_name",
...     admin_name = "admin"
...     admin_password = 'TestPassword1'
...     account_type = "READER"
...  )
>>> managed_account_collection.create(managed_account)

Attributes

root¶

Methods

create(managed_account: ManagedAccountModel) → ManagedAccountResource¶

Create a managed account in Snowflake.

Parameters:: managed_account (ManagedAccount)

Examples

Creating a managed account instance and getting reference to it:

>>> managed_account_parameters = ManagedAccount(
...     name="managed_account_name",
...     admin_name = "admin"
...     admin_password = 'TestPassword1'
...     account_type = "READER"
...  )
>>> # Use the managed account collection created before to create a reference to a managed account resource
>>> # in Snowflake.
>>> managed_account_reference = managed_account_collection.create(managed_account_parameters)

items() → ItemsView[str, T]¶

iter(*, like: str | None = None) → Iterator[ManagedAccountModel]¶

Iterate through ManagedAccount objects in Snowflake, filtering on any optional like pattern.

Parameters:: like (str, optional) – A case-insensitive string functioning as a filter, with support for SQL wildcard characters (% and _).

Examples

Showing all managed accounts that you have access to see:

>>> managed_accounts = managed_account_collection.iter()

Showing information of the exact managed account you want to see:

>>> managed_accounts = managed_account_collection.iter(like="your-managed-account-name")

Showing managed accounts starting with ‘your-managed-account-name-‘:

>>> managed_accounts = managed_account_collection.iter(like="your-managed-account-name-%")

Using a for loop to retrieve information from iterator:

>>> for managed_account in managed_accounts:
>>>     print(managed_account.name, managed_account.comment)

keys() → KeysView[str]¶

values() → ValuesView[T]¶