Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi
snowflake.getProcedures
Explore with Pulumi AI
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";
const current = snowflake.getProcedures({
database: "MYDB",
schema: "MYSCHEMA",
});
import pulumi
import pulumi_snowflake as snowflake
current = snowflake.get_procedures(database="MYDB",
schema="MYSCHEMA")
package main
import (
"github.com/pulumi/pulumi-snowflake/sdk/go/snowflake"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := snowflake.GetProcedures(ctx, &snowflake.GetProceduresArgs{
Database: "MYDB",
Schema: "MYSCHEMA",
}, nil)
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 current = Snowflake.GetProcedures.Invoke(new()
{
Database = "MYDB",
Schema = "MYSCHEMA",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.SnowflakeFunctions;
import com.pulumi.snowflake.inputs.GetProceduresArgs;
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) {
final var current = SnowflakeFunctions.getProcedures(GetProceduresArgs.builder()
.database("MYDB")
.schema("MYSCHEMA")
.build());
}
}
variables:
current:
fn::invoke:
Function: snowflake:getProcedures
Arguments:
database: MYDB
schema: MYSCHEMA
Using getProcedures
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getProcedures(args: GetProceduresArgs, opts?: InvokeOptions): Promise<GetProceduresResult>
function getProceduresOutput(args: GetProceduresOutputArgs, opts?: InvokeOptions): Output<GetProceduresResult>
def get_procedures(database: Optional[str] = None,
schema: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetProceduresResult
def get_procedures_output(database: Optional[pulumi.Input[str]] = None,
schema: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetProceduresResult]
func GetProcedures(ctx *Context, args *GetProceduresArgs, opts ...InvokeOption) (*GetProceduresResult, error)
func GetProceduresOutput(ctx *Context, args *GetProceduresOutputArgs, opts ...InvokeOption) GetProceduresResultOutput
> Note: This function is named GetProcedures
in the Go SDK.
public static class GetProcedures
{
public static Task<GetProceduresResult> InvokeAsync(GetProceduresArgs args, InvokeOptions? opts = null)
public static Output<GetProceduresResult> Invoke(GetProceduresInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetProceduresResult> getProcedures(GetProceduresArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: snowflake:index/getProcedures:getProcedures
arguments:
# arguments dictionary
The following arguments are supported:
getProcedures Result
The following output properties are available:
- Database string
- The database from which to return the schemas from.
- Id string
- The provider-assigned unique ID for this managed resource.
- Procedures
List<Get
Procedures Procedure> - The procedures in the schema
- Schema string
- The schema from which to return the procedures from.
- Database string
- The database from which to return the schemas from.
- Id string
- The provider-assigned unique ID for this managed resource.
- Procedures
[]Get
Procedures Procedure - The procedures in the schema
- Schema string
- The schema from which to return the procedures from.
- database String
- The database from which to return the schemas from.
- id String
- The provider-assigned unique ID for this managed resource.
- procedures
List<Get
Procedures Procedure> - The procedures in the schema
- schema String
- The schema from which to return the procedures from.
- database string
- The database from which to return the schemas from.
- id string
- The provider-assigned unique ID for this managed resource.
- procedures
Get
Procedures Procedure[] - The procedures in the schema
- schema string
- The schema from which to return the procedures from.
- database str
- The database from which to return the schemas from.
- id str
- The provider-assigned unique ID for this managed resource.
- procedures
Sequence[Get
Procedures Procedure] - The procedures in the schema
- schema str
- The schema from which to return the procedures from.
- database String
- The database from which to return the schemas from.
- id String
- The provider-assigned unique ID for this managed resource.
- procedures List<Property Map>
- The procedures in the schema
- schema String
- The schema from which to return the procedures from.
Supporting Types
GetProceduresProcedure
- Argument
Types List<string> - Comment string
- Database string
- Name string
- Return
Type string - Schema string
- Argument
Types []string - Comment string
- Database string
- Name string
- Return
Type string - Schema string
- argument
Types List<String> - comment String
- database String
- name String
- return
Type String - schema String
- argument
Types string[] - comment string
- database string
- name string
- return
Type string - schema string
- argument_
types Sequence[str] - comment str
- database str
- name str
- return_
type str - schema str
- argument
Types List<String> - comment String
- database String
- name String
- return
Type String - schema String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.