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

How to read and parse an array of tuples into a snowfklake table?

I am working with a source field which is in the form of an array of tuples [(a,145), (b,12), (c,63), (d,1), (e,54), (f,99), ...] I am unable to load this field into a variant type into snowflake. When I try to load this field, I get the following…
raghav8686
  • 1
0
votes
1 answer

Snowflake METADATA$FILENAME key word not working in snowsql (Unix cmd prompt) but working in snowflake UI

Snowflake code Working in UI copy into DWR_NA.GTR_STG.BASE_REF_CSV_STG (FILE_NM,ROW_NM,CSV_CONTENT,LOAD_STATUS) from (select METADATA$FILENAME as FILE_NM,METADATA$FILE_ROW_NUMBER as ROW_NM,$1as CSV_CONTENT, 'P' as LOAD_STATUS FROM…
Rajbharath
  • 13
  • 4
0
votes
0 answers

How to install snowflake cli on AIX Machine

I see there is documentation on how to download and install snowsql client on a linux machine. Are these steps same for AIX machine ?
munesh g
  • 1
0
votes
1 answer

How do I change the default colors in snowsql cli?

I'm using Windows putty with a colour scheme that works well for all of my work. In this case, I'm connecting to a unix o/s. The colours work fine in snowsql, except display of NULL values. I can't find ANY colours that work with snowsql's display…
Beege
  • 665
  • 4
  • 18
0
votes
2 answers

How to execute a query using snowsql cli client

I know this is basic. How do I run a query using snowsql cli client? I ran the connection line: snowsql -a my_account_name -u my_user_name i now see my_name#my_role@DatabaseName.(no schema)> i'm trying to run a query after that. But after I hit…
vbp13
  • 1,040
  • 1
  • 10
  • 20
0
votes
1 answer

Bulk load into Snowflake with Petnatho Data Integration over JDBC is slow

We have several on premise databases and then so far had also our data warehouse as on premise. Now moving over to the cloud and data warehouse will be in Snowflake. But we still have more on premise source systems than in the cloud, so would like…
user12761950
  • 139
  • 1
  • 2
  • 9
0
votes
2 answers

Can snowsql be configured to run a login.sql script and NOT exit?

[edit] now using snowsql Version: 1.2.10 When invoking snowsql with either the -q or -f options, a statement or sql file can be executed. In both of my test cases -- a statement or sql file -- they DO NOT contain an 'exit' yet snowsql exits the…
Beege
  • 665
  • 4
  • 18
0
votes
2 answers

invalid username and password snowsql

While login to snowflake from command prompt I'm getting the below error the error: 250001 (08001): Failed to connect to DB: EGA12345.us-east-1.snowflakecomputing.com:443. Incorrect username or password was specified. If the error message is…
Awara
  • 1
  • 4
0
votes
1 answer

How to call snowsql client from python

I'm calling snowsql client from shell script. I'm importing properties file by doing source. And invoking snowsql client. How can I do the same in Python? Any help would be highly appreciated. Shell script to call snowsql client: source…
marjun
  • 696
  • 5
  • 17
  • 30
0
votes
2 answers

In Snowsql, when I attempt to 'Put' a file I get the following error message:

"'put' is not recognized as an internal or external command, operable program or batch file." I am inputting the following: "put file://C:\FolderName\FileName.csv" All I need to do is upload a csv from my C drive to the Snowflake cloud. I figured…
Vincent_Adultman
  • 78
  • 11
0
votes
1 answer

SnowSQL Bad Handshake when running PUT

I am trying to PUT a file from local workstation to a named stage I created but getting an SSL error: ("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')],)",) I am able to run SELECT statements…
learningturtle
  • 128
  • 2
  • 2
  • 11
0
votes
0 answers

Snowflake Snowsql !source tab complete

Is there a way to enable tab or some other auto-complete when using Snowflake's Snowsql cli? I keep having to copy and paste the entire file path whenever running a script from the command line. [USER]#(Analytics_WH)@PROD.(data_white)>!source…
yoitsbenc
  • 1
  • 1
0
votes
1 answer

Nested window function not working in snowflake

I am working on migration of spark sql to snowsql. At one point i got a scenario where i have used nested window functions in spark sql. And i want to migrate that sql query into snowflake. But snowflake doesn't support nested window…
Prashant Rane
  • 35
  • 7
0
votes
1 answer

Sqitch deploy to snowflake DW fails

The Sqitch deploy command fails with below error:- sqitch deploy 'db:snowflake://amrutmonu:PASSWORD@wea87235.us-east-1.snowflakecomputing.com/DEMO_DB?Driver=Snowflake' error: Adding registry tables to…
Amrut Dengre
  • 1
0
votes
1 answer

How to get the data in snowflake for past 24 months in snowflake

I have the data for the current month in Snowflake which I am extracting with the below mentioned query select distinct HPOLICY , ANNUALPREMIUMAMOUNT , year(dateadd(year, 0, CURRENT_DATE)) ,…
Sains
  • 457
  • 1
  • 7
  • 19
1 2 3 4 5 6
7
8