Snowflake v1.1.2 published on Thursday, Feb 6, 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 List<GetAccounts Account Show Output> - Holds the output of SHOW ACCOUNTS.
- Show
Outputs []GetAccounts Account Show Output - Holds the output of SHOW ACCOUNTS.
- show
Outputs List<GetAccounts Account Show Output> - Holds the output of SHOW ACCOUNTS.
- show
Outputs GetAccounts Account Show Output[] - Holds the output of SHOW ACCOUNTS.
- show_
outputs Sequence[GetAccounts Account Show Output] - Holds the output of SHOW ACCOUNTS.
- show
Outputs List<Property Map> - Holds the output of SHOW ACCOUNTS.
GetAccountsAccountShowOutput
- Account
Locator string - Account
Locator stringUrl - Account
Name string - Account
Old stringUrl Last Used - Account
Old stringUrl Saved On - Account
Url string - Comment string
- Consumption
Billing stringEntity Name - Created
On string - Dropped
On string - Edition string
- Is
Events boolAccount - Is
Org boolAdmin - Is
Organization boolAccount - Managed
Accounts int - Marketplace
Consumer stringBilling Entity Name - Marketplace
Provider stringBilling Entity Name - Moved
On string - Moved
To stringOrganization - Old
Account stringUrl - Organization
Name string - Organization
Old stringUrl - Organization
Old stringUrl Last Used - Organization
Old stringUrl Saved On - Organization
Url stringExpiration On - Region
Group string - Restored
On string - Scheduled
Deletion stringTime - Snowflake
Region string
- Account
Locator string - Account
Locator stringUrl - Account
Name string - Account
Old stringUrl Last Used - Account
Old stringUrl Saved On - Account
Url string - Comment string
- Consumption
Billing stringEntity Name - Created
On string - Dropped
On string - Edition string
- Is
Events boolAccount - Is
Org boolAdmin - Is
Organization boolAccount - Managed
Accounts int - Marketplace
Consumer stringBilling Entity Name - Marketplace
Provider stringBilling Entity Name - Moved
On string - Moved
To stringOrganization - Old
Account stringUrl - Organization
Name string - Organization
Old stringUrl - Organization
Old stringUrl Last Used - Organization
Old stringUrl Saved On - Organization
Url stringExpiration On - Region
Group string - Restored
On string - Scheduled
Deletion stringTime - Snowflake
Region string
- account
Locator String - account
Locator StringUrl - account
Name String - account
Old StringUrl Last Used - account
Old StringUrl Saved On - account
Url String - comment String
- consumption
Billing StringEntity Name - created
On String - dropped
On String - edition String
- is
Events BooleanAccount - is
Org BooleanAdmin - is
Organization BooleanAccount - managed
Accounts Integer - marketplace
Consumer StringBilling Entity Name - marketplace
Provider StringBilling Entity Name - moved
On String - moved
To StringOrganization - old
Account StringUrl - organization
Name String - organization
Old StringUrl - organization
Old StringUrl Last Used - organization
Old StringUrl Saved On - organization
Url StringExpiration On - region
Group String - restored
On String - scheduled
Deletion StringTime - snowflake
Region String
- account
Locator string - account
Locator stringUrl - account
Name string - account
Old stringUrl Last Used - account
Old stringUrl Saved On - account
Url string - comment string
- consumption
Billing stringEntity Name - created
On string - dropped
On string - edition string
- is
Events booleanAccount - is
Org booleanAdmin - is
Organization booleanAccount - managed
Accounts number - marketplace
Consumer stringBilling Entity Name - marketplace
Provider stringBilling Entity Name - moved
On string - moved
To stringOrganization - old
Account stringUrl - organization
Name string - organization
Old stringUrl - organization
Old stringUrl Last Used - organization
Old stringUrl Saved On - organization
Url stringExpiration On - region
Group string - restored
On string - scheduled
Deletion stringTime - snowflake
Region string
- account_
locator str - account_
locator_ strurl - account_
name str - account_
old_ strurl_ last_ used - account_
old_ strurl_ saved_ on - account_
url str - comment str
- consumption_
billing_ strentity_ name - created_
on str - dropped_
on str - edition str
- is_
events_ boolaccount - is_
org_ booladmin - is_
organization_ boolaccount - managed_
accounts int - marketplace_
consumer_ strbilling_ entity_ name - marketplace_
provider_ strbilling_ entity_ name - moved_
on str - moved_
to_ strorganization - old_
account_ strurl - organization_
name str - organization_
old_ strurl - organization_
old_ strurl_ last_ used - organization_
old_ strurl_ saved_ on - organization_
url_ strexpiration_ on - region_
group str - restored_
on str - scheduled_
deletion_ strtime - snowflake_
region str
- account
Locator String - account
Locator StringUrl - account
Name String - account
Old StringUrl Last Used - account
Old StringUrl Saved On - account
Url String - comment String
- consumption
Billing StringEntity Name - created
On String - dropped
On String - edition String
- is
Events BooleanAccount - is
Org BooleanAdmin - is
Organization BooleanAccount - managed
Accounts Number - marketplace
Consumer StringBilling Entity Name - marketplace
Provider StringBilling Entity Name - moved
On String - moved
To StringOrganization - old
Account StringUrl - organization
Name String - organization
Old StringUrl - organization
Old StringUrl Last Used - organization
Old StringUrl Saved On - organization
Url StringExpiration On - region
Group String - restored
On String - scheduled
Deletion StringTime - snowflake
Region String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.