Category "snowflake-cloud-data-platform"

Error while working on Automation Grant Access to database views / tables in snowflake schema

I have a stored procedure to grant access to the Snowflake database table / views, the procedure compiled successfully but getting the below error while executi

Translating an Excel concept into SQL

Let's say I have the following range in Excel named MyRange: This isn't a table by any means, it's more a collection of Variant values entered into cells. Exce

Unpivot multiple columns in Snowflake

I have a table that looks as follows: I need to unpivot the Rating and the Comments as follows: What is the best way to do this in Snowflake? Note: there are

Execute Multiple SQL Insert Statements in parallel in Snowflake

I have a question about how it works when several SQL statements are executed in parallel in Snowflake. For example, if I execute 10 insert statements on 10 dif

converting string to date using TO_DATE for MM/DD/YY gives wrong values for dates before 1970 [snowflake-cloud-data-platform]

Trying to convert a date string 03/31/69 to 1969-03-31 standard date format using TO_DATE function. SELECT TO_DATE('03/31/69', 'MM/DD/YY'); Expected value was

How to parse the following JSON to retrieve the name of the item in snowflake sql?

[ { "itemId": "HWKDVCXKU5", "name": "A", "quantity": 1.000000000000000e+00, "storeId": 1.150192000000000e+06, "type": "structure" },

OperationalError: 250003: Failed to get the response. Hanging? method: post

I am trying to connect to snowflake using my login credentials. I'm using the following code: snowflake.connector.connect( user="<my_user_name>",

How to Connect with Dbeaver on Snowflake (DUO Push)

I am using Duo Mobile for authentication in snowflake . I have entered username and password and warehouse details in Dbeaver. But I keep getting error "DUO P

Easter / Good Friday for Sowflake Date Dim

Further Evolved : The code below satisfies what was wanted in earlier comments [if you follow history] :), my new question right below is stumping me. Question

HHH000339: Could not obtain connection metadata net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException

Getting exception in spring boot while connecting snowflake:** ```2021-12-22 17:14:24.956 WARN 43624 --- [ main] o.h.e.j.e.i.JdbcEnvironmentInitiator