Add a Datasource to Presto to Connect to the Database
If you do not already have a datasource defined in Presto for the database containing the data you want to work with, have your Presto administrator add one.
The example shown in this topic is from a MySQL database with machine sensor data. Every half second various readings are added to this database for different devices. The dataset, shown below in XML format, includes the value (data_value) for a reading, a code (data_item_id) for the type of reading, a code for the device (device_id) and both a timestamp and a date/time in milliseconds when the reading was taken.