Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi
snowflake.getMaterializedViews
Explore with Pulumi AI
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";
const current = snowflake.getMaterializedViews({
    database: "MYDB",
    schema: "MYSCHEMA",
});
import pulumi
import pulumi_snowflake as snowflake
current = snowflake.get_materialized_views(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.GetMaterializedViews(ctx, &snowflake.GetMaterializedViewsArgs{
			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.GetMaterializedViews.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.GetMaterializedViewsArgs;
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.getMaterializedViews(GetMaterializedViewsArgs.builder()
            .database("MYDB")
            .schema("MYSCHEMA")
            .build());
    }
}
variables:
  current:
    fn::invoke:
      Function: snowflake:getMaterializedViews
      Arguments:
        database: MYDB
        schema: MYSCHEMA
Using getMaterializedViews
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 getMaterializedViews(args: GetMaterializedViewsArgs, opts?: InvokeOptions): Promise<GetMaterializedViewsResult>
function getMaterializedViewsOutput(args: GetMaterializedViewsOutputArgs, opts?: InvokeOptions): Output<GetMaterializedViewsResult>def get_materialized_views(database: Optional[str] = None,
                           schema: Optional[str] = None,
                           opts: Optional[InvokeOptions] = None) -> GetMaterializedViewsResult
def get_materialized_views_output(database: Optional[pulumi.Input[str]] = None,
                           schema: Optional[pulumi.Input[str]] = None,
                           opts: Optional[InvokeOptions] = None) -> Output[GetMaterializedViewsResult]func GetMaterializedViews(ctx *Context, args *GetMaterializedViewsArgs, opts ...InvokeOption) (*GetMaterializedViewsResult, error)
func GetMaterializedViewsOutput(ctx *Context, args *GetMaterializedViewsOutputArgs, opts ...InvokeOption) GetMaterializedViewsResultOutput> Note: This function is named GetMaterializedViews in the Go SDK.
public static class GetMaterializedViews 
{
    public static Task<GetMaterializedViewsResult> InvokeAsync(GetMaterializedViewsArgs args, InvokeOptions? opts = null)
    public static Output<GetMaterializedViewsResult> Invoke(GetMaterializedViewsInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetMaterializedViewsResult> getMaterializedViews(GetMaterializedViewsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: snowflake:index/getMaterializedViews:getMaterializedViews
  arguments:
    # arguments dictionaryThe following arguments are supported:
getMaterializedViews 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.
 - Materialized
Views List<GetMaterialized Views Materialized View>  - The views in the schema
 - Schema string
 - The schema from which to return the views from.
 
- Database string
 - The database from which to return the schemas from.
 - Id string
 - The provider-assigned unique ID for this managed resource.
 - Materialized
Views []GetMaterialized Views Materialized View  - The views in the schema
 - Schema string
 - The schema from which to return the views from.
 
- database String
 - The database from which to return the schemas from.
 - id String
 - The provider-assigned unique ID for this managed resource.
 - materialized
Views List<GetMaterialized Views Materialized View>  - The views in the schema
 - schema String
 - The schema from which to return the views from.
 
- database string
 - The database from which to return the schemas from.
 - id string
 - The provider-assigned unique ID for this managed resource.
 - materialized
Views GetMaterialized Views Materialized View[]  - The views in the schema
 - schema string
 - The schema from which to return the views from.
 
- database str
 - The database from which to return the schemas from.
 - id str
 - The provider-assigned unique ID for this managed resource.
 - materialized_
views Sequence[GetMaterialized Views Materialized View]  - The views in the schema
 - schema str
 - The schema from which to return the views from.
 
- database String
 - The database from which to return the schemas from.
 - id String
 - The provider-assigned unique ID for this managed resource.
 - materialized
Views List<Property Map> - The views in the schema
 - schema String
 - The schema from which to return the views from.
 
Supporting Types
GetMaterializedViewsMaterializedView    
Package Details
- Repository
 - Snowflake pulumi/pulumi-snowflake
 - License
 - Apache-2.0
 - Notes
 - This Pulumi package is based on the 
snowflakeTerraform Provider.