'Snowflake query unable to display underscore in alias name

So I was writing a Snowflake query

select col1, col2 as col_2 from table;

In the resultant table, the alias 'col_2' comes as 'col 2', i.e without underscore. I know the questions is stupid but my poor googling skills gave no fruitful result.

mysqlsqlsnowflake-cloud-data-platform


Solution 1:[1]

Answering for completeness. This "bug" appears to be fixed:

SELECT $2 as col_2
FROM "SNOWFLAKE_SAMPLE_DATA"."TPCH_SF100"."REGION"

## COL_2
## AFRICA
## AMERICA
## ASIA
## EUROPE
## MIDDLE EAST

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Simeon Pilgrim

Related Questions