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
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive