Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi
snowflake.getStreamlits
Explore with Pulumi AI
Data source used to get details of filtered streamlits. Filtering is aligned with the current possibilities for SHOW STREAMLITS query (only like
is supported). The results of SHOW and DESCRIBE are encapsulated in one output collection streamlits
.
Using getStreamlits
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 getStreamlits(args: GetStreamlitsArgs, opts?: InvokeOptions): Promise<GetStreamlitsResult>
function getStreamlitsOutput(args: GetStreamlitsOutputArgs, opts?: InvokeOptions): Output<GetStreamlitsResult>
def get_streamlits(in_: Optional[GetStreamlitsIn] = None,
like: Optional[str] = None,
limit: Optional[GetStreamlitsLimit] = None,
with_describe: Optional[bool] = None,
opts: Optional[InvokeOptions] = None) -> GetStreamlitsResult
def get_streamlits_output(in_: Optional[pulumi.Input[GetStreamlitsInArgs]] = None,
like: Optional[pulumi.Input[str]] = None,
limit: Optional[pulumi.Input[GetStreamlitsLimitArgs]] = None,
with_describe: Optional[pulumi.Input[bool]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetStreamlitsResult]
func GetStreamlits(ctx *Context, args *GetStreamlitsArgs, opts ...InvokeOption) (*GetStreamlitsResult, error)
func GetStreamlitsOutput(ctx *Context, args *GetStreamlitsOutputArgs, opts ...InvokeOption) GetStreamlitsResultOutput
> Note: This function is named GetStreamlits
in the Go SDK.
public static class GetStreamlits
{
public static Task<GetStreamlitsResult> InvokeAsync(GetStreamlitsArgs args, InvokeOptions? opts = null)
public static Output<GetStreamlitsResult> Invoke(GetStreamlitsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetStreamlitsResult> getStreamlits(GetStreamlitsArgs args, InvokeOptions options)
public static Output<GetStreamlitsResult> getStreamlits(GetStreamlitsArgs args, InvokeOptions options)
fn::invoke:
function: snowflake:index/getStreamlits:getStreamlits
arguments:
# arguments dictionary
The following arguments are supported:
- In
Get
Streamlits In - IN clause to filter the list of streamlits
- Like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - Limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - With
Describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- In
Get
Streamlits In - IN clause to filter the list of streamlits
- Like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - Limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - With
Describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- in
Get
Streamlits In - IN clause to filter the list of streamlits
- like String
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with
Describe Boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- in
Get
Streamlits In - IN clause to filter the list of streamlits
- like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with
Describe boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- in_
Get
Streamlits In - IN clause to filter the list of streamlits
- like str
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with_
describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- in Property Map
- IN clause to filter the list of streamlits
- 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 wll 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 withstarts_with
orlike
. - with
Describe Boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
getStreamlits Result
The following output properties are available:
- Id string
- The provider-assigned unique ID for this managed resource.
- Streamlits
List<Get
Streamlits Streamlit> - Holds the aggregated output of all streamlits details queries.
- In
Get
Streamlits In - IN clause to filter the list of streamlits
- Like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - Limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - With
Describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- Id string
- The provider-assigned unique ID for this managed resource.
- Streamlits
[]Get
Streamlits Streamlit - Holds the aggregated output of all streamlits details queries.
- In
Get
Streamlits In - IN clause to filter the list of streamlits
- Like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - Limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - With
Describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- id String
- The provider-assigned unique ID for this managed resource.
- streamlits
List<Get
Streamlits Streamlit> - Holds the aggregated output of all streamlits details queries.
- in
Get
Streamlits In - IN clause to filter the list of streamlits
- like String
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with
Describe Boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- id string
- The provider-assigned unique ID for this managed resource.
- streamlits
Get
Streamlits Streamlit[] - Holds the aggregated output of all streamlits details queries.
- in
Get
Streamlits In - IN clause to filter the list of streamlits
- like string
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with
Describe boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- id str
- The provider-assigned unique ID for this managed resource.
- streamlits
Sequence[Get
Streamlits Streamlit] - Holds the aggregated output of all streamlits details queries.
- in_
Get
Streamlits In - IN clause to filter the list of streamlits
- like str
- Filters the output with case-insensitive pattern, with support for SQL wildcard characters (
%
and_
). - limit
Get
Streamlits Limit - Limits the number of rows returned. If the
limit.from
is set, then the limit wll 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 withstarts_with
orlike
. - with_
describe bool - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
- id String
- The provider-assigned unique ID for this managed resource.
- streamlits List<Property Map>
- Holds the aggregated output of all streamlits details queries.
- in Property Map
- IN clause to filter the list of streamlits
- 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 wll 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 withstarts_with
orlike
. - with
Describe Boolean - (Default:
true
) Runs DESC STREAMLIT for each streamlit returned by SHOW STREAMLITS. The output of describe is saved to the description field. By default this value is set to true.
Supporting Types
GetStreamlitsIn
GetStreamlitsLimit
GetStreamlitsStreamlit
- Describe
Outputs This property is required. List<GetStreamlits Streamlit Describe Output> - Holds the output of DESCRIBE STREAMLIT.
- Show
Outputs This property is required. List<GetStreamlits Streamlit Show Output> - Holds the output of SHOW STREAMLITS.
- Describe
Outputs This property is required. []GetStreamlits Streamlit Describe Output - Holds the output of DESCRIBE STREAMLIT.
- Show
Outputs This property is required. []GetStreamlits Streamlit Show Output - Holds the output of SHOW STREAMLITS.
- describe
Outputs This property is required. List<GetStreamlits Streamlit Describe Output> - Holds the output of DESCRIBE STREAMLIT.
- show
Outputs This property is required. List<GetStreamlits Streamlit Show Output> - Holds the output of SHOW STREAMLITS.
- describe
Outputs This property is required. GetStreamlits Streamlit Describe Output[] - Holds the output of DESCRIBE STREAMLIT.
- show
Outputs This property is required. GetStreamlits Streamlit Show Output[] - Holds the output of SHOW STREAMLITS.
- describe_
outputs This property is required. Sequence[GetStreamlits Streamlit Describe Output] - Holds the output of DESCRIBE STREAMLIT.
- show_
outputs This property is required. Sequence[GetStreamlits Streamlit Show Output] - Holds the output of SHOW STREAMLITS.
- describe
Outputs This property is required. List<Property Map> - Holds the output of DESCRIBE STREAMLIT.
- show
Outputs This property is required. List<Property Map> - Holds the output of SHOW STREAMLITS.
GetStreamlitsStreamlitDescribeOutput
- Default
Packages This property is required. string - External
Access Integrations This property is required. List<string> - External
Access Secrets This property is required. string - Import
Urls This property is required. List<string> - Main
File This property is required. string - Name
This property is required. string - Query
Warehouse This property is required. string - Root
Location This property is required. string - Title
This property is required. string - Url
Id This property is required. string - User
Packages This property is required. List<string>
- Default
Packages This property is required. string - External
Access Integrations This property is required. []string - External
Access Secrets This property is required. string - Import
Urls This property is required. []string - Main
File This property is required. string - Name
This property is required. string - Query
Warehouse This property is required. string - Root
Location This property is required. string - Title
This property is required. string - Url
Id This property is required. string - User
Packages This property is required. []string
- default
Packages This property is required. String - external
Access Integrations This property is required. List<String> - external
Access Secrets This property is required. String - import
Urls This property is required. List<String> - main
File This property is required. String - name
This property is required. String - query
Warehouse This property is required. String - root
Location This property is required. String - title
This property is required. String - url
Id This property is required. String - user
Packages This property is required. List<String>
- default
Packages This property is required. string - external
Access Integrations This property is required. string[] - external
Access Secrets This property is required. string - import
Urls This property is required. string[] - main
File This property is required. string - name
This property is required. string - query
Warehouse This property is required. string - root
Location This property is required. string - title
This property is required. string - url
Id This property is required. string - user
Packages This property is required. string[]
- default_
packages This property is required. str - external_
access_ integrations This property is required. Sequence[str] - external_
access_ secrets This property is required. str - import_
urls This property is required. Sequence[str] - main_
file This property is required. str - name
This property is required. str - query_
warehouse This property is required. str - root_
location This property is required. str - title
This property is required. str - url_
id This property is required. str - user_
packages This property is required. Sequence[str]
- default
Packages This property is required. String - external
Access Integrations This property is required. List<String> - external
Access Secrets This property is required. String - import
Urls This property is required. List<String> - main
File This property is required. String - name
This property is required. String - query
Warehouse This property is required. String - root
Location This property is required. String - title
This property is required. String - url
Id This property is required. String - user
Packages This property is required. List<String>
GetStreamlitsStreamlitShowOutput
- Comment
This property is required. string - Created
On This property is required. string - Database
Name This property is required. string - Name
This property is required. string - Owner
This property is required. string - Owner
Role Type This property is required. string - Query
Warehouse This property is required. string - Schema
Name This property is required. string - Title
This property is required. string - Url
Id This property is required. string
- Comment
This property is required. string - Created
On This property is required. string - Database
Name This property is required. string - Name
This property is required. string - Owner
This property is required. string - Owner
Role Type This property is required. string - Query
Warehouse This property is required. string - Schema
Name This property is required. string - Title
This property is required. string - Url
Id This property is required. string
- comment
This property is required. String - created
On This property is required. String - database
Name This property is required. String - name
This property is required. String - owner
This property is required. String - owner
Role Type This property is required. String - query
Warehouse This property is required. String - schema
Name This property is required. String - title
This property is required. String - url
Id This property is required. String
- comment
This property is required. string - created
On This property is required. string - database
Name This property is required. string - name
This property is required. string - owner
This property is required. string - owner
Role Type This property is required. string - query
Warehouse This property is required. string - schema
Name This property is required. string - title
This property is required. string - url
Id This property is required. string
- comment
This property is required. str - created_
on This property is required. str - database_
name This property is required. str - name
This property is required. str - owner
This property is required. str - owner_
role_ type This property is required. str - query_
warehouse This property is required. str - schema_
name This property is required. str - title
This property is required. str - url_
id This property is required. str
- comment
This property is required. String - created
On This property is required. String - database
Name This property is required. String - name
This property is required. String - owner
This property is required. String - owner
Role Type This property is required. String - query
Warehouse This property is required. String - schema
Name This property is required. String - title
This property is required. String - url
Id This property is required. String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
snowflake
Terraform Provider.