Add Data that has been modified in the last 7 days
I have a snowflake dataset that has a modified date column. I want to merge the data that has been modified in the last 7 days to the dataset. Sometimes an order is modified after its placed and we want to capture the new values of the order.
I have used this query but its not working
SELECT * FROM "TABLE" WHERE "ORDER_MODIFIED_TIME" > SUBDATE(CURDATE(), interval 7 day)
Any help would be appreciated
Comments
-
At first glance, that seems like it should work. What is the data type for
ORDER_MODIFIED_TIME
?I think you need to use the back tick ` instead of a double quote " as well.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
ORDER_MODIFIED_TIME is in a date time format (yyyy-mm-dd hh:mm:ss) .
I will try using the back tick too.
0 -
Is the problem that you're getting an error, or is the where clause not working as expected?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 -
I have run it with a few different variations of this query so I have gotten a few errors.
- CURDATE is not a valid function
- Unexpected value of '7', meaning the 7 day interval
- Invalid identifier with 'interval'
- Unexpected with 'day'
I have tried variations with a BETWEEN function, ADDDATE, SUBDATE and GETDATE
0 -
Are you running this query outside of Domo, or are you using it somewhere in Magic ETL?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 -
This is as I am pulling the data from snowflake to Domo. In the dataset configuration within Domo
0 -
Snowflake has a bit different syntax. Try something like:
SELECT * FROM "TABLE" WHERE "ORDER_MODIFIED_TIME" > CURENT_DATE() - interval '7 day'
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
That seems to have worked! Thank you!
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive