1. Packages
  2. Snowflake Provider
  3. API Docs
  4. getAccountRoles
Snowflake v1.1.0 published on Monday, Jan 13, 2025 by Pulumi

snowflake.getAccountRoles

Explore with Pulumi AI

snowflake logo
Snowflake v1.1.0 published on Monday, Jan 13, 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>
    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]
    func GetAccountRoles(ctx *Context, args *GetAccountRolesArgs, opts ...InvokeOption) (*GetAccountRolesResult, error)
    func GetAccountRolesOutput(ctx *Context, args *GetAccountRolesOutputArgs, opts ...InvokeOption) GetAccountRolesResultOutput

    > 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)
    }
    public static CompletableFuture<GetAccountRolesResult> getAccountRoles(GetAccountRolesArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: snowflake:index/getAccountRoles:getAccountRoles
      arguments:
        # arguments dictionary

    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 List<Property Map>
    Holds the output of SHOW ROLES.

    GetAccountRolesAccountRoleShowOutput

    assignedToUsers Integer
    comment String
    createdOn String
    grantedRoles Integer
    grantedToRoles Integer
    isCurrent Boolean
    isDefault Boolean
    isInherited Boolean
    name String
    owner String
    assignedToUsers number
    comment string
    createdOn string
    grantedRoles number
    grantedToRoles number
    isCurrent boolean
    isDefault boolean
    isInherited boolean
    name string
    owner string
    assignedToUsers Number
    comment String
    createdOn String
    grantedRoles Number
    grantedToRoles Number
    isCurrent Boolean
    isDefault Boolean
    isInherited Boolean
    name String
    owner String

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v1.1.0 published on Monday, Jan 13, 2025 by Pulumi