จำลองสถานการณ์ มี request ที่ต้อง approve เพื่อขอการเข้าถึงฐานข้อมูล
Manager ชาวอินเดีย: Could you please explain what specific data we need from HR database for our project?
ลูกน้อง A : The initial table I requested in Snowflake is the employee table, which contains data on existing employees.
My goal is to compare this data with the active users in our project to identify employees who have left the company, so we can deactivate accounts in our project at the end of each quarter.
However, after accessing the data, I found that when I randomly sampled the email addresses of existing employees from the employee table, some of the current employees were missing from the dataset. This suggests that the employee table might not have complete data, which could affect the accuracy of our analysis or operations when comparing it with our project.
I've already raised the incident request with the concerned team about this issue, and they informed me that some data is indeed missing and are in the process of verifying with the team how this data is being collected.
The team suggested in the call to raise a request for access to only HR table with READ permission to get the necessary data for further analysis.
ลูกน้อง B : I want to compare the current employee data from HR database with the active users in our project to identify employees who have left the company, so we can deactivate accounts in our project.
อยากรู้ว่าคุณชอบคำตอบแบบไหน
== ถ้าคุณเป็นหัวหน้า ชอบคำตอบแบบไหนของลูกน้อง 2 สองคน ==
Manager ชาวอินเดีย: Could you please explain what specific data we need from HR database for our project?
ลูกน้อง A : The initial table I requested in Snowflake is the employee table, which contains data on existing employees.
My goal is to compare this data with the active users in our project to identify employees who have left the company, so we can deactivate accounts in our project at the end of each quarter.
However, after accessing the data, I found that when I randomly sampled the email addresses of existing employees from the employee table, some of the current employees were missing from the dataset. This suggests that the employee table might not have complete data, which could affect the accuracy of our analysis or operations when comparing it with our project.
I've already raised the incident request with the concerned team about this issue, and they informed me that some data is indeed missing and are in the process of verifying with the team how this data is being collected.
The team suggested in the call to raise a request for access to only HR table with READ permission to get the necessary data for further analysis.
ลูกน้อง B : I want to compare the current employee data from HR database with the active users in our project to identify employees who have left the company, so we can deactivate accounts in our project.
อยากรู้ว่าคุณชอบคำตอบแบบไหน