SNOWFLAKE querying column name with Spaces

Question

I am trying to use agg functions to query data, I have space in the column name in SNOWFLAKE

select item, avg(item price) from order group by item;

The error is

Numerical value '1212.11' is not recognized

Expected output is

Code which gives item and avg price of that item

Why not alter the table to fix the column name instead?

Rajat
– Rajat

2023-01-31 19:14:00 +00:00
Commented Jan 31, 2023 at 19:14 — Rajat
– Rajat, Commented Jan 31, 2023 at 19:14

sprethepa · Accepted Answer · 2023-01-31 05:32:46Z

1

Try

select item, try_to_number(avg("item price")) from order group by item;

edited Jan 31, 2023 at 5:32

answered Jan 31, 2023 at 4:30

sprethepa

8155 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adrian White · Accepted Answer · 2023-01-31 05:41:53Z

If you try add " (double quotes) around the column name does that help?

select item, avg("item price"::INT) from order group by item;

The ::INT just casts it to a datatype that can be summed. You should take a peak at the datatypes available to find one that best suits your needs. (2 dp might be good for currency)

Another possibility is :

select item, avg( price ) from order group by item;

That's if you don't have a column called "item price" rather 2 columns "item" and "price".

Collectives™ on Stack Overflow

SNOWFLAKE querying column name with Spaces

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related