Stack Overflow
Stack Overflow

Questions tagged [snowsql]

SnowSQL is a command line tool for connecting to the Snowflake analytic data warehouse which is a Software-as-a-Service (SaaS) product.

SnowSQL is the next-generation command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.

Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). Snowflake provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouse offerings.

Link to documentation and more information

110 questions
0
votes
1 answer

Table Aliases into Subqueries

(Submitting here to assist other Snowflake Users who may run into similar challenges... Interested to see if there are any additional recommendations beyond what's bee provided already.) Why doesn't table alias work into subqueries? I was using a…
Gavin Wilson
  • 482
  • 9
  • 25
0
votes
2 answers

Merge or Combine Multiple Rows Records to Single Column Record with Comma delimiters SNOWSQL

I know this question has been asked before here, but for SNOWSQL in particular, is there a function similar to 'STUFF' to combine two values into a single record? I basically want to be able to use this query: SELECT ISSUE_ID, …
Emily P
  • 1
  • 1
0
votes
0 answers

error on column mismatch option not working in snowsql

i am loading a CSV file with has '|' as delimiter. the CSV file has 22 records in one line and 25 in other line . but my table is only has 18 column . i am facing issue like " Field delimiter '|' found while expecting record delimiter '\n' ".i have…
Mukesh Gupta
  • 101
  • 1
  • 1
  • 6
0
votes
1 answer

I keep getting a unexpected select error in my snosql statement

I keep getting an unexpected select error as well as an unexpected ON error in rows 61 AND 64 in my snowsql statement. Not sure why if anyone can help that would be great. I've added the portion of my snowsql statement below. I'm trying to use a…
2tone_tony
  • 47
  • 1
  • 10
0
votes
0 answers

snowflake - How to use a file format to decode a csv column?

I've got some data in a string column that is in a strange csv format. I can write a file format that correctly interprets it. How do I use my file format against data that has already been imported? create table test_table ( my_csv_column…
Neil P
  • 2,920
  • 5
  • 33
  • 64
1 2 3 4 5 6 7
8