I have a query like below where i look at status of my table execution status. Where i need to search for last 7 days of executions status and for next day based on current date. I want my date filter to be dynamic based on current date. Currently i am using a static filter. But looking to do this dynamically. Any suggestions. I tried with CURRENT_TIMESTAMP function but format what i am looking is different because i need to filter very specifically for 7am for dates filter always

I have a table like below.

I have a table in snowflake as below:

I am looking to retrieve the first “Sales_Date” for each “Account_ID”, however in my dataset there are entries where the first sales is actually not a sales as the product transacted is a sample and thus $0 revenue. For those entries I would like to skip it and take the next Sales Date as the first “Sales_Date”. I have attempted the below query but run into the issue where some transactions may contain both a sample and a actual product in the same transaction. This results in duplicate rows with the same Account_ID being retrieved in the output. I am not sure how to change the query to resolve this and get the “Desired Output” below.

I have a dataset that I need to work with, every month a new set of columns are added with various names but have the month and year in the middle of the column name. I.e.

Assuming the default status is always “Released” and given a table that contains history of actions taken:

In snowflake, how can I declare variables to make the this CTE calendar table dynamic?

I have a table and within that in a specific column, i need to find out the records which are having characters anything except an alphabets or numbers.
I tried using regex as
‘[^A-Za-z0-9 ]’

I figured I could easily create a basic data dictionary of the schema my team is working out of. I currently have this:

Hi how would I sum the following by the JSON variant column attributes?