hello, In the big table schema design, the keyvisualizer resources are missing in the lecture. <could you add it please?
Also could you explain a bit the salting principle?
Thanks
1 Answers
Hi Wissek,
My bad! Thanks for pointing that out, I’ve now added the missing link to the video where Twitter discuss using the key visualizer for their analytics Bigtable instances.
With regard to salting, this is a method you can use if you have no other keys or identifiers you can use to construct a key that will ensure your rows are evenly spread throughout a table. Using salted hashes essentially gives you a random distribution of keys to spread the load. It’s a last resort of sorts if you can’t promote any fields of your data to create a good key design. There’s some more info on using salting to avoid hotspots here: https://cloud.google.com/bigtable/docs/schema-design-time-series#ensure_that_your_row_key_avoids_hotspotting
Hope that helps!