snow helpers check-snowsql-env-vars

检查是否设置了任何 SnowSQL 环境变量集。

语法

snow helpers check-snowsql-env-vars
  --format <format>
  --verbose
  --debug
  --silent
  --enhanced-exit-codes
  --decimal-precision <decimal_precision>

实参

无

选项

--format [TABLE%JSON%JSON_EXT|CSV]

指定输出格式。默认：TABLE。

--verbose, -v

Displays log entries for log levels info and higher. Default: False.

--debug

Displays log entries for log levels debug and higher; debug logs contain additional information. Default: False.

--silent

关闭到控制台的中间输出。默认值：False。

--enhanced-exit-codes

根据错误类型区分退出错误代码。默认值：False。

--decimal-precision INTEGER

Number of decimal places to display for decimal values. Uses Python’s default precision if not specified. [env var: SNOWFLAKE_DECIMAL_PRECISION].

--help

Displays the help text for this command.

使用说明

This command helps you migrate from SnowSQL to Snowflake CLI by identifying your SnowSQL environment variables and mapping them to the corresponding Snowflake CLI environment variables. It displays information with suggested changes and links to documentation.

示例

此示例假设用户已定义以下环境变量：

  • SNOWSQL_USER: Username for the connection.
  • SNOWSQL_ROLE: Role for the connection.
  • SNOWSQL_UNUSED: Variable not used in Snowflake CLI.
snow helpers check-snowsql-env-vars
+--------------------------------------------------------------------------------------------------------------------------------------------+
| Found        | Suggested      | Additional info                                                                                            |
|--------------+----------------+------------------------------------------------------------------------------------------------------------|
| SNOWSQL_USER | SNOWFLAKE_USER | https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#use-environme |
|              |                | nt-variables-for-snowflake-credentials                                                                     |
| SNOWSQL_ROLE | SNOWFLAKE_ROLE | https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#use-environme |
|              |                | nt-variables-for-snowflake-credentials                                                                     |
+--------------------------------------------------------------------------------------------------------------------------------------------+

+----------------------------------------------+
| Found          | Suggested | Additional info |
|----------------+-----------+-----------------|
| SNOWSQL_UNUSED | n/a       | Unused variable |
+----------------------------------------------+

Found 3 SnowSQL environment variables, 2 with replacements, 1 unused.