Database Refresh Frequency

Last modified: March 23, 2022

This article discusses how data can be uploaded to Auto Insights at your desired frequency (daily, weekly, monthly, yearly).

In order to make the data ingestion process as easy as possible, Auto Insights supports a direct connection with databases using ODBC connectors. The direct connection means that you can schedule your data to be uploaded to Auto Insights automatically. Auto Insights currently supports the following batch job frequencies*: 

  • Daily

  • Weekly

  • Monthly

  • Yearly

* Event-based (near real-time) or Streaming (real-time) is not supported.

Using this method, your entire dataset will be uploaded to Auto Insights at each refresh, (rather than incremental data) in order to ensure accuracy and quality. This also allows Auto Insights to analyze historical patterns and trends across your data.

To set up your dataset refresh schedule, follow the steps below. Please make sure you have read the Uploading Data and How do I connect to a database? guides before reading on.

1. From the Admin Portal, click on Datasets in the menu bar.

2. Click on the name of your dataset from the available datasets in the left-hand menu.

3. Click on the Repeat dropdown to adjust the frequency of the dataset refresh. You can also adjust the time the refresh occurs. Click Save once you have adjusted the settings as desired.

 

dataset refresh

Alternatively, you can upload data to Auto Insights via .csv files as frequently as you like.

 

Related articles
How do I upload data?
How do I connect to a database?
How do I upload a .csv file?

 

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.