Migrating from Regular to Big Tables - some tips & advice

I’d be interested in hearing more about any and all workarounds you have employed for Big Table limitations. The structure of the app I’m attempting to convert is not even close to workable within the allowed columns. Also, the video in this post won’t play for me and I’m keen to learn about this approach.