3

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.

1 Answers1

0

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
Simeon Pilgrim
  • 22,906
  • 3
  • 32
  • 45
Robert Long
  • 5,722
  • 5
  • 29
  • 50