Google Certified Professional Data Engineer

Sign Up Free or Log In to participate!


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?


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:

Hope that helps!

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?