OBJECT_CONSTRUCT() converts each row into a single VARIANT object , which can then be unloaded in JSON format using COPY INTO. This is essential when converting relational data into semi-structured JSON .
Reference:
Snowflake Docs: OBJECT_CONSTRUCT

Access History in Snowflake is primarily utilized for compliance auditing. The Access History feature provides detailed logs that track data access and modifications, includingqueries that read from or write to database objects. This information is crucial for organizations to meet regulatory requirements and to perform audits related to data access and usage.
Role of Access History:Access History logs are designed to help organizations understand who accessed what data and when. This is particularly important for compliance with various regulations that require detailed auditing capabilities.
How Access History Supports Compliance Auditing:
By providing a detailed log of access events, organizations can trace data access patterns, identify unauthorized access, and ensure that data handling complies with relevant data protection laws and regulations.
Access History can be queried to extract specific events, users, time frames, and accessed objects, making it an invaluable tool for compliance officers and auditors.
Reference:For more information on how Access History supports compliance auditing, refer to the Snowflake documentation on Access History: https://docs.snowflake.com/en/sql-reference/account-usage/access_history.
html

According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts. References: Based on my internal knowledge as of
2021.