Advertisements So, I have dataset that looks like below. I would like to write a query that extract users who have done steps 1,2 & 3 but not 4 & 5. The output of the query should be User 1 and User 4. User_ID Steps User 1 Step 1 User 1 Step 2 User 1… Read More How to not select user_ids that have not performed certain actions (Snowflake SQL)
Advertisements I have a string in a column like this. I have 2 pets. One is "CAT" and "DOG". I wanted to extract my output as "CAT" and "DOG". Which is the beginning of double quotes to end of double quotes. How can I achieve this using snowflake SQL >Solution : Something like this works:… Read More Snowflake SQL – how to extract words from a string
Advertisements I want to know what is the 1st and the 2nd page (and so on) visited by a user in a session. I already managed to get the flow of interaction through the row_n function. However, I want a column with the flow of the interaction, but, taking the following example, instead of 2… Read More How can I have 1 line per id, instead of 2 in snowflake?
Advertisements I have a Snowflake SQL stored procedure from where I’m trying to call the SYSTEM$SEND_EMAIL function, but its erroring out as below: `create or replace procedure testsproc() RETURNS VARCHAR language sql as $$ BEGIN SELECT * FROM non_existent_table; EXCEPTION WHEN OTHER THEN LET LINE := SQLCODE || ‘: ‘ || SQLERRM; INSERT INTO myexception… Read More Snowflake – Getting invalid identifier error while passing variables between SQL Stored Procs
Advertisements I have a table in Snowflake generated like: create or replace temporary table example (asset_id int, assignment_id int); insert into example (asset_id, assignment_id) values (5000, 1), (5000, 1), (5000, 1), (6000, 1), (6000, 2); select asset_id, assignment_id, uuid_string(uuid_string(), md5(concat(asset_id, assignment_id))) as uuid_assignment from example; I’d like to generate a uuid_string() for the combination of… Read More Generating UUID off Md5 Hash in Snowflake
Advertisements I have a table looks like this CREATE TABLE myTable ( userid text, webid text, "timestamp" timestamp ); INSERT INTO myTable ("userid", "webid", "timestamp") VALUES (‘A’, ’34’, ‘2023-01-31 17:34:49.000’), (‘A’, ’73’, ‘2023-01-31 17:34:50.000’), (‘A’, ’97’, ‘2023-01-31 17:34:58.000’), (‘A’, ’17’, ‘2023-01-31 17:35:02.000’), (‘A’, ’17’, ‘2023-01-31 17:35:07.000’), (‘A’, ’17’, ‘2023-01-31 17:35:18.000’), (‘A’, ’17’, ‘2023-01-31 17:35:30.000’), (‘A’,… Read More how to get 1st column value using partition
Advertisements I am using python connector and ingesting some big data into a table. Now i want to get the query history details like How can i get the bytes scanned and total duration form the history knowing the query id of the query. the below is the python code import snowflake import snowflake.connector con… Read More snowflake: using query id, how to get the details of the
Advertisements I am trying to understand why the group by function is yielding different results in snowflake depending on how I reference the group-by fields. Here are two Queries that I believe should yield the same result, but do NOT: Query using explicit field alias references: select hash(‘SHA2_256’, CONCAT(‘field1′,’field2′,’field3′,’field4’)) as hash ,field1 ,field2 ,field3 ,field4… Read More Snowflake SQL group-by behaving differently depending whether columns are referenced by position or alias
Advertisements I have a table table_A ID EMP 1 9999 1 1 2 9999 2 2 2 3 3 9999 3 9999 3 4 3 4 3 4 4 9999 4 9999 4 9999 5 5 5 6 I want the records where where emp <> 9999 but this case should be satisfied not for… Read More How to find the unmatched records where only partial records matches the conditions?
Advertisements I have a table named Posts I would like to count and profile in Snowflake using the current Snowsight UI. When I return the results via EXPLAIN using TABLULAR I am able to return the set with the combination of TABLE, RESULT_SCAN, and LAST_QUERY_ID functions, but any predicate or filter or column reference seems… Read More How can you filter Snowflake EXPLAIN AS TABULAR syntax when its embedded in the TABLE function? Can you filter it with anything?