How does it work?
BigQuery Protector works with the help of the Google Cloud Platform. The users can use Google Cloud shell to interact with BigQuery protector where they can query the encrypted database without decrypting the database, and they can decrypt a single data without having to fully decrypt the database.
BigQuery Protector keeps the database encrypted while having the option to query the database and perform other data analytics operations on the encrypted database. Format Preserving Encryption is used when inserting new data which protects any sensitive data in the database, while still allowing the data to be queried through BigQuery.