Need help with defining cassandra schema.
I want to store data coming from api (vendorname, productID, price, datestamp). Price for one product could be from different vendors.
There we have 2 tables:
1. Time series data (must be wide row) ProductID should be as row key, we store vendorname, price and datestamp here, as shown in file attached.
2. Last values. Here we have columns with all vendors that we have with the last known prices ( last update (insert)).
I need just schema with commands to create tables, db is up and running.