getHybridTables

Snowflake v2.21.0, Sep 11 26

Viewing docs for Snowflake v2.21.0
published on Friday, Sep 11, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Viewing docs for Snowflake v2.21.0
published on Friday, Sep 11, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Caution: Preview Feature This feature is considered a preview feature in the provider, regardless of the state of the resource in Snowflake. We do not guarantee its stability. It will be reworked and marked as a stable feature in future releases. Breaking changes are expected, even without bumping the major version. To use this feature, add the relevant feature name to previewFeaturesEnabled field in the provider configuration. Please always refer to the Getting Help section in our Github repo to best determine how to get help for your questions.

Data source used to get details of filtered hybrid tables. Filtering is aligned with the current possibilities for SHOW HYBRID TABLES query (like, in, startsWith, limit). The results of SHOW, DESCRIBE, SHOW PARAMETERS, SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, SHOW IMPORTED KEYS, and SHOW INDEXES are encapsulated in one output collection hybridTables.

Using getHybridTables

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 getHybridTables(args: GetHybridTablesArgs, opts?: InvokeOptions): Promise<GetHybridTablesResult>
function getHybridTablesOutput(args: GetHybridTablesOutputArgs, opts?: InvokeOutputOptions): Output<GetHybridTablesResult>

def get_hybrid_tables(in_: Optional[GetHybridTablesIn] = None,
                      like: Optional[str] = None,
                      limit: Optional[GetHybridTablesLimit] = None,
                      starts_with: Optional[str] = None,
                      with_describe: Optional[bool] = None,
                      with_indexes: Optional[bool] = None,
                      with_keys: Optional[bool] = None,
                      with_parameters: Optional[bool] = None,
                      opts: Optional[InvokeOptions] = None) -> GetHybridTablesResult
def get_hybrid_tables_output(in_: pulumi.Input[Optional[GetHybridTablesInArgs]] = None,
                      like: pulumi.Input[Optional[str]] = None,
                      limit: pulumi.Input[Optional[GetHybridTablesLimitArgs]] = None,
                      starts_with: pulumi.Input[Optional[str]] = None,
                      with_describe: pulumi.Input[Optional[bool]] = None,
                      with_indexes: pulumi.Input[Optional[bool]] = None,
                      with_keys: pulumi.Input[Optional[bool]] = None,
                      with_parameters: pulumi.Input[Optional[bool]] = None,
                      opts: Optional[InvokeOutputOptions] = None) -> Output[GetHybridTablesResult]

func GetHybridTables(ctx *Context, args *GetHybridTablesArgs, opts ...InvokeOption) (*GetHybridTablesResult, error)
func GetHybridTablesOutput(ctx *Context, args *GetHybridTablesOutputArgs, opts ...InvokeOption) GetHybridTablesResultOutput

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

public static class GetHybridTables 
{
    public static Task<GetHybridTablesResult> InvokeAsync(GetHybridTablesArgs args, InvokeOptions? opts = null)
    public static Output<GetHybridTablesResult> Invoke(GetHybridTablesInvokeArgs args, InvokeOptions? opts = null)
    public static Output<GetHybridTablesResult> Invoke(GetHybridTablesInvokeArgs args, InvokeOutputOptions opts)
}

public static CompletableFuture<GetHybridTablesResult> getHybridTables(GetHybridTablesArgs args, InvokeOptions options)
public static Output<GetHybridTablesResult> getHybridTables(GetHybridTablesArgs args, InvokeOptions options)
public static Output<GetHybridTablesResult> getHybridTables(GetHybridTablesArgs args, InvokeOutputOptions options)

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

data "snowflake_get_hybrid_tables" "name" {
    # arguments
}

The following arguments are supported:

In GetHybridTablesIn: IN clause to filter the list of objects
Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetHybridTablesLimit: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
WithIndexes bool: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
WithKeys bool: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
WithParameters bool: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

In GetHybridTablesIn: IN clause to filter the list of objects
Like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
Limit GetHybridTablesLimit: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
StartsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
WithDescribe bool: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
WithIndexes bool: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
WithKeys bool: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
WithParameters bool: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

in object: IN clause to filter the list of objects
like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit object: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
starts_with string: Filters the output with case-sensitive characters indicating the beginning of the object name.
with_describe bool: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
with_indexes bool: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
with_keys bool: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
with_parameters bool: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

in GetHybridTablesIn: IN clause to filter the list of objects
like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetHybridTablesLimit: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
withIndexes Boolean: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
withKeys Boolean: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
withParameters Boolean: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

in GetHybridTablesIn: IN clause to filter the list of objects
like string: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetHybridTablesLimit: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
startsWith string: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe boolean: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
withIndexes boolean: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
withKeys boolean: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
withParameters boolean: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

in_ GetHybridTablesIn: IN clause to filter the list of objects
like str: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit GetHybridTablesLimit: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
starts_with str: Filters the output with case-sensitive characters indicating the beginning of the object name.
with_describe bool: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
with_indexes bool: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
with_keys bool: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
with_parameters bool: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.

in Property Map: IN clause to filter the list of objects
like String: Filters the output with case-insensitive pattern, with support for SQL wildcard characters (% and _).
limit Property Map: Limits the number of rows returned. If the limit.from is set, then the limit will start from the first element matched by the expression. The expression is only used to match with the first element, later on the elements are not matched by the prefix, but you can enforce a certain pattern with startsWith or like.
startsWith String: Filters the output with case-sensitive characters indicating the beginning of the object name.
withDescribe Boolean: (Default: true) Runs DESC TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output of describe is saved to the describeOutput field. By default this value is set to true.
withIndexes Boolean: (Default: false) Runs SHOW INDEXES for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the showIndexes field. By default this value is set to false.
withKeys Boolean: (Default: false) Runs SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for each hybrid table returned by SHOW HYBRID TABLES. The merged constraints are saved to the showkeysoutput field, grouped by constraint name and ordered by kind, then by column names. By default this value is set to false.
withParameters Boolean: (Default: true) Runs SHOW PARAMETERS FOR TABLE for each hybrid table returned by SHOW HYBRID TABLES. The output is saved to the parameters field. By default this value is set to true.