Data Table Best Practices
In many situations, it may not be clear when to use a data table (versus a stream or Thing properties). Use the following guidelines:
If you need to manipulate the data (even query) row by row, use a data table.
If the data is a static lookup table, use a data table.
If you have data that will not change, or will be overwritten the next time it is changed/loaded, and it is associated with a thing, create an infotable property for that Thing and assign the proper Data Shape. This way, the access to the data is through the Thing, which is logical if it is Thing-related data.
If it is time-series data, use a stream.
Related Links