I need to set week start from sunday as default in snowflake i used alter session set WEEK_START = 7; when querying in snowflake worksheet it works fine but wh
I'm trying to get a hash of a decimal value and convert it to an integer. But the query results in the following error: Numeric value 'b902cc4550838229a710bfec4
Quick Note, I have reviewed these threads and they do not fix my issue: ( Outdated info, see documentation below ) Access Snowflake query results through PowerB
I have the following output: Orderid Time State Order_rank 1 10.15 mfr 1 1 10.15 delivered 1 2 12.10 picked 1 2 12.10 mfr 1 Here I have ranked the order ids w
I've just gotten a new query error that I haven't changed anything to. Any advice on what to do? Thanks SQL compilation error: View definition for '**********'
I am using the following query to retrieve query history from my Snowflake database. SELECT * FROM table(MY_DATABASE.information_schema.query_history( end_tim
I would like to upload data into snowflake table. The snowflake table has a primary key field with AUTOINCREMENT. When I tried to upload data into snowflake wi
I read through snowflake documentation and the web and found only one solution to my problem by https://stackoverflow.com/users/12756381/greg-pavlik which can b
I love how the SHOW TABLES query return the rows and the bytes for each table listed, but unfortunately, that's not the case for the SHOW SCHEMAS query. What's
I am trying to load a csv file from my windows system to snowflake internal stage using snowsql. Command : PUT file://C:\Test_Data\Orders_1.csv @CSVSTAGE1; Erro
I was wondering if Snowflake can directly connect to API and load the data into Snowflake Schema tables ? If yes, can you please guide me the process ? I am new
I am trying to stage xml data from S3 into snowflake. I have successfully created the stage, while querying the data I am getting below given error, upon checki
Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don't have access to that bucket. And we only need to ge
I am querying metadata on Snowflake which contains a column of queries: select query_name from metadata query_name SELECT * FROM SYSIBM.SQLCOLUMNS SELECT * FR
I'm trying to delete rows from table using delete. delete a from "table1" as a LEFT JOIN "table2" AS b on a."x" = b."x" where b."X" = 'X' but everything I ge
I have a use case where I have different versions of files in the AWS S3 Stage area. Now I want to read a specific version of these files and load them in snowf
Classic Snowflake Web UI and the new Snowsight are great at importing sql from a file but neither allows you to export sql to a file. Is there a workaround?
I have an issue where I kind of know what it is but do not know the solution to it. When I fetch data from an external Snowflake DB, it limits the size of the d
Can we grant direct select or insert access( with out creating a role ) to a user on a table ?
This is rather a clarification than a question itself. I have a parent role named temp_parent_role which has two child role temp_role and temp_role_2. Now I hav