Snowflake v0.20.0, Mar 27 23

snowflake.getExternalTables

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var current = Snowflake.GetExternalTables.Invoke(new()
    {
        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, &snowflake.GetExternalTablesArgs{
			Database: "MYDB",
			Schema:   "MYSCHEMA",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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.GetExternalTablesArgs;
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.getExternalTables(GetExternalTablesArgs.builder()
            .database("MYDB")
            .schema("MYSCHEMA")
            .build());

    }
}

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 = snowflake.getExternalTables({
    database: "MYDB",
    schema: "MYSCHEMA",
});

variables:
  current:
    fn::invoke:
      Function: snowflake:getExternalTables
      Arguments:
        database: MYDB
        schema: MYSCHEMA

Using getExternalTables

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 getExternalTables(args: GetExternalTablesArgs, opts?: InvokeOptions): Promise<GetExternalTablesResult>
function getExternalTablesOutput(args: GetExternalTablesOutputArgs, opts?: InvokeOptions): Output<GetExternalTablesResult>

def get_external_tables(database: Optional[str] = None,
                        schema: Optional[str] = None,
                        opts: Optional[InvokeOptions] = None) -> GetExternalTablesResult
def get_external_tables_output(database: Optional[pulumi.Input[str]] = None,
                        schema: Optional[pulumi.Input[str]] = None,
                        opts: Optional[InvokeOptions] = None) -> Output[GetExternalTablesResult]

func GetExternalTables(ctx *Context, args *GetExternalTablesArgs, opts ...InvokeOption) (*GetExternalTablesResult, error)
func GetExternalTablesOutput(ctx *Context, args *GetExternalTablesOutputArgs, opts ...InvokeOption) GetExternalTablesResultOutput

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

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

public static CompletableFuture<GetExternalTablesResult> getExternalTables(GetExternalTablesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: snowflake:index/getExternalTables:getExternalTables
  arguments:
    # arguments dictionary

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 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.

database String: The database from which to return the schemas from.
schema String: 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 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 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.

database String: The database from which to return the schemas from.
externalTables List<Property Map>: 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.

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 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.

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.

Package Details

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