Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. AccountSessionPolicyAttachment
Viewing docs for Snowflake v2.22.0
published on Wednesday, Oct 14, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.AccountSessionPolicyAttachment

snowflake logo
Viewing docs for Snowflake v2.22.0
published on Wednesday, Oct 14, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

    Warning This resource shouldn’t be used with snowflake.CurrentAccount resource in the same configuration, as it may lead to unexpected behavior.

    Specifies the session policy to use for the current account. To set the session policy of a different account, use a provider alias.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";

const sp = new snowflake.SessionPolicy("sp", {
    database: "prod",
    schema: "security",
    name: "default_session_policy",
});
// Attach the session policy account-wide (default behavior).
const attachment = new snowflake.AccountSessionPolicyAttachment("attachment", {sessionPolicyName: sp.fullyQualifiedName});
const serviceUsers = new snowflake.SessionPolicy("service_users", {
    database: "prod",
    schema: "security",
    name: "service_users_session_policy",
});
// Attach the session policy to all service users only.
// Use for_all_person_users = true to target all person users instead.
// The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
const attachmentServiceUsers = new snowflake.AccountSessionPolicyAttachment("attachment_service_users", {
    sessionPolicyName: serviceUsers.fullyQualifiedName,
    forAllServiceUsers: true,
});

    import pulumi
import pulumi_snowflake as snowflake

sp = snowflake.SessionPolicy("sp",
    database="prod",
    schema="security",
    name="default_session_policy")
# Attach the session policy account-wide (default behavior).
attachment = snowflake.AccountSessionPolicyAttachment("attachment", session_policy_name=sp.fully_qualified_name)
service_users = snowflake.SessionPolicy("service_users",
    database="prod",
    schema="security",
    name="service_users_session_policy")
# Attach the session policy to all service users only.
# Use for_all_person_users = true to target all person users instead.
# The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
attachment_service_users = snowflake.AccountSessionPolicyAttachment("attachment_service_users",
    session_policy_name=service_users.fully_qualified_name,
    for_all_service_users=True)

    package main

import (
	"github.com/pulumi/pulumi-snowflake/sdk/v2/go/snowflake"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		sp, err := snowflake.NewSessionPolicy(ctx, "sp", &snowflake.SessionPolicyArgs{
			Database: pulumi.String("prod"),
			Schema:   pulumi.String("security"),
			Name:     pulumi.String("default_session_policy"),
		})
		if err != nil {
			return err
		}
		// Attach the session policy account-wide (default behavior).
		_, err = snowflake.NewAccountSessionPolicyAttachment(ctx, "attachment", &snowflake.AccountSessionPolicyAttachmentArgs{
			SessionPolicyName: sp.FullyQualifiedName,
		})
		if err != nil {
			return err
		}
		serviceUsers, err := snowflake.NewSessionPolicy(ctx, "service_users", &snowflake.SessionPolicyArgs{
			Database: pulumi.String("prod"),
			Schema:   pulumi.String("security"),
			Name:     pulumi.String("service_users_session_policy"),
		})
		if err != nil {
			return err
		}
		// Attach the session policy to all service users only.
		// Use for_all_person_users = true to target all person users instead.
		// The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
		_, err = snowflake.NewAccountSessionPolicyAttachment(ctx, "attachment_service_users", &snowflake.AccountSessionPolicyAttachmentArgs{
			SessionPolicyName:  serviceUsers.FullyQualifiedName,
			ForAllServiceUsers: pulumi.Bool(true),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Snowflake = Pulumi.Snowflake;

return await Deployment.RunAsync(() => 
{
    var sp = new Snowflake.SessionPolicy("sp", new()
    {
        Database = "prod",
        Schema = "security",
        Name = "default_session_policy",
    });

    // Attach the session policy account-wide (default behavior).
    var attachment = new Snowflake.AccountSessionPolicyAttachment("attachment", new()
    {
        SessionPolicyName = sp.FullyQualifiedName,
    });

    var serviceUsers = new Snowflake.SessionPolicy("service_users", new()
    {
        Database = "prod",
        Schema = "security",
        Name = "service_users_session_policy",
    });

    // Attach the session policy to all service users only.
    // Use for_all_person_users = true to target all person users instead.
    // The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
    var attachmentServiceUsers = new Snowflake.AccountSessionPolicyAttachment("attachment_service_users", new()
    {
        SessionPolicyName = serviceUsers.FullyQualifiedName,
        ForAllServiceUsers = true,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.SessionPolicy;
import com.pulumi.snowflake.SessionPolicyArgs;
import com.pulumi.snowflake.AccountSessionPolicyAttachment;
import com.pulumi.snowflake.AccountSessionPolicyAttachmentArgs;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sp = new SessionPolicy("sp", SessionPolicyArgs.builder()
            .database("prod")
            .schema("security")
            .name("default_session_policy")
            .build());

        // Attach the session policy account-wide (default behavior).
        var attachment = new AccountSessionPolicyAttachment("attachment", AccountSessionPolicyAttachmentArgs.builder()
            .sessionPolicyName(sp.fullyQualifiedName())
            .build());

        var serviceUsers = new SessionPolicy("serviceUsers", SessionPolicyArgs.builder()
            .database("prod")
            .schema("security")
            .name("service_users_session_policy")
            .build());

        // Attach the session policy to all service users only.
        // Use for_all_person_users = true to target all person users instead.
        // The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
        var attachmentServiceUsers = new AccountSessionPolicyAttachment("attachmentServiceUsers", AccountSessionPolicyAttachmentArgs.builder()
            .sessionPolicyName(serviceUsers.fullyQualifiedName())
            .forAllServiceUsers(true)
            .build());

    }
}

    resources:
  sp:
    type: snowflake:SessionPolicy
    properties:
      database: prod
      schema: security
      name: default_session_policy
  # Attach the session policy account-wide (default behavior).
  attachment:
    type: snowflake:AccountSessionPolicyAttachment
    properties:
      sessionPolicyName: ${sp.fullyQualifiedName}
  serviceUsers:
    type: snowflake:SessionPolicy
    name: service_users
    properties:
      database: prod
      schema: security
      name: service_users_session_policy
  # Attach the session policy to all service users only.
  # Use for_all_person_users = true to target all person users instead.
  # The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
  attachmentServiceUsers:
    type: snowflake:AccountSessionPolicyAttachment
    name: attachment_service_users
    properties:
      sessionPolicyName: ${serviceUsers.fullyQualifiedName}
      forAllServiceUsers: true

    terraform {
  required_providers {
    snowflake = {
      source = "pulumi/snowflake"
    }
  }
}

resource "snowflake_session_policy" "sp" {
  lifecycle {
    create_before_destroy = true
  }
  database = "prod"
  schema   = "security"
  name     = "default_session_policy"
}
# Attach the session policy account-wide (default behavior).
resource "snowflake_account_session_policy_attachment" "attachment" {
  lifecycle {
    create_before_destroy = true
  }
  session_policy_name = snowflake_session_policy.sp.fully_qualified_name
}
resource "snowflake_session_policy" "service_users" {
  lifecycle {
    create_before_destroy = true
  }
  database = "prod"
  schema   = "security"
  name     = "service_users_session_policy"
}
# Attach the session policy to all service users only.
# Use for_all_person_users = true to target all person users instead.
# The two fields are mutually exclusive; when neither is set, the policy is attached account-wide.
resource "snowflake_account_session_policy_attachment" "attachment_service_users" {
  lifecycle {
    create_before_destroy = true
  }
  session_policy_name   = snowflake_session_policy.service_users.fully_qualified_name
  for_all_service_users = true
}

    Note Instead of using fully_qualified_name, you can reference objects managed outside Terraform by constructing a correct ID, consult identifiers guide.

    Note If a field has a default value, it is shown next to the type in the schema.

    Create AccountSessionPolicyAttachment Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new AccountSessionPolicyAttachment(name: string, args: AccountSessionPolicyAttachmentArgs, opts?: CustomResourceOptions);
    @overload
def AccountSessionPolicyAttachment(resource_name: str,
                                   args: AccountSessionPolicyAttachmentArgs,
                                   opts: Optional[ResourceOptions] = None)

@overload
def AccountSessionPolicyAttachment(resource_name: str,
                                   opts: Optional[ResourceOptions] = None,
                                   session_policy_name: Optional[str] = None,
                                   for_all_person_users: Optional[bool] = None,
                                   for_all_service_users: Optional[bool] = None)
    func NewAccountSessionPolicyAttachment(ctx *Context, name string, args AccountSessionPolicyAttachmentArgs, opts ...ResourceOption) (*AccountSessionPolicyAttachment, error)
    public AccountSessionPolicyAttachment(string name, AccountSessionPolicyAttachmentArgs args, CustomResourceOptions? opts = null)
    public AccountSessionPolicyAttachment(String name, AccountSessionPolicyAttachmentArgs args)
public AccountSessionPolicyAttachment(String name, AccountSessionPolicyAttachmentArgs args, CustomResourceOptions options)

    type: snowflake:AccountSessionPolicyAttachment
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.


    resource "snowflake_account_session_policy_attachment" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args AccountSessionPolicyAttachmentArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args AccountSessionPolicyAttachmentArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args AccountSessionPolicyAttachmentArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args AccountSessionPolicyAttachmentArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args AccountSessionPolicyAttachmentArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var accountSessionPolicyAttachmentResource = new Snowflake.AccountSessionPolicyAttachment("accountSessionPolicyAttachmentResource", new()
{
    SessionPolicyName = "string",
    ForAllPersonUsers = false,
    ForAllServiceUsers = false,
});

    example, err := snowflake.NewAccountSessionPolicyAttachment(ctx, "accountSessionPolicyAttachmentResource", &snowflake.AccountSessionPolicyAttachmentArgs{
	SessionPolicyName:  pulumi.String("string"),
	ForAllPersonUsers:  pulumi.Bool(false),
	ForAllServiceUsers: pulumi.Bool(false),
})

    resource "snowflake_account_session_policy_attachment" "accountSessionPolicyAttachmentResource" {
  lifecycle {
    create_before_destroy = true
  }
  session_policy_name   = "string"
  for_all_person_users  = false
  for_all_service_users = false
}

    var accountSessionPolicyAttachmentResource = new AccountSessionPolicyAttachment("accountSessionPolicyAttachmentResource", AccountSessionPolicyAttachmentArgs.builder()
    .sessionPolicyName("string")
    .forAllPersonUsers(false)
    .forAllServiceUsers(false)
    .build());

    account_session_policy_attachment_resource = snowflake.AccountSessionPolicyAttachment("accountSessionPolicyAttachmentResource",
    session_policy_name="string",
    for_all_person_users=False,
    for_all_service_users=False)

    const accountSessionPolicyAttachmentResource = new snowflake.AccountSessionPolicyAttachment("accountSessionPolicyAttachmentResource", {
    sessionPolicyName: "string",
    forAllPersonUsers: false,
    forAllServiceUsers: false,
});

    type: snowflake:AccountSessionPolicyAttachment
properties:
    forAllPersonUsers: false
    forAllServiceUsers: false
    sessionPolicyName: string

    AccountSessionPolicyAttachment Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The AccountSessionPolicyAttachment resource accepts the following input properties:

    SessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    ForAllPersonUsers bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    ForAllServiceUsers bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    SessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    ForAllPersonUsers bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    ForAllServiceUsers bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    session_policy_name string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    for_all_person_users bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    for_all_service_users bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName String
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers Boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers Boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    session_policy_name str
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    for_all_person_users bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    for_all_service_users bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName String
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers Boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers Boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the AccountSessionPolicyAttachment resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing AccountSessionPolicyAttachment Resource

    Get an existing AccountSessionPolicyAttachment resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: AccountSessionPolicyAttachmentState, opts?: CustomResourceOptions): AccountSessionPolicyAttachment
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        for_all_person_users: Optional[bool] = None,
        for_all_service_users: Optional[bool] = None,
        session_policy_name: Optional[str] = None) -> AccountSessionPolicyAttachment
    func GetAccountSessionPolicyAttachment(ctx *Context, name string, id IDInput, state *AccountSessionPolicyAttachmentState, opts ...ResourceOption) (*AccountSessionPolicyAttachment, error)
    public static AccountSessionPolicyAttachment Get(string name, Input<string> id, AccountSessionPolicyAttachmentState? state, CustomResourceOptions? opts = null)
    public static AccountSessionPolicyAttachment get(String name, Output<String> id, AccountSessionPolicyAttachmentState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:AccountSessionPolicyAttachment    get:      id: ${id}
    import {
  to = snowflake_account_session_policy_attachment.example
  id = "${id}"
}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    ForAllPersonUsers bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    ForAllServiceUsers bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    SessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    ForAllPersonUsers bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    ForAllServiceUsers bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    SessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    for_all_person_users bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    for_all_service_users bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    session_policy_name string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers Boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers Boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName String
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName string
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    for_all_person_users bool
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    for_all_service_users bool
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    session_policy_name str
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).
    forAllPersonUsers Boolean
    If true, attaches the session policy to all person users in the current account. Conflicts with forAllServiceUsers. When neither field is set, the policy is attached account-wide.
    forAllServiceUsers Boolean
    If true, attaches the session policy to all service users in the current account. Conflicts with forAllPersonUsers. When neither field is set, the policy is attached account-wide.
    sessionPolicyName String
    Fully qualified name of the session policy to apply to the current account. Due to technical limitations (read more here), avoid using pipes (|).

    Import

    Account-wide attachment:

    $ pulumi import snowflake:index/accountSessionPolicyAttachment:AccountSessionPolicyAttachment example '"<database_name>"."<schema_name>"."<session_policy_name>"|ACCOUNT'

    For all person users:

    $ pulumi import snowflake:index/accountSessionPolicyAttachment:AccountSessionPolicyAttachment example '"<database_name>"."<schema_name>"."<session_policy_name>"|PERSON_USERS'

    For all service users:

    $ pulumi import snowflake:index/accountSessionPolicyAttachment:AccountSessionPolicyAttachment example '"<database_name>"."<schema_name>"."<session_policy_name>"|SERVICE_USERS'

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Viewing docs for Snowflake v2.22.0
    published on Wednesday, Oct 14, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial