Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi
snowflake.getExternalTables
Explore with Pulumi AI
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";
const current = snowflake.getExternalTables({
    database: "MYDB",
    schema: "MYSCHEMA",
});
import pulumi
import pulumi_snowflake as snowflake
current = snowflake.get_external_tables(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
	})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Snowflake = Pulumi.Snowflake;
return await Deployment.RunAsync(() => 
{
    var current = Snowflake.GetExternalTables.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.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());
    }
}
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 dictionaryThe following arguments are supported:
getExternalTables Result
The following output properties are available:
- Database string
 - The database from which to return the schemas from.
 - External
Tables List<GetExternal Tables External Table>  - 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.
 - External
Tables []GetExternal Tables External Table  - 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.
 - external
Tables List<GetExternal Tables External Table>  - 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.
 - external
Tables GetExternal Tables External Table[]  - 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[GetExternal Tables External Table]  - 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.
 - external
Tables 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    
Package Details
- Repository
 - Snowflake pulumi/pulumi-snowflake
 - License
 - Apache-2.0
 - Notes
 - This Pulumi package is based on the 
snowflakeTerraform Provider.