Appending snapshot data to historical dataset
I am attempting to schedule a dataflow to append the week's data to a historical dataset which contains the previous week's history. The auto-updating dataset, call it: "projects_prod_daily" runs everyday as a replace data update. The historical dataset, let's call it: "projects_append_weekly" contains a history we manually appended in the past. I also created a connector to the USGS Earthquake data which runs on Saturday mornings, called: "recursive_trigger_weekly".
Using a MySQL dataflow, the following queries are what I created to achieve the desired result:
Transform 1:
SELECT
*,
DATE_FORMAT(CURRENT_DATE, "%m/%d/%Y") AS `Date`
FROM projects_prod_daily
Transform 2:
SELECT
*,
STR_TO_DATE(`Date`, "%m/%d/%Y") AS `Date`
FROM projects_append_weekly
UNION ALL
SELECT
*
FROM pull_updated_status_data
My question is: If I initially created the "projects_append_weekly" in a separate dataflow but use the queries listed above to create an output dataset with the same name, will the data continue to append the last week's updates automatically over time?
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive