I was hoping for a big speed/reliability boost when we switched to BigQuery. I have two very large tables and a pretty involved app, I admit, but I haven’t seen a big difference in sync times. I use security filters, also. The big payoff has been in the volume of data it can handle.
I was hoping “Quick Sync” would be usable in an SQL/security filter environment, but I don’t know if that’s on the horizon or even possible.