Sometimes I have access to schemas with hundreds of views (when using the Snowflake Data Marketplace). How can I find the number of rows for each of these views
I am doing POC on Snowflake and exploring this product. I have a question: in SQL Server, we have 400-500 stored procedures and these stored procedures are get
Could you help me? I don't know how to get the result. I have to prepare the export file to the customer by strict structure from Snowflake. I suppose that the
Do we have any function for name fuzzy matching like we have UTL_MATCHING.EDIT_DISTANCE_SIMILARITY in oracle. I have to find the difference at row level.
When I run the below query from snowflake web UI, Here is the error message: select ROWS from "SNOWFLAKE"."ACCOUNT_USAGE"."METERING_HISTORY"; SQL compilation e
when I was adding primary key to snowflake table I saw something weird. When I ran a query ALTER TABLE "TESTSCHEMA".table1 ADD PRIMARY KEY (ID); Above query wo
I am trying to partition the data from a Snowflake table and storing it as a parquet file in a S3 bucket. This partition allows me to store the data organised b
I'm trying to integrate Azure Active Directory with Snowflake. I've set everything up as instructed in this document : https://docs.microsoft.com/en-us/azure/ac
I have two tables. Transaction(ID, TERMINALID) and Terminal(ID, TERMINALID, EXPORT_DATE). The goal is to obtain for each row from Transaction table newest recor
I am looking to shift out of Postgres to SnowFlake as some of my features require run time analysis which is faster in Snowflake. I could only get the Python c
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