I am trying to find the count of tables present in CDC schema, I tried with information_schema but the information_schema is empty for me.
how to delete the duplicate records from snowflake table. Thanks ID Name 1 Apple 1 Apple 2 Apple 3 Orange 3 Orange Result should be: ID Name 1 Apple 2
I am receiving the below error while trying to connect to Snowflake via Jitterbit cloud studio: Error Error Code: snowflake07 Stacktrace: Error executin
I am trying to use snowpark(0.6.0) via Jupiter notebooks(after installing Scala almond kernel). I am using Windows laptop. Had to change the examples here a b
I'm trying to get snowsql working locally on my machine but I cannot log into my database because it requires that I authenticate with my google account for SSO
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
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
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
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
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
[ { "itemId": "HWKDVCXKU5", "name": "A", "quantity": 1.000000000000000e+00, "storeId": 1.150192000000000e+06, "type": "structure" },
I am trying to connect to snowflake using my login credentials. I'm using the following code: snowflake.connector.connect( user="<my_user_name>",
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
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
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