Automation enables you to schedule the regular update of a published dataset. This feature removes the need to manually import, normalise and publish a new version of the same dataset.
You can use automation to update a dataset using a connector, such as to MySQL, S3 or Google Cloud Storage. You cannot automate the import of a file from your computer, such as a CSV file.
Automation uses the three types of dataset state:
- A candidate dataset is a dataset which is either being imported, or has been imported but hasn't been published.
- A published dataset is the dataset which will be analysed when referenced in all subsequent queries.
- A background dataset is a dataset which was previously published and was replaced by a newer dataset, but may still be queried if a query was initiated before the newer dataset was published.