Hey everyone! I had a question about Snowflake que...
# ingestion
c
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:
Copy code
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?
o
Assuming the same ingestion recipe with the same table filters etc., yes it would attempt to access the same tables and perform an upsert with the second execution's metadata, overwriting the initial run for the tables that match, if there are any changes.
plus1 1