Here is my sample data table :

Column A cat, dog, horse monkey, donkey cat, tree I need a way to return me the rows which matches the string ‘cat|ball|tree’. Here my expected output is TRUE for first and third row and false for second row as there is cat matching for the first row and cat and tree matching for the […]

I need to insert just 1 row of default values into a Snowflake table. I know the following command works on other types of databases:

I am working within a snowflake DB schema that has about 200 tables and I need to figure out which table has a specific row-level value within a column. Looking for any table that contains a value = “Alternative Credential” in the rows. I executed this, but it stopped working after the second run:

I had an issue when someone from my team recreated the table more than once using CREATE OR REPLACE as there were some new fields that had to be added. However, instead of adding a column using ALTER TABLE, the entire table was recreated.

I have a source table like below,

i have table in snowflake and with couple of duplicate records. For examle lets say i have table customer with column firname lastname and age

I have a table as shown below and I want to split list into new rows but when I follow snowflake lateral flatten in snowflake, rows are getting multiplied by number of columns that I am trying to flatten.

‘m trying to not use the LAST_QUERY_ID approach (which used in the 2nd snippet)

I have a set of data which has some dates of the week, I need to extract the next Friday date from the data and if the date is already on Friday then print the same date. I have tried multiple sources but one or the other error comes. I need to output on snowflake.