Hi, @rudra prasad biswas For this use case, consider a few different approaches: 1. Use a single array type "stoppage" column which stores each stop as a JSON element. To query for records where the last stoppage was NY, use something like "where stoppage[array_length(stoppage)-1] = 'New York". 2. Continue using dynamic columns, but include an additional column "stoppage_count" which you increment for each additional stoppage. You can use stoppage_count to tell your application which dynamic columns to include in the query. 3. Use a relational model where you have records of trips, and another table with "stoppages" linked to the trip ID. However, the above approaches assume your queries have an initial access pattern limiting the size of the scan. Assuming your table has primary key of customer_id, trip_id, you DON'T want to run a query like: select * from trips where stoppages[array_length(stoppages)-1] = 'New York' because it would be a full scan. Instead, you want it to be something like: select * from (
select * from trips where customer_id = '1234'
) a
where stoppages[array_length(stoppages)-1] = 'New York' which would be a much smaller range scan.
... View more
