Sample smart meter data
If you want to practice querying time series data before you define and load your time series, you can use the sample data in the stores_demo database.
The following tables
in the stores_demo database contain time series data based
on electricity usage data collected by smart meters:
- Customer_ts_data
- Contains customer numbers and location references.
- ts_data_location
- Contains spatial location information.
- ts_data
- Contains location references and smart meter time series data.
- ts_data_v
- Contains the data in the ts_data table in relational format as a virtual table.
The time series data is stored in a container named raw_container.