embucket-labs
embucket-labs copied to clipboard
Wrong format of output in `SHOW DATABASES`
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 |
|------+------+-----+------+-----+------+-----+------+-----+------+-----+------|
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 I didn't specify TERSE in query, so if this option is enabled by default in Embucket we should state it somehow.