Export Time Series Data
Requires Customer/Partner License
Intermediate
30 min.
Export time series data and derived data to a file format GZIP, so that the data can be used as is without any need for de-serialization logic.
You will learn
- How to initiate time series data export
- How to download the
.csv
file - How to import data into a table using SAP HANA Database Explorer
- How to execute SQL query on the time series data
Prerequisites
- Your tenant is onboarded in or after SAP IoT 2010b release.
- You created an application and a device model.
- You have onboarded (virtual) devices and have enabled them to send data with timestamps over a period of several days or weeks.
- For testing purpose, you can ingest data for a week so that you have a considerable amount of data for further analysis.
For data analytics or machine learning scenarios, there is a need to extract time series data for a longer duration spanning across multiple months or years. You can export time series data and derived data to a file format GZIP, so that the data can be used as is without any need for de-serialization logic.