LogoLogo
Knowledge BaseCommunityRelease NotesRequest Demo
  • Overview
  • Quick Start
    • Onboarding Guide
  • Data Sources & Transports
    • Supported Logs
      • 1Password Logs
      • Apache Logs
      • AppOmni Logs
      • Asana Logs
      • Atlassian Logs
      • Auditd Logs
      • Auth0 Logs
      • AWS Logs
        • AWS ALB
        • AWS Aurora
        • AWS CloudFront
        • AWS CloudTrail
        • AWS CloudWatch
        • AWS Config
        • AWS EKS
        • AWS GuardDuty
        • AWS Security Hub
        • Amazon Security Lake
        • AWS S3
        • AWS Transit Gateway
        • AWS VPC
        • AWS WAF
      • Azure Monitor Logs
      • Bitwarden Logs
      • Box Logs
      • Carbon Black Logs
      • Cisco Umbrella Logs
      • Cloudflare Logs
      • CrowdStrike Logs
        • CrowdStrike Falcon Data Replicator
        • CrowdStrike Event Streams
      • Docker Logs
      • Dropbox Logs
      • Duo Security Logs
      • Envoy Logs
      • Fastly Logs
      • Fluentd Logs
      • GCP Logs
      • GitHub Logs
      • GitLab Logs
      • Google Workspace Logs
      • Heroku Logs
      • Jamf Pro Logs
      • Juniper Logs
      • Lacework Logs
        • Lacework Alert Channel Webhook
        • Lacework Export
      • Material Security Logs
      • Microsoft 365 Logs
      • Microsoft Entra ID Audit Logs
      • Microsoft Graph Logs
      • MongoDB Atlas Logs
      • Netskope Logs
      • Nginx Logs
      • Notion Logs
      • Okta Logs
      • OneLogin Logs
      • Orca Security Logs (Beta)
      • Osquery Logs
      • OSSEC Logs
      • Proofpoint Logs
      • Push Security Logs
      • Rapid7 Logs
      • Salesforce Logs
      • SentinelOne Logs
      • Slack Logs
      • Snowflake Audit Logs (Beta)
      • Snyk Logs
      • Sophos Logs
      • Sublime Security Logs
      • Suricata Logs
      • Sysdig Logs
      • Syslog Logs
      • Tailscale Logs
      • Teleport Logs
      • Tenable Vulnerability Management Logs
      • Thinkst Canary Logs
      • Tines Logs
      • Tracebit Logs
      • Windows Event Logs
      • Wiz Logs
      • Zeek Logs
      • Zendesk Logs
      • Zoom Logs
      • Zscaler Logs
        • Zscaler ZIA
        • Zscaler ZPA
    • Custom Logs
      • Log Schema Reference
      • Transformations
      • Script Log Parser (Beta)
      • Fastmatch Log Parser
      • Regex Log Parser
      • CSV Log Parser
    • Data Transports
      • HTTP Source
      • AWS Sources
        • S3 Source
        • CloudWatch Logs Source
        • SQS Source
          • SNS Source
        • EventBridge
      • Google Cloud Sources
        • Cloud Storage (GCS) Source
        • Pub/Sub Source
      • Azure Blob Storage Source
    • Monitoring Log Sources
    • Ingestion Filters
      • Raw Event Filters
      • Normalized Event Filters (Beta)
    • Data Pipeline Tools
      • Chronosphere Onboarding Guide
      • Cribl Onboarding Guide
      • Fluent Bit Onboarding Guide
        • Fluent Bit Configuration Examples
      • Fluentd Onboarding Guide
        • General log forwarding via Fluentd
        • MacOS System Logs to S3 via Fluentd
        • Syslog to S3 via Fluentd
        • Windows Event Logs to S3 via Fluentd (Legacy)
        • GCP Audit to S3 via Fluentd
      • Observo Onboarding Guide
      • Tarsal Onboarding Guide
    • Tech Partner Log Source Integrations
  • Detections
    • Using Panther-managed Detections
      • Detection Packs
    • Rules and Scheduled Rules
      • Writing Python Detections
        • Python Rule Caching
        • Data Models
        • Global Helper Functions
      • Modifying Detections with Inline Filters (Beta)
      • Derived Detections (Beta)
        • Using Derived Detections to Avoid Merge Conflicts
      • Using the Simple Detection Builder
      • Writing Simple Detections
        • Simple Detection Match Expression Reference
        • Simple Detection Error Codes
    • Correlation Rules (Beta)
      • Correlation Rule Reference
    • PyPanther Detections (Beta)
      • Creating PyPanther Detections
      • Registering, Testing, and Uploading PyPanther Detections
      • Managing PyPanther Detections in the Panther Console
      • PyPanther Detections Style Guide
      • pypanther Library Reference
      • Using the pypanther Command Line Tool
    • Signals
    • Policies
    • Testing
      • Data Replay (Beta)
    • Framework Mapping and MITRE ATT&CK® Matrix
  • Cloud Security Scanning
    • Cloud Resource Attributes
      • AWS
        • ACM Certificate
        • CloudFormation Stack
        • CloudWatch Log Group
        • CloudTrail
        • CloudTrail Meta
        • Config Recorder
        • Config Recorder Meta
        • DynamoDB Table
        • EC2 AMI
        • EC2 Instance
        • EC2 Network ACL
        • EC2 SecurityGroup
        • EC2 Volume
        • EC2 VPC
        • ECS Cluster
        • EKS Cluster
        • ELBV2 Application Load Balancer
        • GuardDuty Detector
        • GuardDuty Detector Meta
        • IAM Group
        • IAM Policy
        • IAM Role
        • IAM Root User
        • IAM User
        • KMS Key
        • Lambda Function
        • Password Policy
        • RDS Instance
        • Redshift Cluster
        • Route 53 Domains
        • Route 53 Hosted Zone
        • S3 Bucket
        • WAF Web ACL
  • Alerts & Destinations
    • Alert Destinations
      • Amazon SNS Destination
      • Amazon SQS Destination
      • Asana Destination
      • Blink Ops Destination
      • Custom Webhook Destination
      • Discord Destination
      • GitHub Destination
      • Google Pub/Sub Destination (Beta)
      • Incident.io Destination
      • Jira Cloud Destination
      • Jira Data Center Destination (Beta)
      • Microsoft Teams Destination
      • Mindflow Destination
      • OpsGenie Destination
      • PagerDuty Destination
      • Rapid7 Destination
      • ServiceNow Destination (Custom Webhook)
      • Slack Bot Destination
      • Slack Destination (Webhook)
      • Splunk Destination (Beta)
      • Tines Destination
      • Torq Destination
    • Assigning and Managing Alerts
      • Managing Alerts in Slack
    • Alert Runbooks
      • Panther-managed Policies Runbooks
        • AWS CloudTrail Is Enabled In All Regions
        • AWS CloudTrail Sending To CloudWatch Logs
        • AWS KMS CMK Key Rotation Is Enabled
        • AWS Application Load Balancer Has Web ACL
        • AWS Access Keys Are Used Every 90 Days
        • AWS Access Keys are Rotated Every 90 Days
        • AWS ACM Certificate Is Not Expired
        • AWS Access Keys not Created During Account Creation
        • AWS CloudTrail Has Log Validation Enabled
        • AWS CloudTrail S3 Bucket Has Access Logging Enabled
        • AWS CloudTrail Logs S3 Bucket Not Publicly Accessible
        • AWS Config Is Enabled for Global Resources
        • AWS DynamoDB Table Has Autoscaling Targets Configured
        • AWS DynamoDB Table Has Autoscaling Enabled
        • AWS DynamoDB Table Has Encryption Enabled
        • AWS EC2 AMI Launched on Approved Host
        • AWS EC2 AMI Launched on Approved Instance Type
        • AWS EC2 AMI Launched With Approved Tenancy
        • AWS EC2 Instance Has Detailed Monitoring Enabled
        • AWS EC2 Instance Is EBS Optimized
        • AWS EC2 Instance Running on Approved AMI
        • AWS EC2 Instance Running on Approved Instance Type
        • AWS EC2 Instance Running in Approved VPC
        • AWS EC2 Instance Running On Approved Host
        • AWS EC2 Instance Running With Approved Tenancy
        • AWS EC2 Instance Volumes Are Encrypted
        • AWS EC2 Volume Is Encrypted
        • AWS GuardDuty is Logging to a Master Account
        • AWS GuardDuty Is Enabled
        • AWS IAM Group Has Users
        • AWS IAM Policy Blocklist Is Respected
        • AWS IAM Policy Does Not Grant Full Administrative Privileges
        • AWS IAM Policy Is Not Assigned Directly To User
        • AWS IAM Policy Role Mapping Is Respected
        • AWS IAM User Has MFA Enabled
        • AWS IAM Password Used Every 90 Days
        • AWS Password Policy Enforces Complexity Guidelines
        • AWS Password Policy Enforces Password Age Limit Of 90 Days Or Less
        • AWS Password Policy Prevents Password Reuse
        • AWS RDS Instance Is Not Publicly Accessible
        • AWS RDS Instance Snapshots Are Not Publicly Accessible
        • AWS RDS Instance Has Storage Encrypted
        • AWS RDS Instance Has Backups Enabled
        • AWS RDS Instance Has High Availability Configured
        • AWS Redshift Cluster Allows Version Upgrades
        • AWS Redshift Cluster Has Encryption Enabled
        • AWS Redshift Cluster Has Logging Enabled
        • AWS Redshift Cluster Has Correct Preferred Maintenance Window
        • AWS Redshift Cluster Has Sufficient Snapshot Retention Period
        • AWS Resource Has Minimum Number of Tags
        • AWS Resource Has Required Tags
        • AWS Root Account Has MFA Enabled
        • AWS Root Account Does Not Have Access Keys
        • AWS S3 Bucket Name Has No Periods
        • AWS S3 Bucket Not Publicly Readable
        • AWS S3 Bucket Not Publicly Writeable
        • AWS S3 Bucket Policy Does Not Use Allow With Not Principal
        • AWS S3 Bucket Policy Enforces Secure Access
        • AWS S3 Bucket Policy Restricts Allowed Actions
        • AWS S3 Bucket Policy Restricts Principal
        • AWS S3 Bucket Has Versioning Enabled
        • AWS S3 Bucket Has Encryption Enabled
        • AWS S3 Bucket Lifecycle Configuration Expires Data
        • AWS S3 Bucket Has Logging Enabled
        • AWS S3 Bucket Has MFA Delete Enabled
        • AWS S3 Bucket Has Public Access Block Enabled
        • AWS Security Group Restricts Ingress On Administrative Ports
        • AWS VPC Default Security Group Restricts All Traffic
        • AWS VPC Flow Logging Enabled
        • AWS WAF Has Correct Rule Ordering
        • AWS CloudTrail Logs Encrypted Using KMS CMK
      • Panther-managed Rules Runbooks
        • AWS CloudTrail Modified
        • AWS Config Service Modified
        • AWS Console Login Failed
        • AWS Console Login Without MFA
        • AWS EC2 Gateway Modified
        • AWS EC2 Network ACL Modified
        • AWS EC2 Route Table Modified
        • AWS EC2 SecurityGroup Modified
        • AWS EC2 VPC Modified
        • AWS IAM Policy Modified
        • AWS KMS CMK Loss
        • AWS Root Activity
        • AWS S3 Bucket Policy Modified
        • AWS Unauthorized API Call
    • Tech Partner Alert Destination Integrations
  • Investigations & Search
    • Search
      • Search Filter Operators
    • Data Explorer
      • Data Explorer SQL Search Examples
        • CloudTrail logs queries
        • GitHub Audit logs queries
        • GuardDuty logs queries
        • Nginx and ALB Access logs queries
        • Okta logs queries
        • S3 Access logs queries
        • VPC logs queries
    • Visualization and Dashboards
      • Custom Dashboards (Beta)
      • Panther-Managed Dashboards
    • Standard Fields
    • Saved and Scheduled Searches
      • Templated Searches
        • Behavioral Analytics and Anomaly Detection Template Macros (Beta)
      • Scheduled Search Examples
    • Search History
    • Data Lakes
      • Snowflake
        • Snowflake Configuration for Optimal Search Performance
      • Athena
  • PantherFlow (Beta)
    • PantherFlow Quick Reference
    • PantherFlow Statements
    • PantherFlow Operators
      • Datatable Operator
      • Extend Operator
      • Join Operator
      • Limit Operator
      • Project Operator
      • Range Operator
      • Sort Operator
      • Search Operator
      • Summarize Operator
      • Union Operator
      • Visualize Operator
      • Where Operator
    • PantherFlow Data Types
    • PantherFlow Expressions
    • PantherFlow Functions
      • Aggregation Functions
      • Date/time Functions
      • String Functions
      • Array Functions
      • Math Functions
      • Control Flow Functions
      • Regular Expression Functions
      • Snowflake Functions
      • Data Type Functions
      • Other Functions
    • PantherFlow Example Queries
      • PantherFlow Examples: Threat Hunting Scenarios
      • PantherFlow Examples: SOC Operations
      • PantherFlow Examples: Panther Audit Logs
  • Enrichment
    • Custom Lookup Tables
      • Creating a GreyNoise Lookup Table
      • Lookup Table Examples
        • Using Lookup Tables: 1Password UUIDs
      • Lookup Table Specification Reference
    • Identity Provider Profiles
      • Okta Profiles
      • Google Workspace Profiles
    • Anomali ThreatStream
    • IPinfo
    • Snowflake Enrichment (Beta)
    • Tor Exit Nodes
    • TrailDiscover (Beta)
  • Panther AI (Beta)
    • Managing Panther AI Response History
  • System Configuration
    • Role-Based Access Control
    • Identity & Access Integrations
      • Azure Active Directory SSO
      • Duo SSO
      • G Suite SSO
      • Okta SSO
        • Okta SCIM
      • OneLogin SSO
      • Generic SSO
    • Panther Audit Logs
      • Querying and Writing Detections for Panther Audit Logs
      • Panther Audit Log Actions
    • Notifications and Errors (Beta)
      • System Errors
    • Panther Deployment Types
      • SaaS
      • Cloud Connected
        • Setting Up a Cloud Connected Panther Instance
      • Legacy Configurations
        • Snowflake Connected (Legacy)
        • Customer-configured Snowflake Integration (Legacy)
        • Self-Hosted Deployments (Legacy)
          • Runtime Environment
  • Panther Developer Workflows
    • Panther Developer Workflows Overview
    • Using panther-analysis
      • Public Fork
      • Private Clone
      • Panther Analysis Tool
        • Install, Configure, and Authenticate with the Panther Analysis Tool
        • Panther Analysis Tool Commands
        • Managing Lookup Tables and Enrichment Providers with the Panther Analysis Tool
      • CI/CD for Panther Content
        • Deployment Workflows Using Panther Analysis Tool
          • Managing Panther Content via CircleCI
          • Managing Panther Content via GitHub Actions
        • Migrating to a CI/CD Workflow
    • Panther API
      • REST API (Beta)
        • Alerts
        • Alert Comments
        • API Tokens
        • Data Models
        • Globals
        • Log Sources
        • Queries
        • Roles
        • Rules
        • Scheduled Rules
        • Simple Rules
        • Policies
        • Users
      • GraphQL API
        • Alerts & Errors
        • Cloud Account Management
        • Data Lake Queries
        • Log Source Management
        • Metrics
        • Schemas
        • Token Rotation
        • User & Role Management
      • API Playground
    • Terraform
      • Managing AWS S3 Log Sources with Terraform
      • Managing HTTP Log Sources with Terraform
    • pantherlog Tool
    • Converting Sigma Rules
    • MCP Server (Beta)
  • Resources
    • Help
      • Operations
      • Security and Privacy
        • Security Without AWS External ID
      • Glossary
      • Legal
    • Panther System Architecture
Powered by GitBook
On this page
  • Overview
  • How incoming logs are enriched with Snowflake data
  • How to set up Snowflake enrichment in Panther
  • Configure Snowflake enrichment in Panther during Snowflake Audit source setup
  • Configure Snowflake enrichment in Panther after the initial Snowflake Audit source setup
  • Supported enrichment types
  • Snowflake.Users
  • Snowflake.Roles
  • Snowflake.GrantsToUsers
  • Snowflake.GrantsToRoles
  • Snowflake.Stages
  • Snowflake.NetworkPolicies

Was this helpful?

  1. Enrichment

Snowflake Enrichment (Beta)

Fetch and store Snowflake data to use in detections and search

PreviousIPinfoNextTor Exit Nodes

Last updated 18 hours ago

Was this helpful?

Overview

Snowflake enrichment is in open beta starting with Panther version 1.113, and is available to all customers. Please share any bug reports and feature requests with your Panther support team.

You can create Snowflake Lookup Tables in Panther by configuring your to pull tables containing "state" data (unlike the tables read by the log source itself, which contain time-series security data). This means you can reference this information in detection logic and search queries.

Snowflake enrichment data is refreshed on the same interval as the one you configure your Snowflake Audit log source to pull logs on.

After setting up Snowflake enrichment, to view the stored enrichment data, follow .

How incoming logs are enriched with Snowflake data

After you for a , incoming logs (parsed by any schema) will be enriched with Snowflake data if matches are found according to .

How to set up Snowflake enrichment in Panther

You can configure Snowflake enrichment while you are initially setting up your log source integration in Panther, or later, by editing the source. During either flow, on the Enrichment page, you'll toggle on your desired .

In order to enable these, you must first (or concurrently) . It is not possible to set up Snowflake enrichment without onboarding Snowflake as a log source in Panther.

Configure Snowflake enrichment in Panther during Snowflake Audit source setup

  • Follow , paying close attention to the Enrichment page.

Configure Snowflake enrichment in Panther after the initial Snowflake Audit source setup

  1. In the left-hand navigation bar of your Panther Console, click Configure > Log Sources.

  2. Locate the Snowflake Audit log source for which you'd like to set up enrichment, and click its name.

  3. In the upper-right corner, click Enrichment.

  4. Click Save.

Supported enrichment types

Snowflake.Users

schema: Snowflake.Users
description: Snowflake Users
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/users
fields:
  - name: match
    description: match of the LUT
    type: array
    element:
      type: string
  - name: BYPASS_MFA_UNTIL
    description: Timestamp until which multi-factor authentication is bypassed
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: COMMENT
    description: Comment for the user
    type: string
  - name: CREATED_ON
    required: true
    description: Timestamp when the user was created
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DEFAULT_NAMESPACE
    description: Default namespace assigned to the user
    type: string
  - name: DEFAULT_ROLE
    description: Default role assigned to the user
    type: string
  - name: DEFAULT_SECONDARY_ROLE
    description: Specifies the default secondary role for the user (i.e. ALL) or NULL if not set
    type: string
  - name: DEFAULT_WAREHOUSE
    description: Default warehouse assigned to the user
    type: string
  - name: DELETED_ON
    description: Timestamp of when the user was deleted (if deleted)
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DISABLED
    description: Indicates whether the user is disabled
    type: boolean
  - name: DISPLAY_NAME
    description: Display name of the user
    type: string
  - name: EMAIL
    description: Email address of the user
    type: string
    indicators:
      - email
  - name: EXT_AUTHN_DUO
    description: Indicates if external authentication via Duo is enabled
    type: boolean
  - name: EXT_AUTHN_ID
    description: The authorization ID used for Duo Security
    type: string
  - name: EXPIRES_AT
    description: The date and time when the user status is set to EXPIRED and the user can no longer log in
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: FIRST_NAME
    description: First name of the user
    type: string
  - name: LAST_NAME
    description: Last name of the user
    type: string
  - name: HAS_MFA
    description: Indicates if the user has multi-factor authentication enabled
    type: boolean
  - name: HAS_PASSWORD
    description: Indicates if the user has a password set
    type: boolean
  - name: HAS_RSA_PUBLIC_KEY
    description: Indicates if the user has an RSA public key set
    type: boolean
  - name: LAST_SUCCESS_LOGIN
    description: Timestamp of the last successful login
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: LOCKED_UNTIL_TIME
    description: Timestamp of when the user will be unlocked (if locked)
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: LOGIN_NAME
    description: Login name of the user
    type: string
  - name: MUST_CHANGE_PASSWORD
    description: Indicates if the user must change their password
    type: boolean
  - name: NAME
    required: true
    description: Name of the user
    type: string
    indicators:
      - username
  - name: OWNER
    description: Owner of the user account
    type: string
  - name: PASSWORD_LAST_SET_TIME
    description: The timestamp on which the last non-null password was set for the user. Defaults to null if no password has been set
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: SNOWFLAKE_LOCK
    description: Indicates if the user is locked in Snowflake
    type: boolean
  - name: TYPE
    description: 'Specifies the type of user. PERSON, SERVICE, LEGACY_SERVICE, or NULL. Default: NULL'
    type: string
  - name: USER_ID
    required: true
    description: Unique identifier for the user
    type: string

Snowflake.Roles

schema: Snowflake.Roles
description: Information about all roles defined in the Snowflake account
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/roles
fields:
  - name: match
    description: Match for lookups, matches ROLE_ID, ROLE_INSTANCE_ID, and NAME
    type: array
    element:
      type: string
  - name: ROLE_ID
    required: true
    description: Internal/system-generated identifier for the role
    type: string
  - name: CREATED_ON
    required: true
    description: Date and time (in the UTC time zone) when the role was created
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DELETED_ON
    description: Date and time (in the UTC time zone) when the role was deleted
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: NAME
    required: true
    description: Name of the role
    type: string
  - name: COMMENT
    description: Comment for the role
    type: string
  - name: OWNER
    description: Role with the OWNERSHIP privilege on the object
    type: string
  - name: ROLE_TYPE
    description: Either ROLE, DATABASE_ROLE, or INSTANCE_ROLE
    type: string
  - name: ROLE_DATABASE_NAME
    description: Name of the database that contains the database role if the role is a database role
    type: string
  - name: ROLE_INSTANCE_ID
    description: Internal/system-generated identifier for the class instance that the role belongs to
    type: string
  - name: OWNER_ROLE_TYPE
    description: The type of role that owns the object, for example ROLE. If a Snowflake Native App owns the object, the value is APPLICATION. Snowflake returns NULL if you delete the object because a deleted object does not have an owner role
    type: string

Snowflake.GrantsToUsers

schema: Snowflake.GrantsToUsers
description: Snowflake Grants to Users
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/grants_to_users
fields:
  - name: match
    description: Match field for lookups
    type: array
    element:
      type: string
  - name: CREATED_ON
    required: true
    description: Time and date (in the UTC time zone) when the role is granted
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DELETED_ON
    description: Time and date (in the UTC time zone) when the role is revoked
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: GRANTED_BY
    description: Identifier for the role that granted the privilege
    type: string
  - name: GRANTED_TO
    required: true
    description: For this log type, the value is USER
    type: string
  - name: GRANTEE_NAME
    required: true
    description: Name of the user to whom the privilege is granted
    type: string
    indicators:
      - username
  - name: ROLE
    required: true
    description: Identifier for the role granted to the user
    type: string

Snowflake.GrantsToRoles

schema: Snowflake.GrantsToRoles
description: Snowflake Grants to Roles
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/grants_to_roles
fields:
  - name: match
    description: Match field for lookups
    type: array
    element:
      type: string
  - name: CREATED_ON
    required: true
    description: Date and time (in the UTC time zone) when the privilege is granted to the role
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DELETED_ON
    description: Date and time (in the UTC time zone) when the privilege is revoked
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: GRANTED_BY
    description: Identifier for the role that granted the privilege, or the name of the Snowflake Native App object when there are grants to an application role
    type: string
    indicators:
      - username
  - name: GRANTED_BY_ROLE_TYPE
    description: Either APPLICATION, ROLE or DATABASE_ROLE
    type: string
  - name: GRANTED_TO
    required: true
    description: Either ROLE, DATABASE_ROLE, INSTANCE_ROLE, APPLICATION_ROLE, or APPLICATION
    type: string
  - name: GRANTED_ON
    required: true
    description: Object kind, such as TABLE or DATABASE, on which the privilege is granted
    type: string
  - name: GRANTEE_NAME
    required: true
    description: Identifier for the recipient role, the role to which the privilege is granted, or the name of the Snowflake Native App object
    type: string
    indicators:
      - username
  - name: GRANT_OPTION
    description: If set to TRUE, the recipient role can grant the privilege to other roles
    type: boolean
  - name: MODIFIED_ON
    description: Date and time (in the UTC time zone) when the privilege is updated
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: NAME
    description: Name of the object on which the privilege is granted
    type: string
  - name: PRIVILEGE
    description: Name of the privilege added to the role
    type: string
  - name: TABLE_CATALOG
    description: Name of the database for the current table or the name of the database that stores the instance of a class
    type: string
  - name: TABLE_SCHEMA
    description: Name of the schema for the current table or the name of the schema that stores the instance of a class
    type: string
  - name: OBJECT_INSTANCE
    description: The fully-qualified name of the object that contains the instance role for a particular class in the format database.schema.class
    type: json

Snowflake.Stages

schema: Snowflake.Stages
description: Snowflake Stages
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/stages
fields:
  - name: match
    description: match of the LUT
    type: array
    element:
      type: string
  - name: CREATED
    required: true
    description: Timestamp when the stage was created
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DELETED
    description: Timestamp when the stage was deleted
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: INSTANCE_ID
    description: Internal/system-generated identifier for the instance which the object belongs to
    type: string
  - name: LAST_ALTERED
    description: Timestamp when the stage was last altered
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: OWNER_ROLE_TYPE
    description: The type of role that owns the object, for example ROLE. If a Snowflake Native App owns the object, the value is APPLICATION
    type: string
  - name: STAGE_CATALOG
    description: Catalog where the stage resides
    type: string
  - name: STAGE_CATALOG_ID
    required: true
    description: Unique identifier for the stage catalog
    type: string
  - name: STAGE_ID
    required: true
    description: Unique identifier for the stage
    type: string
  - name: STAGE_NAME
    required: true
    description: Name of the stage
    type: string
  - name: STAGE_REGION
    description: Region where the stage is located
    type: string
  - name: STAGE_SCHEMA
    description: Schema where the stage resides
    type: string
  - name: STAGE_OWNER
    description: Name of the role that owns the stage; NULL if it has been dropped
    type: string
  - name: COMMENT
    description: Comment for this stage. NULL if no comment is provided
    type: string
  - name: STAGE_SCHEMA_ID
    required: true
    description: Unique identifier for the stage schema
    type: string
  - name: STAGE_TYPE
    description: Type of the stage (e.g., External Named)
    type: string
  - name: STAGE_URL
    description: URL of the stage
    type: string
  - name: STORAGE_INTEGRATION
    description: Storage integration associated with the stage
    type: string

Snowflake.NetworkPolicies

schema: Snowflake.NetworkPolicies
description: Snowflake Network Policies
referenceURL: https://docs.snowflake.com/en/sql-reference/account-usage/network_policies
fields:
  - name: match
    description: ID of the network policy for matching
    type: array
    element:
      type: string
  - name: ID
    required: true
    description: Internal system-generated identifier for network policy
    type: string
  - name: NAME
    required: true
    description: Network policy name
    type: string
  - name: OWNER
    description: Name of the role that owns the network policy
    type: string
  - name: OWNER_ROLE_TYPE
    description: The type of role that owns the object, for example ROLE. If a Snowflake Native App owns the object, the value is APPLICATION. Snowflake returns NULL if you delete the object because a deleted object does not have an owner role
    type: string
  - name: COMMENT
    description: Comment for the network policy (if any)
    type: string
  - name: CREATED
    description: Date and time that the network policy was created
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: LAST_ALTERED
    required: true
    description: Date and time that the network policy was last altered
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: DELETED
    description: Date and time the network policy was dropped
    type: timestamp
    timeFormats:
      - '%Y-%m-%d %H:%M:%S.%f %z'
      - '%a, %d %b %Y %H:%M:%S %z'
  - name: ALLOWED_IP_LIST
    description: List of allowed IPv4 addresses and CIDR block ranges in the corresponding network policy
    type: array
    element:
      type: string
  - name: BLOCKED_IP_LIST
    description: List of blocked IPv4 addresses and CIDR block ranges in the corresponding network policy
    type: array
    element:
      type: string

You can set up Snowflake enrichment after you've already created a log source in Panther by editing it:

In the upper-right corner of the log source page, click Configuration, then Edit.

Under Enrichment settings, on the tile of each of the you'd like to enable, click the toggle ON.

Panther supports pulling various tables from the Snowflake . Below are the schemas for how the data for each enrichment type is structured.

Snowflake Audit
ACCOUNT_USAGE schema
enrichment types
Snowflake Audit log source
these instructions on how to view enrichment data in the Data Lake
Snowflake Audit source
Snowflake Audit
onboard Snowflake as a log source
set up enrichment
enrichment types
automatic mapping by indicator fields
these instructions to create a new Snowflake Audit source in Panther
Under an "Enrichment settings" title, there are six tiles, each with a title, description, and toggle set to OFF.