Snowflake v1.1.3 published on Saturday, Mar 8, 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 dictionaryThe following arguments are supported:
- In
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- WithDescribe bool
- 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
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- WithDescribe bool
- 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
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- withDescribe Boolean
- 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
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- withDescribe boolean
- 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_
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- with_describe bool
- 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.fromis 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_withorlike.
- withDescribe Boolean
- 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<GetStreamlits Streamlit> 
- Holds the aggregated output of all streamlits details queries.
- In
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- WithDescribe bool
- 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
[]GetStreamlits Streamlit 
- Holds the aggregated output of all streamlits details queries.
- In
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- WithDescribe bool
- 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<GetStreamlits Streamlit> 
- Holds the aggregated output of all streamlits details queries.
- in
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- withDescribe Boolean
- 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
GetStreamlits Streamlit[] 
- Holds the aggregated output of all streamlits details queries.
- in
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- withDescribe boolean
- 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[GetStreamlits Streamlit] 
- Holds the aggregated output of all streamlits details queries.
- in_
GetStreamlits 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
GetStreamlits Limit 
- Limits the number of rows returned. If the limit.fromis 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_withorlike.
- with_describe bool
- 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.fromis 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_withorlike.
- withDescribe Boolean
- 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  
- DescribeOutputs List<GetStreamlits Streamlit Describe Output> 
- Holds the output of DESCRIBE STREAMLIT.
- ShowOutputs List<GetStreamlits Streamlit Show Output> 
- Holds the output of SHOW STREAMLITS.
- DescribeOutputs []GetStreamlits Streamlit Describe Output 
- Holds the output of DESCRIBE STREAMLIT.
- ShowOutputs []GetStreamlits Streamlit Show Output 
- Holds the output of SHOW STREAMLITS.
- describeOutputs List<GetStreamlits Streamlit Describe Output> 
- Holds the output of DESCRIBE STREAMLIT.
- showOutputs List<GetStreamlits Streamlit Show Output> 
- Holds the output of SHOW STREAMLITS.
- describeOutputs GetStreamlits Streamlit Describe Output[] 
- Holds the output of DESCRIBE STREAMLIT.
- showOutputs GetStreamlits Streamlit Show Output[] 
- Holds the output of SHOW STREAMLITS.
- describe_outputs Sequence[GetStreamlits Streamlit Describe Output] 
- Holds the output of DESCRIBE STREAMLIT.
- show_outputs Sequence[GetStreamlits Streamlit Show Output] 
- Holds the output of SHOW STREAMLITS.
- describeOutputs List<Property Map>
- Holds the output of DESCRIBE STREAMLIT.
- showOutputs List<Property Map>
- Holds the output of SHOW STREAMLITS.
GetStreamlitsStreamlitDescribeOutput    
- DefaultPackages string
- ExternalAccess List<string>Integrations 
- ExternalAccess stringSecrets 
- ImportUrls List<string>
- MainFile string
- Name string
- QueryWarehouse string
- RootLocation string
- Title string
- UrlId string
- UserPackages List<string>
- DefaultPackages string
- ExternalAccess []stringIntegrations 
- ExternalAccess stringSecrets 
- ImportUrls []string
- MainFile string
- Name string
- QueryWarehouse string
- RootLocation string
- Title string
- UrlId string
- UserPackages []string
- defaultPackages String
- externalAccess List<String>Integrations 
- externalAccess StringSecrets 
- importUrls List<String>
- mainFile String
- name String
- queryWarehouse String
- rootLocation String
- title String
- urlId String
- userPackages List<String>
- defaultPackages string
- externalAccess string[]Integrations 
- externalAccess stringSecrets 
- importUrls string[]
- mainFile string
- name string
- queryWarehouse string
- rootLocation string
- title string
- urlId string
- userPackages string[]
- default_packages str
- external_access_ Sequence[str]integrations 
- external_access_ strsecrets 
- import_urls Sequence[str]
- main_file str
- name str
- query_warehouse str
- root_location str
- title str
- url_id str
- user_packages Sequence[str]
- defaultPackages String
- externalAccess List<String>Integrations 
- externalAccess StringSecrets 
- importUrls List<String>
- mainFile String
- name String
- queryWarehouse String
- rootLocation String
- title String
- urlId String
- userPackages List<String>
GetStreamlitsStreamlitShowOutput    
- Comment string
- CreatedOn string
- DatabaseName string
- Name string
- Owner string
- OwnerRole stringType 
- QueryWarehouse string
- SchemaName string
- Title string
- UrlId string
- Comment string
- CreatedOn string
- DatabaseName string
- Name string
- Owner string
- OwnerRole stringType 
- QueryWarehouse string
- SchemaName string
- Title string
- UrlId string
- comment String
- createdOn String
- databaseName String
- name String
- owner String
- ownerRole StringType 
- queryWarehouse String
- schemaName String
- title String
- urlId String
- comment string
- createdOn string
- databaseName string
- name string
- owner string
- ownerRole stringType 
- queryWarehouse string
- schemaName string
- title string
- urlId string
- comment str
- created_on str
- database_name str
- name str
- owner str
- owner_role_ strtype 
- query_warehouse str
- schema_name str
- title str
- url_id str
- comment String
- createdOn String
- databaseName String
- name String
- owner String
- ownerRole StringType 
- queryWarehouse String
- schemaName String
- title String
- urlId String
Package Details
- Repository
- Snowflake pulumi/pulumi-snowflake
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the snowflakeTerraform Provider.