1. Packages
  2. Snowflake Provider
  3. API Docs
  4. getStreamlits
Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

snowflake.getStreamlits

Explore with Pulumi AI

Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

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>
Copy
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]
Copy
func GetStreamlits(ctx *Context, args *GetStreamlitsArgs, opts ...InvokeOption) (*GetStreamlitsResult, error)
func GetStreamlitsOutput(ctx *Context, args *GetStreamlitsOutputArgs, opts ...InvokeOption) GetStreamlitsResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetStreamlitsResult> getStreamlits(GetStreamlitsArgs args, InvokeOptions options)
public static Output<GetStreamlitsResult> getStreamlits(GetStreamlitsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: snowflake:index/getStreamlits:getStreamlits
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

In GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
WithDescribe 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 GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
WithDescribe 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 GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
withDescribe 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 GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
withDescribe 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_ GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
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 with starts_with or like.
withDescribe 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<GetStreamlitsStreamlit>
Holds the aggregated output of all streamlits details queries.
In GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
WithDescribe 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 []GetStreamlitsStreamlit
Holds the aggregated output of all streamlits details queries.
In GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
WithDescribe 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<GetStreamlitsStreamlit>
Holds the aggregated output of all streamlits details queries.
in GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
withDescribe 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 GetStreamlitsStreamlit[]
Holds the aggregated output of all streamlits details queries.
in GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
withDescribe 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[GetStreamlitsStreamlit]
Holds the aggregated output of all streamlits details queries.
in_ GetStreamlitsIn
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 GetStreamlitsLimit
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 with starts_with or like.
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 with starts_with or like.
withDescribe 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

Account bool
Returns records for the entire account.
Database string
Returns records for the current database in use or for a specified database (db_name).
Schema string
Returns records for the current schema in use or a specified schema (schema_name).
Account bool
Returns records for the entire account.
Database string
Returns records for the current database in use or for a specified database (db_name).
Schema string
Returns records for the current schema in use or a specified schema (schema_name).
account Boolean
Returns records for the entire account.
database String
Returns records for the current database in use or for a specified database (db_name).
schema String
Returns records for the current schema in use or a specified schema (schema_name).
account boolean
Returns records for the entire account.
database string
Returns records for the current database in use or for a specified database (db_name).
schema string
Returns records for the current schema in use or a specified schema (schema_name).
account bool
Returns records for the entire account.
database str
Returns records for the current database in use or for a specified database (db_name).
schema str
Returns records for the current schema in use or a specified schema (schema_name).
account Boolean
Returns records for the entire account.
database String
Returns records for the current database in use or for a specified database (db_name).
schema String
Returns records for the current schema in use or a specified schema (schema_name).

GetStreamlitsLimit

Rows This property is required. int
The maximum number of rows to return.
From string
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.
Rows This property is required. int
The maximum number of rows to return.
From string
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.
rows This property is required. Integer
The maximum number of rows to return.
from String
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.
rows This property is required. number
The maximum number of rows to return.
from string
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.
rows This property is required. int
The maximum number of rows to return.
from_ str
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.
rows This property is required. Number
The maximum number of rows to return.
from String
Specifies a case-sensitive pattern that is used to match object name. After the first match, the limit on the number of rows will be applied.

GetStreamlitsStreamlit

DescribeOutputs This property is required. List<GetStreamlitsStreamlitDescribeOutput>
Holds the output of DESCRIBE STREAMLIT.
ShowOutputs This property is required. List<GetStreamlitsStreamlitShowOutput>
Holds the output of SHOW STREAMLITS.
DescribeOutputs This property is required. []GetStreamlitsStreamlitDescribeOutput
Holds the output of DESCRIBE STREAMLIT.
ShowOutputs This property is required. []GetStreamlitsStreamlitShowOutput
Holds the output of SHOW STREAMLITS.
describeOutputs This property is required. List<GetStreamlitsStreamlitDescribeOutput>
Holds the output of DESCRIBE STREAMLIT.
showOutputs This property is required. List<GetStreamlitsStreamlitShowOutput>
Holds the output of SHOW STREAMLITS.
describeOutputs This property is required. GetStreamlitsStreamlitDescribeOutput[]
Holds the output of DESCRIBE STREAMLIT.
showOutputs This property is required. GetStreamlitsStreamlitShowOutput[]
Holds the output of SHOW STREAMLITS.
describe_outputs This property is required. Sequence[GetStreamlitsStreamlitDescribeOutput]
Holds the output of DESCRIBE STREAMLIT.
show_outputs This property is required. Sequence[GetStreamlitsStreamlitShowOutput]
Holds the output of SHOW STREAMLITS.
describeOutputs This property is required. List<Property Map>
Holds the output of DESCRIBE STREAMLIT.
showOutputs This property is required. List<Property Map>
Holds the output of SHOW STREAMLITS.

GetStreamlitsStreamlitDescribeOutput

DefaultPackages This property is required. string
ExternalAccessIntegrations This property is required. List<string>
ExternalAccessSecrets This property is required. string
ImportUrls This property is required. List<string>
MainFile This property is required. string
Name This property is required. string
QueryWarehouse This property is required. string
RootLocation This property is required. string
Title This property is required. string
UrlId This property is required. string
UserPackages This property is required. List<string>
DefaultPackages This property is required. string
ExternalAccessIntegrations This property is required. []string
ExternalAccessSecrets This property is required. string
ImportUrls This property is required. []string
MainFile This property is required. string
Name This property is required. string
QueryWarehouse This property is required. string
RootLocation This property is required. string
Title This property is required. string
UrlId This property is required. string
UserPackages This property is required. []string
defaultPackages This property is required. String
externalAccessIntegrations This property is required. List<String>
externalAccessSecrets This property is required. String
importUrls This property is required. List<String>
mainFile This property is required. String
name This property is required. String
queryWarehouse This property is required. String
rootLocation This property is required. String
title This property is required. String
urlId This property is required. String
userPackages This property is required. List<String>
defaultPackages This property is required. string
externalAccessIntegrations This property is required. string[]
externalAccessSecrets This property is required. string
importUrls This property is required. string[]
mainFile This property is required. string
name This property is required. string
queryWarehouse This property is required. string
rootLocation This property is required. string
title This property is required. string
urlId This property is required. string
userPackages 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]
defaultPackages This property is required. String
externalAccessIntegrations This property is required. List<String>
externalAccessSecrets This property is required. String
importUrls This property is required. List<String>
mainFile This property is required. String
name This property is required. String
queryWarehouse This property is required. String
rootLocation This property is required. String
title This property is required. String
urlId This property is required. String
userPackages This property is required. List<String>

GetStreamlitsStreamlitShowOutput

Comment This property is required. string
CreatedOn This property is required. string
DatabaseName This property is required. string
Name This property is required. string
Owner This property is required. string
OwnerRoleType This property is required. string
QueryWarehouse This property is required. string
SchemaName This property is required. string
Title This property is required. string
UrlId This property is required. string
Comment This property is required. string
CreatedOn This property is required. string
DatabaseName This property is required. string
Name This property is required. string
Owner This property is required. string
OwnerRoleType This property is required. string
QueryWarehouse This property is required. string
SchemaName This property is required. string
Title This property is required. string
UrlId This property is required. string
comment This property is required. String
createdOn This property is required. String
databaseName This property is required. String
name This property is required. String
owner This property is required. String
ownerRoleType This property is required. String
queryWarehouse This property is required. String
schemaName This property is required. String
title This property is required. String
urlId This property is required. String
comment This property is required. string
createdOn This property is required. string
databaseName This property is required. string
name This property is required. string
owner This property is required. string
ownerRoleType This property is required. string
queryWarehouse This property is required. string
schemaName This property is required. string
title This property is required. string
urlId 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
createdOn This property is required. String
databaseName This property is required. String
name This property is required. String
owner This property is required. String
ownerRoleType This property is required. String
queryWarehouse This property is required. String
schemaName This property is required. String
title This property is required. String
urlId 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.
Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi