How to Automatically Delete and Backfill a Datasource on Schedule
Overview
This app will automate the manual process of deleting and refilling your datasources. This app can be set on a schedule and be set to delete and backfill for either today, the last 7 days or the last 30 days.
Instructions
From the left hand side navigation, select Browse. This will show a list of available templates you can use.
Select any templates to see a description, when it was last updated, how many active installs it has across Marketplace, as well as any prerequisites or set-up instructions.
Search for “delete and backfill datasource” and click the plus button on the app template.
Click on “Install App”
Add in your datasource id and the date range
When scheduled, it will update based on the designated date range, starting from the moment the scheduled run is activated. For instance, if you configure it to cover the previous week and set it to run on a weekly basis, it will consistently process data for the seven days leading up to its scheduled runtime
Once you have completed your inputs, you can either
Save
orSave and Run
your app.Save and Run
will kick off an immediate execution of the app, and you can QA the app while it is running, or after it is completed using the instructions found in How to QA your app, orSave
will save your inputs, and your app will run at the next scheduled time you set up in your schedule.
When scheduled, it will update based on the designated date range, starting from the moment the scheduled run is activated. For instance, if you configure it to cover the previous week and set it to run on a weekly basis, it will consistently process data for the seven days leading up to its scheduled runtime.
Related articles
- How to enable Big Query for a custom alert
- How to name Datasource Columns
- How to manually upload data to an existing datasource
- How to archive and unarchive data sources
- How to create a manual datasource without validations
- How to setup a datasource that requires custom data
- How to Create a new datasource
- How to update datasource dimensions and metrics
- How to create a Smartsheet Datasource
- How to add a manual upload datasource