Hey everyone! I had a question about Snowflake query usage stat ingestions:
The user account I created in Snowflake for DataHub ingestions is not an `accountadmin`; instead, I've applied a lower level role (has restricted access to tables and is masked from seeing particular sensitive rows/columns) and have granted the user access to the account_usage Snowflake schema. Will the queries pulled in this user's ingestion job also consist of queries that have been made by users with higher level access (ex: an account admin)?
As an example of this scenario:
Tables:
Table A
Table B
Users:
User 1: can only access Table A
User 2: can access Table A and Table B
User 2 has made a query before of the following:
SELECT uid FROM Table A JOIN SELECT uid FROM Table B
Let's say I used User 1's credentials for my ingestion job of Table A: would the query usage stats pull User 2's query above?