embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

Wrong format of output in `SHOW DATABASES`

Open YaroslavLitvinov opened this issue 4 months ago • 2 comments

In Embucket show databases

Embucket assumes TERSE option is specified when it wasn't ~It seems format of output is taken from show schemas statement, which is irrelevant for databases~

+------------------------------------------------------------------------------+
| created_on | name                   | kind     | database_name | schema_name |
|------------+------------------------+----------+---------------+-------------|

In Snowflake show databases

+------------------------------------------------------------------------------+
|      |      |     |      |     |      |     |      | ret |      | own | obje |
|      |      | is_ |      |     |      |     |      | ent |      | er_ | ct_v |
| crea |      | def | is_c |     |      | com |      | ion |      | rol | isib |
| ted_ |      | aul | urre | ori | owne | men | opti | _ti |      | e_t | ilit |
| on   | name | t   | nt   | gin | r    | t   | ons  | me  | kind | ype | y    |
|------+------+-----+------+-----+------+-----+------+-----+------+-----+------|

YaroslavLitvinov avatar Aug 05 '25 14:08 YaroslavLitvinov

https://docs.snowflake.com/en/sql-reference/sql/show-databases

TERSE
Optionally returns output containing only the following columns:
created_on
name
kind
database_name
schema_name
Note that kind, database_name, and schema_name always display NULL because the columns are not applicable for databases.
Default: No value (all columns are included in the output)

This list of colums is used by snowflake connector

osipovartem avatar Aug 05 '25 15:08 osipovartem

@osipovartem I didn't specify TERSE in query, so if this option is enabled by default in Embucket we should state it somehow.

YaroslavLitvinov avatar Aug 05 '25 15:08 YaroslavLitvinov