Scheduling Data in Socrata

Formerly the article for Scheduling Data Imported from URL.

With the Socrata Data Management Experience, comes the ability to schedule data updates for datasets that were created by importing from a URL and datasets that are connected through Socrata Gateway

Watch a short video on this process here: How to Automate Data from a URL

Creating a Scheduled Update

Once a dataset that is created from url or is set up to be updated through Gateway has been published, access the Primer page and select the Schedule Updates option.

Pasted_Image_8_20_19__2_00_PM.png

For datasets imported by URL this will open a modal where you can configure the frequency of update in days, the time of day the update will occur, a run now option, and the import URL of the source data.

mceclip1.png

 

For a Gateway connection, you will have the same options for run now, frequency and time of day, as well as the details for the Agent, Plugin, and data source of the source data. Like datasets imported from url, there will also be a link to change the data source of the Gateway connection.

mceclip2.png

Editing a Scheduled Update

After scheduling has been setup, you can use the same steps as the above to access and edit it. In addition to the time of day, frequency, and source data, you will also be able to pause/resume or delete an existing schedule.

mceclip0.png

Updating the Source

To update the URL used, select change url or change datasource settings from the Schedule Automation for URL Datasets modal. This will open a draft of the dataset where a new source can be configured. From there, you can apply additional changes to the dataset such as display formatting, transforms, etc. Once the draft is published, the updated Source of the dataset will be used on the next scheduled run.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.