Creating amaterialized viewwith the limited data in a new dataset and granting the data analyst theBigQuery Data Viewerrole on the dataset and theBigQuery Job Userrole in the project ensures that the analyst can query only the non-sensitive data without access to sensitive datasets. Materialized views allow you to predefine what subset of data is visible, providing a secure and efficient way to control access while maintaining compliance with data governance policies. This approach follows the principle of least privilege while meeting the requirements.