1. Packages
  2. Snowflake Provider
  3. API Docs
  4. getAccounts
Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

snowflake.getAccounts

Explore with Pulumi AI

Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

Data source used to get details of filtered accounts. Filtering is aligned with the current possibilities for SHOW ACCOUNTS query. The results of SHOW are encapsulated in one output collection accounts.

Using getAccounts

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getAccounts(args: GetAccountsArgs, opts?: InvokeOptions): Promise<GetAccountsResult>
function getAccountsOutput(args: GetAccountsOutputArgs, opts?: InvokeOptions): Output<GetAccountsResult>
Copy
def get_accounts(like: Optional[str] = None,
                 with_history: Optional[bool] = None,
                 opts: Optional[InvokeOptions] = None) -> GetAccountsResult
def get_accounts_output(like: Optional[pulumi.Input[str]] = None,
                 with_history: Optional[pulumi.Input[bool]] = None,
                 opts: Optional[InvokeOptions] = None) -> Output[GetAccountsResult]
Copy
func GetAccounts(ctx *Context, args *GetAccountsArgs, opts ...InvokeOption) (*GetAccountsResult, error)
func GetAccountsOutput(ctx *Context, args *GetAccountsOutputArgs, opts ...InvokeOption) GetAccountsResultOutput
Copy

> Note: This function is named GetAccounts in the Go SDK.

public static class GetAccounts 
{
    public static Task<GetAccountsResult> InvokeAsync(GetAccountsArgs args, InvokeOptions? opts = null)
    public static Output<GetAccountsResult> Invoke(GetAccountsInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetAccountsResult> getAccounts(GetAccountsArgs args, InvokeOptions options)
public static Output<GetAccountsResult> getAccounts(GetAccountsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: snowflake:index/getAccounts:getAccounts
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
WithHistory bool
Includes dropped accounts that have not yet been deleted.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
WithHistory bool
Includes dropped accounts that have not yet been deleted.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory Boolean
Includes dropped accounts that have not yet been deleted.
like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory boolean
Includes dropped accounts that have not yet been deleted.
like str
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
with_history bool
Includes dropped accounts that have not yet been deleted.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory Boolean
Includes dropped accounts that have not yet been deleted.

getAccounts Result

The following output properties are available:

Accounts List<GetAccountsAccount>
Holds the aggregated output of all accounts details queries.
Id string
The provider-assigned unique ID for this managed resource.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
WithHistory bool
Includes dropped accounts that have not yet been deleted.
Accounts []GetAccountsAccount
Holds the aggregated output of all accounts details queries.
Id string
The provider-assigned unique ID for this managed resource.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
WithHistory bool
Includes dropped accounts that have not yet been deleted.
accounts List<GetAccountsAccount>
Holds the aggregated output of all accounts details queries.
id String
The provider-assigned unique ID for this managed resource.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory Boolean
Includes dropped accounts that have not yet been deleted.
accounts GetAccountsAccount[]
Holds the aggregated output of all accounts details queries.
id string
The provider-assigned unique ID for this managed resource.
like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory boolean
Includes dropped accounts that have not yet been deleted.
accounts Sequence[GetAccountsAccount]
Holds the aggregated output of all accounts details queries.
id str
The provider-assigned unique ID for this managed resource.
like str
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
with_history bool
Includes dropped accounts that have not yet been deleted.
accounts List<Property Map>
Holds the aggregated output of all accounts details queries.
id String
The provider-assigned unique ID for this managed resource.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
withHistory Boolean
Includes dropped accounts that have not yet been deleted.

Supporting Types

GetAccountsAccount

ShowOutputs This property is required. List<GetAccountsAccountShowOutput>
Holds the output of SHOW ACCOUNTS.
ShowOutputs This property is required. []GetAccountsAccountShowOutput
Holds the output of SHOW ACCOUNTS.
showOutputs This property is required. List<GetAccountsAccountShowOutput>
Holds the output of SHOW ACCOUNTS.
showOutputs This property is required. GetAccountsAccountShowOutput[]
Holds the output of SHOW ACCOUNTS.
show_outputs This property is required. Sequence[GetAccountsAccountShowOutput]
Holds the output of SHOW ACCOUNTS.
showOutputs This property is required. List<Property Map>
Holds the output of SHOW ACCOUNTS.

GetAccountsAccountShowOutput

AccountLocator This property is required. string
AccountLocatorUrl This property is required. string
AccountName This property is required. string
AccountOldUrlLastUsed This property is required. string
AccountOldUrlSavedOn This property is required. string
AccountUrl This property is required. string
Comment This property is required. string
ConsumptionBillingEntityName This property is required. string
CreatedOn This property is required. string
DroppedOn This property is required. string
Edition This property is required. string
IsEventsAccount This property is required. bool
IsOrgAdmin This property is required. bool
IsOrganizationAccount This property is required. bool
ManagedAccounts This property is required. int
MarketplaceConsumerBillingEntityName This property is required. string
MarketplaceProviderBillingEntityName This property is required. string
MovedOn This property is required. string
MovedToOrganization This property is required. string
OldAccountUrl This property is required. string
OrganizationName This property is required. string
OrganizationOldUrl This property is required. string
OrganizationOldUrlLastUsed This property is required. string
OrganizationOldUrlSavedOn This property is required. string
OrganizationUrlExpirationOn This property is required. string
RegionGroup This property is required. string
RestoredOn This property is required. string
ScheduledDeletionTime This property is required. string
SnowflakeRegion This property is required. string
AccountLocator This property is required. string
AccountLocatorUrl This property is required. string
AccountName This property is required. string
AccountOldUrlLastUsed This property is required. string
AccountOldUrlSavedOn This property is required. string
AccountUrl This property is required. string
Comment This property is required. string
ConsumptionBillingEntityName This property is required. string
CreatedOn This property is required. string
DroppedOn This property is required. string
Edition This property is required. string
IsEventsAccount This property is required. bool
IsOrgAdmin This property is required. bool
IsOrganizationAccount This property is required. bool
ManagedAccounts This property is required. int
MarketplaceConsumerBillingEntityName This property is required. string
MarketplaceProviderBillingEntityName This property is required. string
MovedOn This property is required. string
MovedToOrganization This property is required. string
OldAccountUrl This property is required. string
OrganizationName This property is required. string
OrganizationOldUrl This property is required. string
OrganizationOldUrlLastUsed This property is required. string
OrganizationOldUrlSavedOn This property is required. string
OrganizationUrlExpirationOn This property is required. string
RegionGroup This property is required. string
RestoredOn This property is required. string
ScheduledDeletionTime This property is required. string
SnowflakeRegion This property is required. string
accountLocator This property is required. String
accountLocatorUrl This property is required. String
accountName This property is required. String
accountOldUrlLastUsed This property is required. String
accountOldUrlSavedOn This property is required. String
accountUrl This property is required. String
comment This property is required. String
consumptionBillingEntityName This property is required. String
createdOn This property is required. String
droppedOn This property is required. String
edition This property is required. String
isEventsAccount This property is required. Boolean
isOrgAdmin This property is required. Boolean
isOrganizationAccount This property is required. Boolean
managedAccounts This property is required. Integer
marketplaceConsumerBillingEntityName This property is required. String
marketplaceProviderBillingEntityName This property is required. String
movedOn This property is required. String
movedToOrganization This property is required. String
oldAccountUrl This property is required. String
organizationName This property is required. String
organizationOldUrl This property is required. String
organizationOldUrlLastUsed This property is required. String
organizationOldUrlSavedOn This property is required. String
organizationUrlExpirationOn This property is required. String
regionGroup This property is required. String
restoredOn This property is required. String
scheduledDeletionTime This property is required. String
snowflakeRegion This property is required. String
accountLocator This property is required. string
accountLocatorUrl This property is required. string
accountName This property is required. string
accountOldUrlLastUsed This property is required. string
accountOldUrlSavedOn This property is required. string
accountUrl This property is required. string
comment This property is required. string
consumptionBillingEntityName This property is required. string
createdOn This property is required. string
droppedOn This property is required. string
edition This property is required. string
isEventsAccount This property is required. boolean
isOrgAdmin This property is required. boolean
isOrganizationAccount This property is required. boolean
managedAccounts This property is required. number
marketplaceConsumerBillingEntityName This property is required. string
marketplaceProviderBillingEntityName This property is required. string
movedOn This property is required. string
movedToOrganization This property is required. string
oldAccountUrl This property is required. string
organizationName This property is required. string
organizationOldUrl This property is required. string
organizationOldUrlLastUsed This property is required. string
organizationOldUrlSavedOn This property is required. string
organizationUrlExpirationOn This property is required. string
regionGroup This property is required. string
restoredOn This property is required. string
scheduledDeletionTime This property is required. string
snowflakeRegion This property is required. string
account_locator This property is required. str
account_locator_url This property is required. str
account_name This property is required. str
account_old_url_last_used This property is required. str
account_old_url_saved_on This property is required. str
account_url This property is required. str
comment This property is required. str
consumption_billing_entity_name This property is required. str
created_on This property is required. str
dropped_on This property is required. str
edition This property is required. str
is_events_account This property is required. bool
is_org_admin This property is required. bool
is_organization_account This property is required. bool
managed_accounts This property is required. int
marketplace_consumer_billing_entity_name This property is required. str
marketplace_provider_billing_entity_name This property is required. str
moved_on This property is required. str
moved_to_organization This property is required. str
old_account_url This property is required. str
organization_name This property is required. str
organization_old_url This property is required. str
organization_old_url_last_used This property is required. str
organization_old_url_saved_on This property is required. str
organization_url_expiration_on This property is required. str
region_group This property is required. str
restored_on This property is required. str
scheduled_deletion_time This property is required. str
snowflake_region This property is required. str
accountLocator This property is required. String
accountLocatorUrl This property is required. String
accountName This property is required. String
accountOldUrlLastUsed This property is required. String
accountOldUrlSavedOn This property is required. String
accountUrl This property is required. String
comment This property is required. String
consumptionBillingEntityName This property is required. String
createdOn This property is required. String
droppedOn This property is required. String
edition This property is required. String
isEventsAccount This property is required. Boolean
isOrgAdmin This property is required. Boolean
isOrganizationAccount This property is required. Boolean
managedAccounts This property is required. Number
marketplaceConsumerBillingEntityName This property is required. String
marketplaceProviderBillingEntityName This property is required. String
movedOn This property is required. String
movedToOrganization This property is required. String
oldAccountUrl This property is required. String
organizationName This property is required. String
organizationOldUrl This property is required. String
organizationOldUrlLastUsed This property is required. String
organizationOldUrlSavedOn This property is required. String
organizationUrlExpirationOn This property is required. String
regionGroup This property is required. String
restoredOn This property is required. String
scheduledDeletionTime This property is required. String
snowflakeRegion This property is required. String

Package Details

Repository
Snowflake pulumi/pulumi-snowflake
License
Apache-2.0
Notes
This Pulumi package is based on the snowflake Terraform Provider.
Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi