1. Packages
  2. Snowflake Provider
  3. API Docs
  4. ProcedurePython
Snowflake v2.12.0 published on Friday, Feb 13, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.ProcedurePython

snowflake logo
Snowflake v2.12.0 published on Friday, Feb 13, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

    !> Caution: Preview Feature This feature is considered a preview feature in the provider, regardless of the state of the resource in Snowflake. We do not guarantee its stability. It will be reworked and marked as a stable feature in future releases. Breaking changes are expected, even without bumping the major version. To use this feature, add the relevant feature name to preview_features_enabled field in the provider configuration. Please always refer to the Getting Help section in our Github repo to best determine how to get help for your questions.

    !> Caution: Import limitation To import the python procedure, snowflake-snowpark-python version must be explicitly set in Snowflake (i.e. snowflake-snowpark-python==1.14.0). You can verify it by running DESCRIBE PROCEDURE <your_procedure> and checking the packages. Check #3303 for reference.

    !> Sensitive values This resource’s procedure_definition and show_output.arguments_raw fields are not marked as sensitive in the provider. Ensure that no personal data, sensitive data, export-controlled data, or other regulated data is entered as metadata when using the provider. If you use one of these fields, they may be present in logs, so ensure that the provider logs are properly restricted. For more information, see Sensitive values limitations and Metadata fields in Snowflake.

    Note External changes to is_secure and null_input_behavior are not currently supported. They will be handled in the following versions of the provider which may still affect this resource.

    Note COPY GRANTS and OR REPLACE are not currently supported.

    Note RETURN... [[ NOT ] NULL] is not currently supported. It will be improved in the following versions of the provider which may still affect this resource.

    Note is_aggregate is not currently supported. It will be improved in the following versions of the provider which may still affect this resource.

    Note Use of return type TABLE is currently limited. It will be improved in the following versions of the provider which may still affect this resource.

    Note Snowflake is not returning full data type information for arguments which may lead to unexpected plan outputs. Diff suppression for such cases will be improved.

    Note Snowflake is not returning the default values for arguments so argument’s arg_default_value external changes cannot be tracked.

    Note Limit the use of special characters (., ', /, ", (, ), [, ], {, }, ) in argument names, stage ids, and secret ids. It’s best to limit to only alphanumeric and underscores. There is a lot of parsing of SHOW/DESCRIBE outputs involved and using special characters may limit the possibility to achieve the correct results.

    Note Diff suppression for import.stage_location is currently not implemented. Make sure you are using the fully qualified stage name (with all the double quotes), e.g. "\"database_name\".\"schema_name\".\"stage_name\"".

    Required warehouse This resource may require active warehouse. Please, make sure you have either set a DEFAULT_WAREHOUSE for the user, or specified a warehouse in the provider configuration.

    Resource used to manage python procedure objects. For more information, check procedure documentation.

    Example Usage

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

const w = new snowflake.ProcedurePython("w", {
    database: "Database",
    schema: "Schema",
    name: "Name",
    arguments: [{
        argDataType: "VARCHAR(100)",
        argName: "x",
    }],
    returnType: "VARCHAR(100)",
    handler: "echoVarchar",
    procedureDefinition: `  def echoVarchar(x):
  result = ''
  for a in range(5):
    result += x
  return result
`,
    runtimeVersion: "3.9",
    snowparkPackage: "1.14.0",
});

    import pulumi
import pulumi_snowflake as snowflake

w = snowflake.ProcedurePython("w",
    database="Database",
    schema="Schema",
    name="Name",
    arguments=[{
        "arg_data_type": "VARCHAR(100)",
        "arg_name": "x",
    }],
    return_type="VARCHAR(100)",
    handler="echoVarchar",
    procedure_definition="""  def echoVarchar(x):
  result = ''
  for a in range(5):
    result += x
  return result
""",
    runtime_version="3.9",
    snowpark_package="1.14.0")

    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 {
		_, err := snowflake.NewProcedurePython(ctx, "w", &snowflake.ProcedurePythonArgs{
			Database: pulumi.String("Database"),
			Schema:   pulumi.String("Schema"),
			Name:     pulumi.String("Name"),
			Arguments: snowflake.ProcedurePythonArgumentArray{
				&snowflake.ProcedurePythonArgumentArgs{
					ArgDataType: pulumi.String("VARCHAR(100)"),
					ArgName:     pulumi.String("x"),
				},
			},
			ReturnType: pulumi.String("VARCHAR(100)"),
			Handler:    pulumi.String("echoVarchar"),
			ProcedureDefinition: pulumi.String(`  def echoVarchar(x):
  result = ''
  for a in range(5):
    result += x
  return result
`),
			RuntimeVersion:  pulumi.String("3.9"),
			SnowparkPackage: pulumi.String("1.14.0"),
		})
		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 w = new Snowflake.ProcedurePython("w", new()
    {
        Database = "Database",
        Schema = "Schema",
        Name = "Name",
        Arguments = new[]
        {
            new Snowflake.Inputs.ProcedurePythonArgumentArgs
            {
                ArgDataType = "VARCHAR(100)",
                ArgName = "x",
            },
        },
        ReturnType = "VARCHAR(100)",
        Handler = "echoVarchar",
        ProcedureDefinition = @"  def echoVarchar(x):
  result = ''
  for a in range(5):
    result += x
  return result
",
        RuntimeVersion = "3.9",
        SnowparkPackage = "1.14.0",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.ProcedurePython;
import com.pulumi.snowflake.ProcedurePythonArgs;
import com.pulumi.snowflake.inputs.ProcedurePythonArgumentArgs;
import java.util.List;
import java.util.ArrayList;
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 w = new ProcedurePython("w", ProcedurePythonArgs.builder()
            .database("Database")
            .schema("Schema")
            .name("Name")
            .arguments(ProcedurePythonArgumentArgs.builder()
                .argDataType("VARCHAR(100)")
                .argName("x")
                .build())
            .returnType("VARCHAR(100)")
            .handler("echoVarchar")
            .procedureDefinition("""
  def echoVarchar(x):
  result = ''
  for a in range(5):
    result += x
  return result
            """)
            .runtimeVersion("3.9")
            .snowparkPackage("1.14.0")
            .build());

    }
}

    resources:
  w:
    type: snowflake:ProcedurePython
    properties:
      database: Database
      schema: Schema
      name: Name
      arguments:
        - argDataType: VARCHAR(100)
          argName: x
      returnType: VARCHAR(100)
      handler: echoVarchar
      procedureDefinition: |2
          def echoVarchar(x):
          result = ''
          for a in range(5):
            result += x
          return result
      runtimeVersion: '3.9'
      snowparkPackage: 1.14.0

    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 ProcedurePython Resource

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

    Constructor syntax

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

@overload
def ProcedurePython(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    handler: Optional[str] = None,
                    snowpark_package: Optional[str] = None,
                    database: Optional[str] = None,
                    schema: Optional[str] = None,
                    runtime_version: Optional[str] = None,
                    return_type: Optional[str] = None,
                    external_access_integrations: Optional[Sequence[str]] = None,
                    packages: Optional[Sequence[str]] = None,
                    is_secure: Optional[str] = None,
                    log_level: Optional[str] = None,
                    metric_level: Optional[str] = None,
                    name: Optional[str] = None,
                    null_input_behavior: Optional[str] = None,
                    imports: Optional[Sequence[ProcedurePythonImportArgs]] = None,
                    procedure_definition: Optional[str] = None,
                    arguments: Optional[Sequence[ProcedurePythonArgumentArgs]] = None,
                    execute_as: Optional[str] = None,
                    enable_console_output: Optional[bool] = None,
                    secrets: Optional[Sequence[ProcedurePythonSecretArgs]] = None,
                    comment: Optional[str] = None,
                    trace_level: Optional[str] = None)
    func NewProcedurePython(ctx *Context, name string, args ProcedurePythonArgs, opts ...ResourceOption) (*ProcedurePython, error)
    public ProcedurePython(string name, ProcedurePythonArgs args, CustomResourceOptions? opts = null)
    public ProcedurePython(String name, ProcedurePythonArgs args)
public ProcedurePython(String name, ProcedurePythonArgs args, CustomResourceOptions options)

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

    Parameters

    name string
    The unique name of the resource.
    args ProcedurePythonArgs
    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 ProcedurePythonArgs
    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 ProcedurePythonArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ProcedurePythonArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ProcedurePythonArgs
    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 procedurePythonResource = new Snowflake.ProcedurePython("procedurePythonResource", new()
{
    Handler = "string",
    SnowparkPackage = "string",
    Database = "string",
    Schema = "string",
    RuntimeVersion = "string",
    ReturnType = "string",
    ExternalAccessIntegrations = new[]
    {
        "string",
    },
    Packages = new[]
    {
        "string",
    },
    IsSecure = "string",
    LogLevel = "string",
    MetricLevel = "string",
    Name = "string",
    NullInputBehavior = "string",
    Imports = new[]
    {
        new Snowflake.Inputs.ProcedurePythonImportArgs
        {
            PathOnStage = "string",
            StageLocation = "string",
        },
    },
    ProcedureDefinition = "string",
    Arguments = new[]
    {
        new Snowflake.Inputs.ProcedurePythonArgumentArgs
        {
            ArgDataType = "string",
            ArgName = "string",
            ArgDefaultValue = "string",
        },
    },
    ExecuteAs = "string",
    EnableConsoleOutput = false,
    Secrets = new[]
    {
        new Snowflake.Inputs.ProcedurePythonSecretArgs
        {
            SecretId = "string",
            SecretVariableName = "string",
        },
    },
    Comment = "string",
    TraceLevel = "string",
});

    example, err := snowflake.NewProcedurePython(ctx, "procedurePythonResource", &snowflake.ProcedurePythonArgs{
	Handler:         pulumi.String("string"),
	SnowparkPackage: pulumi.String("string"),
	Database:        pulumi.String("string"),
	Schema:          pulumi.String("string"),
	RuntimeVersion:  pulumi.String("string"),
	ReturnType:      pulumi.String("string"),
	ExternalAccessIntegrations: pulumi.StringArray{
		pulumi.String("string"),
	},
	Packages: pulumi.StringArray{
		pulumi.String("string"),
	},
	IsSecure:          pulumi.String("string"),
	LogLevel:          pulumi.String("string"),
	MetricLevel:       pulumi.String("string"),
	Name:              pulumi.String("string"),
	NullInputBehavior: pulumi.String("string"),
	Imports: snowflake.ProcedurePythonImportArray{
		&snowflake.ProcedurePythonImportArgs{
			PathOnStage:   pulumi.String("string"),
			StageLocation: pulumi.String("string"),
		},
	},
	ProcedureDefinition: pulumi.String("string"),
	Arguments: snowflake.ProcedurePythonArgumentArray{
		&snowflake.ProcedurePythonArgumentArgs{
			ArgDataType:     pulumi.String("string"),
			ArgName:         pulumi.String("string"),
			ArgDefaultValue: pulumi.String("string"),
		},
	},
	ExecuteAs:           pulumi.String("string"),
	EnableConsoleOutput: pulumi.Bool(false),
	Secrets: snowflake.ProcedurePythonSecretArray{
		&snowflake.ProcedurePythonSecretArgs{
			SecretId:           pulumi.String("string"),
			SecretVariableName: pulumi.String("string"),
		},
	},
	Comment:    pulumi.String("string"),
	TraceLevel: pulumi.String("string"),
})

    var procedurePythonResource = new ProcedurePython("procedurePythonResource", ProcedurePythonArgs.builder()
    .handler("string")
    .snowparkPackage("string")
    .database("string")
    .schema("string")
    .runtimeVersion("string")
    .returnType("string")
    .externalAccessIntegrations("string")
    .packages("string")
    .isSecure("string")
    .logLevel("string")
    .metricLevel("string")
    .name("string")
    .nullInputBehavior("string")
    .imports(ProcedurePythonImportArgs.builder()
        .pathOnStage("string")
        .stageLocation("string")
        .build())
    .procedureDefinition("string")
    .arguments(ProcedurePythonArgumentArgs.builder()
        .argDataType("string")
        .argName("string")
        .argDefaultValue("string")
        .build())
    .executeAs("string")
    .enableConsoleOutput(false)
    .secrets(ProcedurePythonSecretArgs.builder()
        .secretId("string")
        .secretVariableName("string")
        .build())
    .comment("string")
    .traceLevel("string")
    .build());

    procedure_python_resource = snowflake.ProcedurePython("procedurePythonResource",
    handler="string",
    snowpark_package="string",
    database="string",
    schema="string",
    runtime_version="string",
    return_type="string",
    external_access_integrations=["string"],
    packages=["string"],
    is_secure="string",
    log_level="string",
    metric_level="string",
    name="string",
    null_input_behavior="string",
    imports=[{
        "path_on_stage": "string",
        "stage_location": "string",
    }],
    procedure_definition="string",
    arguments=[{
        "arg_data_type": "string",
        "arg_name": "string",
        "arg_default_value": "string",
    }],
    execute_as="string",
    enable_console_output=False,
    secrets=[{
        "secret_id": "string",
        "secret_variable_name": "string",
    }],
    comment="string",
    trace_level="string")

    const procedurePythonResource = new snowflake.ProcedurePython("procedurePythonResource", {
    handler: "string",
    snowparkPackage: "string",
    database: "string",
    schema: "string",
    runtimeVersion: "string",
    returnType: "string",
    externalAccessIntegrations: ["string"],
    packages: ["string"],
    isSecure: "string",
    logLevel: "string",
    metricLevel: "string",
    name: "string",
    nullInputBehavior: "string",
    imports: [{
        pathOnStage: "string",
        stageLocation: "string",
    }],
    procedureDefinition: "string",
    arguments: [{
        argDataType: "string",
        argName: "string",
        argDefaultValue: "string",
    }],
    executeAs: "string",
    enableConsoleOutput: false,
    secrets: [{
        secretId: "string",
        secretVariableName: "string",
    }],
    comment: "string",
    traceLevel: "string",
});

    type: snowflake:ProcedurePython
properties:
    arguments:
        - argDataType: string
          argDefaultValue: string
          argName: string
    comment: string
    database: string
    enableConsoleOutput: false
    executeAs: string
    externalAccessIntegrations:
        - string
    handler: string
    imports:
        - pathOnStage: string
          stageLocation: string
    isSecure: string
    logLevel: string
    metricLevel: string
    name: string
    nullInputBehavior: string
    packages:
        - string
    procedureDefinition: string
    returnType: string
    runtimeVersion: string
    schema: string
    secrets:
        - secretId: string
          secretVariableName: string
    snowparkPackage: string
    traceLevel: string

    ProcedurePython 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 ProcedurePython resource accepts the following input properties:

    Database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    ReturnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    RuntimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    Schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    SnowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    Arguments List<ProcedurePythonArgument>
    List of the arguments for the procedure. Consult the docs for more details.
    Comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    EnableConsoleOutput bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    ExecuteAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    ExternalAccessIntegrations List<string>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    Imports List<ProcedurePythonImport>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    IsSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    LogLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    MetricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    Name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    NullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    Packages List<string>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    ProcedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    Secrets List<ProcedurePythonSecret>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    TraceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    Database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    ReturnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    RuntimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    Schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    SnowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    Arguments []ProcedurePythonArgumentArgs
    List of the arguments for the procedure. Consult the docs for more details.
    Comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    EnableConsoleOutput bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    ExecuteAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    ExternalAccessIntegrations []string
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    Imports []ProcedurePythonImportArgs
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    IsSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    LogLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    MetricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    Name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    NullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    Packages []string
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    ProcedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    Secrets []ProcedurePythonSecretArgs
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    TraceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    database String
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    handler String
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    returnType String
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion String
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema String
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    snowparkPackage String
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    arguments List<ProcedurePythonArgument>
    List of the arguments for the procedure. Consult the docs for more details.
    comment String
    (Default: user-defined procedure) Specifies a comment for the procedure.
    enableConsoleOutput Boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs String
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations List<String>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    imports List<ProcedurePythonImport>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel String
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel String
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name String
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior String
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages List<String>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    procedureDefinition String
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    secrets List<ProcedurePythonSecret>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    traceLevel String
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    returnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    snowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    arguments ProcedurePythonArgument[]
    List of the arguments for the procedure. Consult the docs for more details.
    comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    enableConsoleOutput boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations string[]
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    imports ProcedurePythonImport[]
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages string[]
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    procedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    secrets ProcedurePythonSecret[]
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    traceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    database str
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    handler str
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    return_type str
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtime_version str
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema str
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    snowpark_package str
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    arguments Sequence[ProcedurePythonArgumentArgs]
    List of the arguments for the procedure. Consult the docs for more details.
    comment str
    (Default: user-defined procedure) Specifies a comment for the procedure.
    enable_console_output bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    execute_as str
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    external_access_integrations Sequence[str]
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    imports Sequence[ProcedurePythonImportArgs]
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    is_secure str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    log_level str
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metric_level str
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name str
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    null_input_behavior str
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages Sequence[str]
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    procedure_definition str
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    secrets Sequence[ProcedurePythonSecretArgs]
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    trace_level str
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    database String
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    handler String
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    returnType String
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion String
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema String
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    snowparkPackage String
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    arguments List<Property Map>
    List of the arguments for the procedure. Consult the docs for more details.
    comment String
    (Default: user-defined procedure) Specifies a comment for the procedure.
    enableConsoleOutput Boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs String
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations List<String>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    imports List<Property Map>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel String
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel String
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name String
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior String
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages List<String>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    procedureDefinition String
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    secrets List<Property Map>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    traceLevel String
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.

    Outputs

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

    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    Parameters List<ProcedurePythonParameter>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    ProcedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    ShowOutputs List<ProcedurePythonShowOutput>
    Outputs the result of SHOW PROCEDURE for the given procedure.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    Parameters []ProcedurePythonParameter
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    ProcedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    ShowOutputs []ProcedurePythonShowOutput
    Outputs the result of SHOW PROCEDURE for the given procedure.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    parameters List<ProcedurePythonParameter>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureLanguage String
    Specifies language for the procedure. Used to detect external changes.
    showOutputs List<ProcedurePythonShowOutput>
    Outputs the result of SHOW PROCEDURE for the given procedure.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    id string
    The provider-assigned unique ID for this managed resource.
    parameters ProcedurePythonParameter[]
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    showOutputs ProcedurePythonShowOutput[]
    Outputs the result of SHOW PROCEDURE for the given procedure.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    id str
    The provider-assigned unique ID for this managed resource.
    parameters Sequence[ProcedurePythonParameter]
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedure_language str
    Specifies language for the procedure. Used to detect external changes.
    show_outputs Sequence[ProcedurePythonShowOutput]
    Outputs the result of SHOW PROCEDURE for the given procedure.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureLanguage String
    Specifies language for the procedure. Used to detect external changes.
    showOutputs List<Property Map>
    Outputs the result of SHOW PROCEDURE for the given procedure.

    Look up Existing ProcedurePython Resource

    Get an existing ProcedurePython 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?: ProcedurePythonState, opts?: CustomResourceOptions): ProcedurePython
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        arguments: Optional[Sequence[ProcedurePythonArgumentArgs]] = None,
        comment: Optional[str] = None,
        database: Optional[str] = None,
        enable_console_output: Optional[bool] = None,
        execute_as: Optional[str] = None,
        external_access_integrations: Optional[Sequence[str]] = None,
        fully_qualified_name: Optional[str] = None,
        handler: Optional[str] = None,
        imports: Optional[Sequence[ProcedurePythonImportArgs]] = None,
        is_secure: Optional[str] = None,
        log_level: Optional[str] = None,
        metric_level: Optional[str] = None,
        name: Optional[str] = None,
        null_input_behavior: Optional[str] = None,
        packages: Optional[Sequence[str]] = None,
        parameters: Optional[Sequence[ProcedurePythonParameterArgs]] = None,
        procedure_definition: Optional[str] = None,
        procedure_language: Optional[str] = None,
        return_type: Optional[str] = None,
        runtime_version: Optional[str] = None,
        schema: Optional[str] = None,
        secrets: Optional[Sequence[ProcedurePythonSecretArgs]] = None,
        show_outputs: Optional[Sequence[ProcedurePythonShowOutputArgs]] = None,
        snowpark_package: Optional[str] = None,
        trace_level: Optional[str] = None) -> ProcedurePython
    func GetProcedurePython(ctx *Context, name string, id IDInput, state *ProcedurePythonState, opts ...ResourceOption) (*ProcedurePython, error)
    public static ProcedurePython Get(string name, Input<string> id, ProcedurePythonState? state, CustomResourceOptions? opts = null)
    public static ProcedurePython get(String name, Output<String> id, ProcedurePythonState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:ProcedurePython    get:      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:
    Arguments List<ProcedurePythonArgument>
    List of the arguments for the procedure. Consult the docs for more details.
    Comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    Database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    EnableConsoleOutput bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    ExecuteAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    ExternalAccessIntegrations List<string>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    Imports List<ProcedurePythonImport>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    IsSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    LogLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    MetricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    Name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    NullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    Packages List<string>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    Parameters List<ProcedurePythonParameter>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    ProcedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    ProcedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    ReturnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    RuntimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    Schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Secrets List<ProcedurePythonSecret>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    ShowOutputs List<ProcedurePythonShowOutput>
    Outputs the result of SHOW PROCEDURE for the given procedure.
    SnowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    TraceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    Arguments []ProcedurePythonArgumentArgs
    List of the arguments for the procedure. Consult the docs for more details.
    Comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    Database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    EnableConsoleOutput bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    ExecuteAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    ExternalAccessIntegrations []string
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    Imports []ProcedurePythonImportArgs
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    IsSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    LogLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    MetricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    Name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    NullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    Packages []string
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    Parameters []ProcedurePythonParameterArgs
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    ProcedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    ProcedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    ReturnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    RuntimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    Schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Secrets []ProcedurePythonSecretArgs
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    ShowOutputs []ProcedurePythonShowOutputArgs
    Outputs the result of SHOW PROCEDURE for the given procedure.
    SnowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    TraceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    arguments List<ProcedurePythonArgument>
    List of the arguments for the procedure. Consult the docs for more details.
    comment String
    (Default: user-defined procedure) Specifies a comment for the procedure.
    database String
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    enableConsoleOutput Boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs String
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations List<String>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    handler String
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    imports List<ProcedurePythonImport>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel String
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel String
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name String
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior String
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages List<String>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    parameters List<ProcedurePythonParameter>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureDefinition String
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    procedureLanguage String
    Specifies language for the procedure. Used to detect external changes.
    returnType String
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion String
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema String
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    secrets List<ProcedurePythonSecret>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    showOutputs List<ProcedurePythonShowOutput>
    Outputs the result of SHOW PROCEDURE for the given procedure.
    snowparkPackage String
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    traceLevel String
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    arguments ProcedurePythonArgument[]
    List of the arguments for the procedure. Consult the docs for more details.
    comment string
    (Default: user-defined procedure) Specifies a comment for the procedure.
    database string
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    enableConsoleOutput boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs string
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations string[]
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    handler string
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    imports ProcedurePythonImport[]
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel string
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel string
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name string
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior string
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages string[]
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    parameters ProcedurePythonParameter[]
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureDefinition string
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    procedureLanguage string
    Specifies language for the procedure. Used to detect external changes.
    returnType string
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion string
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema string
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    secrets ProcedurePythonSecret[]
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    showOutputs ProcedurePythonShowOutput[]
    Outputs the result of SHOW PROCEDURE for the given procedure.
    snowparkPackage string
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    traceLevel string
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    arguments Sequence[ProcedurePythonArgumentArgs]
    List of the arguments for the procedure. Consult the docs for more details.
    comment str
    (Default: user-defined procedure) Specifies a comment for the procedure.
    database str
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    enable_console_output bool
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    execute_as str
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    external_access_integrations Sequence[str]
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    handler str
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    imports Sequence[ProcedurePythonImportArgs]
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    is_secure str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    log_level str
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metric_level str
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name str
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    null_input_behavior str
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages Sequence[str]
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    parameters Sequence[ProcedurePythonParameterArgs]
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedure_definition str
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    procedure_language str
    Specifies language for the procedure. Used to detect external changes.
    return_type str
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtime_version str
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema str
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    secrets Sequence[ProcedurePythonSecretArgs]
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    show_outputs Sequence[ProcedurePythonShowOutputArgs]
    Outputs the result of SHOW PROCEDURE for the given procedure.
    snowpark_package str
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    trace_level str
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.
    arguments List<Property Map>
    List of the arguments for the procedure. Consult the docs for more details.
    comment String
    (Default: user-defined procedure) Specifies a comment for the procedure.
    database String
    The database in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    enableConsoleOutput Boolean
    Enable stdout/stderr fast path logging for anonyous stored procs. This is a public parameter (similar to LOGLEVEL). For more information, check CONSOLE_OUTPUT docsENABLE.
    executeAs String
    Specifies whether the stored procedure executes with the privileges of the owner (an “owner’s rights” stored procedure) or with the privileges of the caller (a “caller’s rights” stored procedure). If you execute the statement CREATE PROCEDURE … EXECUTE AS CALLER, then in the future the procedure will execute as a caller’s rights procedure. If you execute CREATE PROCEDURE … EXECUTE AS OWNER, then the procedure will execute as an owner’s rights procedure. For more information, see Understanding caller’s rights and owner’s rights stored procedures. Valid values are (case-insensitive): CALLER | OWNER.
    externalAccessIntegrations List<String>
    The names of external access integrations needed in order for this procedure’s handler code to access external networks. An external access integration specifies network rules and secrets that specify external locations and credentials (if any) allowed for use by handler code when making requests of an external network, such as an external REST API.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    handler String
    Use the name of the stored procedure’s function or method. This can differ depending on whether the code is in-line or referenced at a stage. When the code is in-line, you can specify just the function name. When the code is imported from a stage, specify the fully-qualified handler function name as <module_name>.<function_name>.
    imports List<Property Map>
    The location (stage), path, and name of the file(s) to import. You must set the IMPORTS clause to include any files that your stored procedure depends on. If you are writing an in-line stored procedure, you can omit this clause, unless your code depends on classes defined outside the stored procedure or resource files. If your stored procedure’s code will be on a stage, you must also include a path to the module file your code is in. The IMPORTS definition cannot reference variables from arguments that are passed into the stored procedure. Each file in the IMPORTS clause must have a unique name, even if the files are in different subdirectories or different stages.
    isSecure String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Specifies that the procedure is secure. For more information about secure procedures, see Protecting Sensitive Information with Secure UDFs and Stored Procedures. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    logLevel String
    LOG*LEVEL to use when filtering events For more information, check LOG*LEVEL docs.
    metricLevel String
    METRIC*LEVEL value to control whether to emit metrics to Event Table For more information, check METRIC*LEVEL docs.
    name String
    The name of the procedure; the identifier does not need to be unique for the schema in which the procedure is created because stored procedures are identified and resolved by the combination of the name and argument types. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    nullInputBehavior String
    Specifies the behavior of the procedure when called with null inputs. Valid values are (case-insensitive): CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT.
    packages List<String>
    List of the names of packages deployed in Snowflake that should be included in the handler code’s execution environment. The Snowpark package is required for stored procedures, but is specified in the snowpark_package attribute. For more information about Snowpark, see Snowpark API.
    parameters List<Property Map>
    Outputs the result of SHOW PARAMETERS IN PROCEDURE for the given procedure.
    procedureDefinition String
    Defines the code executed by the stored procedure. The definition can consist of any valid code. Wrapping $$ signs are added by the provider automatically; do not include them. The procedure_definition value must be Python source code. For more information, see Python (using Snowpark). To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
    procedureLanguage String
    Specifies language for the procedure. Used to detect external changes.
    returnType String
    Specifies the type of the result returned by the stored procedure. For <result_data_type>, use the Snowflake data type that corresponds to the type of the language that you are using (see SQL-Python Data Type Mappings). For RETURNS TABLE ( [<span pulumi-lang-nodejs=" colName " pulumi-lang-dotnet=" ColName " pulumi-lang-go=" colName " pulumi-lang-python=" col_name " pulumi-lang-yaml=" colName " pulumi-lang-java=" colName "> col_name </span>col_data_type [ , ... ] ] ), if you know the Snowflake data types of the columns in the returned table, specify the column names and types. Otherwise (e.g. if you are determining the column types during run time), you can omit the column names and types (i.e. TABLE ()).
    runtimeVersion String
    The language runtime version to use. Currently, the supported versions are: 3.9, 3.10, and 3.11.
    schema String
    The schema in which to create the procedure. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    secrets List<Property Map>
    Assigns the names of secrets to variables so that you can use the variables to reference the secrets when retrieving information from secrets in handler code. Secrets you specify here must be allowed by the external access integration specified as a value of this CREATE FUNCTION command’s EXTERNALACCESSINTEGRATIONS parameter.
    showOutputs List<Property Map>
    Outputs the result of SHOW PROCEDURE for the given procedure.
    snowparkPackage String
    The Snowpark package is required for stored procedures, so it must always be present. For more information about Snowpark, see Snowpark API.
    traceLevel String
    Trace level value to use when generating/filtering trace events For more information, check TRACE_LEVEL docs.

    Supporting Types

    ProcedurePythonArgument, ProcedurePythonArgumentArgs

    ArgDataType string
    The argument type.
    ArgName string
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    ArgDefaultValue string
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".
    ArgDataType string
    The argument type.
    ArgName string
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    ArgDefaultValue string
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".
    argDataType String
    The argument type.
    argName String
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    argDefaultValue String
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".
    argDataType string
    The argument type.
    argName string
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    argDefaultValue string
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".
    arg_data_type str
    The argument type.
    arg_name str
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    arg_default_value str
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".
    argDataType String
    The argument type.
    argName String
    The argument name. The provider wraps it in double quotes by default, so be aware of that while referencing the argument in the procedure definition.
    argDefaultValue String
    Optional default value for the argument. For text values use single quotes. Numeric values can be unquoted. External changes for this field won't be detected. In case you want to apply external changes, you can re-create the resource manually using "terraform taint".

    ProcedurePythonImport, ProcedurePythonImportArgs

    PathOnStage string
    Path for import on stage, without the leading /.
    StageLocation string
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).
    PathOnStage string
    Path for import on stage, without the leading /.
    StageLocation string
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).
    pathOnStage String
    Path for import on stage, without the leading /.
    stageLocation String
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).
    pathOnStage string
    Path for import on stage, without the leading /.
    stageLocation string
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).
    path_on_stage str
    Path for import on stage, without the leading /.
    stage_location str
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).
    pathOnStage String
    Path for import on stage, without the leading /.
    stageLocation String
    Stage location without leading @. To use your user's stage set this to ~, otherwise pass fully qualified name of the stage (with every part contained in double quotes or use snowflake_stage.<your stage's resource name>.fully_qualified_name if you manage this stage through terraform).

    ProcedurePythonParameter, ProcedurePythonParameterArgs

    ProcedurePythonParameterEnableConsoleOutput, ProcedurePythonParameterEnableConsoleOutputArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    ProcedurePythonParameterLogLevel, ProcedurePythonParameterLogLevelArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    ProcedurePythonParameterMetricLevel, ProcedurePythonParameterMetricLevelArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    ProcedurePythonParameterTraceLevel, ProcedurePythonParameterTraceLevelArgs

    Default string
    Description string
    Key string
    Level string
    Value string
    Default string
    Description string
    Key string
    Level string
    Value string
    default_ String
    description String
    key String
    level String
    value String
    default string
    description string
    key string
    level string
    value string
    default String
    description String
    key String
    level String
    value String

    ProcedurePythonSecret, ProcedurePythonSecretArgs

    SecretId string
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    SecretVariableName string
    The variable that will be used in handler code when retrieving information from the secret.
    SecretId string
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    SecretVariableName string
    The variable that will be used in handler code when retrieving information from the secret.
    secretId String
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    secretVariableName String
    The variable that will be used in handler code when retrieving information from the secret.
    secretId string
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    secretVariableName string
    The variable that will be used in handler code when retrieving information from the secret.
    secret_id str
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    secret_variable_name str
    The variable that will be used in handler code when retrieving information from the secret.
    secretId String
    Fully qualified name of the allowed secret. You will receive an error if you specify a SECRETS value whose secret isn’t also included in an integration specified by the EXTERNALACCESSINTEGRATIONS parameter.
    secretVariableName String
    The variable that will be used in handler code when retrieving information from the secret.

    ProcedurePythonShowOutput, ProcedurePythonShowOutputArgs

    Import

    terraform import snowflake_procedure_python.example '"<database_name>"."<schema_name>"."<function_name>"(varchar, varchar, varchar)'

    Note: Snowflake is not returning all information needed to populate the state correctly after import (e.g. data types with attributes like NUMBER(32, 10) are returned as NUMBER, default values for arguments are not returned at all). Also, ALTER for functions is very limited so most of the attributes on this resource are marked as force new. Because of that, in multiple situations plan won’t be empty after importing and manual state operations may be required.

    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
    Snowflake v2.12.0 published on Friday, Feb 13, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake
      Meet Neo: Your AI Platform Teammate