1. Packages
  2. Snowflake Provider
  3. API Docs
  4. getAccountRoles
Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

snowflake.getAccountRoles

Explore with Pulumi AI

Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

Data source used to get details of filtered account roles. Filtering is aligned with the current possibilities for SHOW ROLES query (like and in_class are all supported). The results of SHOW are encapsulated in one output collection.

Using getAccountRoles

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 getAccountRoles(args: GetAccountRolesArgs, opts?: InvokeOptions): Promise<GetAccountRolesResult>
function getAccountRolesOutput(args: GetAccountRolesOutputArgs, opts?: InvokeOptions): Output<GetAccountRolesResult>
Copy
def get_account_roles(in_class: Optional[str] = None,
                      like: Optional[str] = None,
                      opts: Optional[InvokeOptions] = None) -> GetAccountRolesResult
def get_account_roles_output(in_class: Optional[pulumi.Input[str]] = None,
                      like: Optional[pulumi.Input[str]] = None,
                      opts: Optional[InvokeOptions] = None) -> Output[GetAccountRolesResult]
Copy
func GetAccountRoles(ctx *Context, args *GetAccountRolesArgs, opts ...InvokeOption) (*GetAccountRolesResult, error)
func GetAccountRolesOutput(ctx *Context, args *GetAccountRolesOutputArgs, opts ...InvokeOption) GetAccountRolesResultOutput
Copy

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

public static class GetAccountRoles 
{
    public static Task<GetAccountRolesResult> InvokeAsync(GetAccountRolesArgs args, InvokeOptions? opts = null)
    public static Output<GetAccountRolesResult> Invoke(GetAccountRolesInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetAccountRolesResult> getAccountRoles(GetAccountRolesArgs args, InvokeOptions options)
public static Output<GetAccountRolesResult> getAccountRoles(GetAccountRolesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: snowflake:index/getAccountRoles:getAccountRoles
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

InClass string
Filters the SHOW GRANTS output by class name.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
InClass string
Filters the SHOW GRANTS output by class name.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
inClass String
Filters the SHOW GRANTS output by class name.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
inClass string
Filters the SHOW GRANTS output by class name.
like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
in_class str
Filters the SHOW GRANTS output by class name.
like str
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
inClass String
Filters the SHOW GRANTS output by class name.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).

getAccountRoles Result

The following output properties are available:

AccountRoles List<GetAccountRolesAccountRole>
Holds the aggregated output of all account role details queries.
Id string
The provider-assigned unique ID for this managed resource.
InClass string
Filters the SHOW GRANTS output by class name.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
AccountRoles []GetAccountRolesAccountRole
Holds the aggregated output of all account role details queries.
Id string
The provider-assigned unique ID for this managed resource.
InClass string
Filters the SHOW GRANTS output by class name.
Like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
accountRoles List<GetAccountRolesAccountRole>
Holds the aggregated output of all account role details queries.
id String
The provider-assigned unique ID for this managed resource.
inClass String
Filters the SHOW GRANTS output by class name.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
accountRoles GetAccountRolesAccountRole[]
Holds the aggregated output of all account role details queries.
id string
The provider-assigned unique ID for this managed resource.
inClass string
Filters the SHOW GRANTS output by class name.
like string
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
account_roles Sequence[GetAccountRolesAccountRole]
Holds the aggregated output of all account role details queries.
id str
The provider-assigned unique ID for this managed resource.
in_class str
Filters the SHOW GRANTS output by class name.
like str
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
accountRoles List<Property Map>
Holds the aggregated output of all account role details queries.
id String
The provider-assigned unique ID for this managed resource.
inClass String
Filters the SHOW GRANTS output by class name.
like String
Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).

Supporting Types

GetAccountRolesAccountRole

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

GetAccountRolesAccountRoleShowOutput

AssignedToUsers This property is required. int
Comment This property is required. string
CreatedOn This property is required. string
GrantedRoles This property is required. int
GrantedToRoles This property is required. int
IsCurrent This property is required. bool
IsDefault This property is required. bool
IsInherited This property is required. bool
Name This property is required. string
Owner This property is required. string
AssignedToUsers This property is required. int
Comment This property is required. string
CreatedOn This property is required. string
GrantedRoles This property is required. int
GrantedToRoles This property is required. int
IsCurrent This property is required. bool
IsDefault This property is required. bool
IsInherited This property is required. bool
Name This property is required. string
Owner This property is required. string
assignedToUsers This property is required. Integer
comment This property is required. String
createdOn This property is required. String
grantedRoles This property is required. Integer
grantedToRoles This property is required. Integer
isCurrent This property is required. Boolean
isDefault This property is required. Boolean
isInherited This property is required. Boolean
name This property is required. String
owner This property is required. String
assignedToUsers This property is required. number
comment This property is required. string
createdOn This property is required. string
grantedRoles This property is required. number
grantedToRoles This property is required. number
isCurrent This property is required. boolean
isDefault This property is required. boolean
isInherited This property is required. boolean
name This property is required. string
owner This property is required. string
assigned_to_users This property is required. int
comment This property is required. str
created_on This property is required. str
granted_roles This property is required. int
granted_to_roles This property is required. int
is_current This property is required. bool
is_default This property is required. bool
is_inherited This property is required. bool
name This property is required. str
owner This property is required. str
assignedToUsers This property is required. Number
comment This property is required. String
createdOn This property is required. String
grantedRoles This property is required. Number
grantedToRoles This property is required. Number
isCurrent This property is required. Boolean
isDefault This property is required. Boolean
isInherited This property is required. Boolean
name This property is required. String
owner 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.2.0 published on Monday, Apr 14, 2025 by Pulumi