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.