
Ultimate access to all questions.
A table named user_ltv is used to create a view for data analysts across teams. Workspace users are organized into groups for ACL-based data access.
The user_ltv table has the schema:
email (STRING)age (INT)ltv (INT)The following view is defined:
CREATE VIEW user_ltv_no_minors AS
SELECT email, age, ltv
FROM user_ltv
WHERE
CASE
WHEN is_member("auditing") THEN TRUE
ELSE age >= 18
END
An analyst who is not in the auditing group runs:
SELECT * FROM user_ltv_no_minors
What results will this query return?