DESCRIBE STREAMLIT¶

描述 Streamlit 对象中的列。

DESCRIBE 可以缩写为 DESC。

另请参阅：: CREATE STREAMLIT、SHOW STREAMLITS、ALTER STREAMLIT、DROP STREAMLIT

语法¶

DESC[RIBE] STREAMLIT <name>

Copy

必填参数¶

name: 指定要描述的 Streamlit 对象的标识符。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

Access control requirements¶

If your role does not own the objects in the following table, then your role must have the listed privileges on those objects:

Privilege	Object
USAGE	Streamlit object that you describe

The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema. Note that a role granted any privilege on a schema allows that role to resolve the schema. For example, a role granted CREATE privilege on a schema can create objects on that schema without also having USAGE granted on that schema.

For instructions on creating a custom role with a specified set of privileges, see 创建自定义角色.

For general information about roles and privilege grants for performing SQL actions on securable objects, see 访问控制概述.

使用说明¶

To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.

输出¶

命令输出在以下列中提供有关 Streamlit 对象的信息：

列	描述
`title`	Title of the Streamlit object that displays in Snowsight.
`main_file`	Name of the Streamlit app's entrypoint file.
`query_warehouse`	Warehouse where queries issued by the Streamlit app are run.
`url_id`	与 Streamlit 对象关联的唯一 ID。
`default_packages`	Streamlit 应用程序的默认 Python 软件包。
`user_packages`	Python packages that the user specified in the `environment.yml` file. This is empty if there is no `environment.yml` file.
`import_urls`	List of URLs that the Streamlit app imports.
`external_access_integrations`	List of external access integrations associated with the Streamlit object.
`external_access_secrets`	List of external access secrets associated with the Streamlit object.
`name`	Unique name of the Streamlit object within its schema.
`comment`	Comment associated with the Streamlit object.
`default_version`	Default version of the Streamlit object to use when there is no live version. If your app doesn't already have a live version and the owner opens the app on Snowsight, this is the version that is copied to the live version.
`default_version_name`	Name of the default version directory within the Streamlit object's file system.
`default_version_alias`	Unsupported and always null.
`default_version_location_uri`	Location URI of the default version's app files. This is read only.
`default_version_source_location_uri`	Location URI of the default version's source files in its Git object. If the Streamlit object is not connected to a Git object, this is null.
`default_version_git_commit_hash`	Git commit hash of the default version of the Streamlit object. If the Streamlit object is not connected to a Git object, this is null.
`last_version_name`	Name of the last version directory within the Streamlit object's file system.
`last_version_alias`	Unsupported and always null.
`last_version_location_uri`	Location URI of the last version's app files. This is read only.
`last_version_source_location_uri`	Location URI of the last version's source files in its Git object. If the Streamlit object is not connected to a Git object, this is null.
`last_version_git_commit_hash`	Git commit hash of the last version of the Streamlit object. If the Streamlit object is not connected to a Git object, this is null.
`live_version_location_uri`	Location URI of the live version of the Streamlit object. This location is readable and writable. Edits in Snowsight are saved in this location. You can remotely update a live app by copying files to this location.

For Streamlit objects created using the ROOT_LOCATION parameter, the command output provides information in the following columns:

列	描述
`name`	Unique name of the Streamlit object within its schema.
`title`	Title of the Stramlit object that displays in Snowsight.
`root_location`	Streamlit 对象文件的位置。
`main_file`	Path to the Streamlit app's entrypoint file, relative to the root location.
`query_warehouse`	Warehouse where queries issued by the Streamlit app are run.
`url_id`	与 Streamlit 对象关联的唯一 ID。
`default_packages`	Default Python packages for the Streamlit app.
`user_packages`	Python packages that the user specified in the `environment.yml` file. This is empty if there is no `environment.yml` file.
`import_urls`	List of URLs that the Streamlit app imports.
`external_access_integrations`	List of external access integrations associated with the Streamlit object.
`external_access_secrets`	List of external access secrets associated with the Streamlit object.