Fix Inactive Snowflake Data Types in Sentinel

[jkarpen]

@ram-kishore-odi will fill in additional details to this placeholder

As a Platform Lead, I want to fix the 8 inactive Snowflake data types in the Sentinel connector, so that all installed analytic rules are backed by complete data and can fire accurately. (IT reported this issue)

Tasks

• Investigate and find the root cause of the issue
• Confirm PAT token role restriction matches the role that has IMPORTED PRIVILEGES on the SNOWFLAKE database
• Execute GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE <PAT_ROLE> as ACCOUNTADMIN (if needed or missing)
• If wrong role was used in PAT — revoke and regenerate with correct ROLE_RESTRICTION
• Validate all 8 failing views return rows under the PAT role
• Confirm - final state, all 10 data types show a live timestamp in Sentinel

[ram-kishore-odi]

Updated the details in the story

[ram-kishore-odi]

The initial investigation indicates no issues or query errors on the Snowflake side. A sample screenshot is provided below. It is possible that not all 10 data types currently have data available to be sent to Swetinel.

This is still under investigation and remains critical to resolving the issue.