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.
1 -
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
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive