Welcome to Pulumi Registry, your window into the cloud. Read the announcement.

Snowflake

v0.2.1 published on Monday, Sep 27, 2021 by Pulumi

getExternalTables

Example Usage

using Pulumi;
using Snowflake = Pulumi.Snowflake;

class MyStack : Stack
{
    public MyStack()
    {
        var current = Output.Create(Snowflake.GetExternalTables.InvokeAsync(new Snowflake.GetExternalTablesArgs
        {
            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.GetExternalTables(ctx, &GetExternalTablesArgs{
			Database: "MYDB",
			Schema:   "MYSCHEMA",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
import pulumi
import pulumi_snowflake as snowflake

current = snowflake.get_external_tables(database="MYDB",
    schema="MYSCHEMA")
import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";

const current = pulumi.output(snowflake.getExternalTables({
    database: "MYDB",
    schema: "MYSCHEMA",
}));

Using getExternalTables

function getExternalTables(args: GetExternalTablesArgs, opts?: InvokeOptions): Promise<GetExternalTablesResult>
def get_external_tables(database: Optional[str] = None,
                        schema: Optional[str] = None,
                        opts: Optional[InvokeOptions] = None) -> GetExternalTablesResult
func GetExternalTables(ctx *Context, args *GetExternalTablesArgs, opts ...InvokeOption) (*GetExternalTablesResult, error)

Note: This function is named GetExternalTables in the Go SDK.

public static class GetExternalTables {
    public static Task<GetExternalTablesResult> InvokeAsync(GetExternalTablesArgs args, InvokeOptions? opts = null)
}

The following arguments are supported:

Database string
The database from which to return the schemas from.
Schema string
The schema from which to return the external tables from.
Database string
The database from which to return the schemas from.
Schema string
The schema from which to return the external tables from.
database string
The database from which to return the schemas from.
schema string
The schema from which to return the external tables from.
database str
The database from which to return the schemas from.
schema str
The schema from which to return the external tables from.

getExternalTables Result

The following output properties are available:

Database string
The database from which to return the schemas from.
ExternalTables List<GetExternalTablesExternalTable>
The external tables in the schema
Id string
The provider-assigned unique ID for this managed resource.
Schema string
The schema from which to return the external tables from.
Database string
The database from which to return the schemas from.
ExternalTables []GetExternalTablesExternalTable
The external tables in the schema
Id string
The provider-assigned unique ID for this managed resource.
Schema string
The schema from which to return the external tables from.
database string
The database from which to return the schemas from.
externalTables GetExternalTablesExternalTable[]
The external tables in the schema
id string
The provider-assigned unique ID for this managed resource.
schema string
The schema from which to return the external tables from.
database str
The database from which to return the schemas from.
external_tables Sequence[GetExternalTablesExternalTable]
The external tables in the schema
id str
The provider-assigned unique ID for this managed resource.
schema str
The schema from which to return the external tables from.

Supporting Types

GetExternalTablesExternalTable

Comment string
Database string
The database from which to return the schemas from.
Name string
Schema string
The schema from which to return the external tables from.
Comment string
Database string
The database from which to return the schemas from.
Name string
Schema string
The schema from which to return the external tables from.
comment string
database string
The database from which to return the schemas from.
name string
schema string
The schema from which to return the external tables from.
comment str
database str
The database from which to return the schemas from.
name str
schema str
The schema from which to return the external tables from.

Package Details

Repository
https://github.com/pulumi/pulumi-snowflake
License
Apache-2.0
Notes
This Pulumi package is based on the snowflake Terraform Provider.