Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi
snowflake.getAccounts
Explore with Pulumi AI
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>
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]
func GetAccounts(ctx *Context, args *GetAccountsArgs, opts ...InvokeOption) (*GetAccountsResult, error)
func GetAccountsOutput(ctx *Context, args *GetAccountsOutputArgs, opts ...InvokeOption) GetAccountsResultOutput
> 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)
}
public static CompletableFuture<GetAccountsResult> getAccounts(GetAccountsArgs args, InvokeOptions options)
public static Output<GetAccountsResult> getAccounts(GetAccountsArgs args, InvokeOptions options)
fn::invoke:
function: snowflake:index/getAccounts:getAccounts
arguments:
# arguments dictionary
The following arguments are supported:
- Like string
- 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_
). - 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_
). - with
History 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_
). - with
History 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_
). - with
History Boolean - Includes dropped accounts that have not yet been deleted.
getAccounts Result
The following output properties are available:
- Accounts
List<Get
Accounts Account> - 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_
). - With
History bool - Includes dropped accounts that have not yet been deleted.
- Accounts
[]Get
Accounts Account - 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_
). - With
History bool - Includes dropped accounts that have not yet been deleted.
- accounts
List<Get
Accounts Account> - 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_
). - with
History Boolean - Includes dropped accounts that have not yet been deleted.
- accounts
Get
Accounts Account[] - 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_
). - with
History boolean - Includes dropped accounts that have not yet been deleted.
- accounts
Sequence[Get
Accounts Account] - 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_
). - with
History Boolean - Includes dropped accounts that have not yet been deleted.
Supporting Types
GetAccountsAccount
- Show
Outputs This property is required. List<GetAccounts Account Show Output> - Holds the output of SHOW ACCOUNTS.
- Show
Outputs This property is required. []GetAccounts Account Show Output - Holds the output of SHOW ACCOUNTS.
- show
Outputs This property is required. List<GetAccounts Account Show Output> - Holds the output of SHOW ACCOUNTS.
- show
Outputs This property is required. GetAccounts Account Show Output[] - Holds the output of SHOW ACCOUNTS.
- show_
outputs This property is required. Sequence[GetAccounts Account Show Output] - Holds the output of SHOW ACCOUNTS.
- show
Outputs This property is required. List<Property Map> - Holds the output of SHOW ACCOUNTS.
GetAccountsAccountShowOutput
- Account
Locator This property is required. string - Account
Locator Url This property is required. string - Account
Name This property is required. string - Account
Old Url Last Used This property is required. string - Account
Old Url Saved On This property is required. string - Account
Url This property is required. string - Comment
This property is required. string - Consumption
Billing Entity Name This property is required. string - Created
On This property is required. string - Dropped
On This property is required. string - Edition
This property is required. string - 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. string - Marketplace
Provider Billing Entity Name This property is required. string - Moved
On This property is required. string - Moved
To Organization This property is required. string - Old
Account Url This property is required. string - Organization
Name This property is required. string - Organization
Old Url This property is required. string - Organization
Old Url Last Used This property is required. string - Organization
Old Url Saved On This property is required. string - Organization
Url Expiration On This property is required. string - Region
Group This property is required. string - Restored
On This property is required. string - Scheduled
Deletion Time This property is required. string - Snowflake
Region This property is required. string
- Account
Locator This property is required. string - Account
Locator Url This property is required. string - Account
Name This property is required. string - Account
Old Url Last Used This property is required. string - Account
Old Url Saved On This property is required. string - Account
Url This property is required. string - Comment
This property is required. string - Consumption
Billing Entity Name This property is required. string - Created
On This property is required. string - Dropped
On This property is required. string - Edition
This property is required. string - 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. string - Marketplace
Provider Billing Entity Name This property is required. string - Moved
On This property is required. string - Moved
To Organization This property is required. string - Old
Account Url This property is required. string - Organization
Name This property is required. string - Organization
Old Url This property is required. string - Organization
Old Url Last Used This property is required. string - Organization
Old Url Saved On This property is required. string - Organization
Url Expiration On This property is required. string - Region
Group This property is required. string - Restored
On This property is required. string - Scheduled
Deletion Time This property is required. string - Snowflake
Region This property is required. string
- account
Locator This property is required. String - account
Locator Url This property is required. String - account
Name This property is required. String - account
Old Url Last Used This property is required. String - account
Old Url Saved On This property is required. String - account
Url This property is required. String - comment
This property is required. String - consumption
Billing Entity Name This property is required. String - created
On This property is required. String - dropped
On This property is required. String - edition
This property is required. String - is
Events Account This property is required. Boolean - is
Org Admin This property is required. Boolean - is
Organization Account This property is required. Boolean - managed
Accounts This property is required. Integer - marketplace
Consumer Billing Entity Name This property is required. String - marketplace
Provider Billing Entity Name This property is required. String - moved
On This property is required. String - moved
To Organization This property is required. String - old
Account Url This property is required. String - organization
Name This property is required. String - organization
Old Url This property is required. String - organization
Old Url Last Used This property is required. String - organization
Old Url Saved On This property is required. String - organization
Url Expiration On This property is required. String - region
Group This property is required. String - restored
On This property is required. String - scheduled
Deletion Time This property is required. String - snowflake
Region This property is required. String
- account
Locator This property is required. string - account
Locator Url This property is required. string - account
Name This property is required. string - account
Old Url Last Used This property is required. string - account
Old Url Saved On This property is required. string - account
Url This property is required. string - comment
This property is required. string - consumption
Billing Entity Name This property is required. string - created
On This property is required. string - dropped
On This property is required. string - edition
This property is required. string - is
Events Account This property is required. boolean - is
Org Admin This property is required. boolean - is
Organization Account This property is required. boolean - managed
Accounts This property is required. number - marketplace
Consumer Billing Entity Name This property is required. string - marketplace
Provider Billing Entity Name This property is required. string - moved
On This property is required. string - moved
To Organization This property is required. string - old
Account Url This property is required. string - organization
Name This property is required. string - organization
Old Url This property is required. string - organization
Old Url Last Used This property is required. string - organization
Old Url Saved On This property is required. string - organization
Url Expiration On This property is required. string - region
Group This property is required. string - restored
On This property is required. string - scheduled
Deletion Time This property is required. string - snowflake
Region 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
- account
Locator This property is required. String - account
Locator Url This property is required. String - account
Name This property is required. String - account
Old Url Last Used This property is required. String - account
Old Url Saved On This property is required. String - account
Url This property is required. String - comment
This property is required. String - consumption
Billing Entity Name This property is required. String - created
On This property is required. String - dropped
On This property is required. String - edition
This property is required. String - is
Events Account This property is required. Boolean - is
Org Admin This property is required. Boolean - is
Organization Account This property is required. Boolean - managed
Accounts This property is required. Number - marketplace
Consumer Billing Entity Name This property is required. String - marketplace
Provider Billing Entity Name This property is required. String - moved
On This property is required. String - moved
To Organization This property is required. String - old
Account Url This property is required. String - organization
Name This property is required. String - organization
Old Url This property is required. String - organization
Old Url Last Used This property is required. String - organization
Old Url Saved On This property is required. String - organization
Url Expiration On This property is required. String - region
Group This property is required. String - restored
On This property is required. String - scheduled
Deletion Time This property is required. String - snowflake
Region 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.