Release Notes
1.0.0 (Requires minimum Cloud Exchange version 6.1.0)
Added
- Initial release.
- Log Types: Alerts, Events, WebTX
- Format Type: JSON
This document explains how to configure the Snowflake v1.0.0 plugin with the Log Shipper module of the Netskope Cloud Exchange platform. This plugin is used to send these to Snowflake via the Snowflake Snowpipe Streaming REST API:
- Alerts (DLP, Malware, Policy, Compromised Credential, Malsite, Quarantine, Remediation, Security Assessment, Watchlist, UBA, CTEP, Device, Content)
- Events (Page, Application, Audit, Infrastructure, Network, Incident, Endpoint, Client Status)
- WebTX data.
This plugin supports ingestion in JSON format only. This plugin does not create or alter tables in Snowflake; create the target table(s) there before saving this configuration.
Prerequisites
To complete this configuration, you need:
- A Netskope tenant (or multiple, for example, production and development/test instances).
- A Netskope Cloud Exchange tenant with the Tenant plugin and Log Shipper plugin already configured.
- The AWS Log Streaming plugin or Azure Log Streaming plugin already configured for ingesting alerts, events, and WebTX from the Netskope Log Streaming plugin.
- A Snowflake instance with an account.
- Already created Database, Schema, and Tables on the Snowflake instance.
- Connectivity to the following host: https://<account>.snowflakecomputing.com
- For Secret Manager configuration, refer to this documentation. To set up Azure Key Vault Secrets Manager, refer to this documentation.
Snowflake Plugin Support
This plugin supports ingestion in JSON format only. This plugin does not create or alter tables in Snowflake; create the target table(s) there before saving this configuration.
| Data Type | Support |
|---|---|
| Events | Yes (Page, Application, Audit, Infrastructure, Network, Incident, Endpoint, Client Status) |
| Alerts | Yes (DLP, Malware, Policy, Compromised Credential, Malsite, Quarantine, Remediation, Security Assessment, Watchlist, UBA, CTEP, Device, Content) |
| Syslog CE Logs | No |
| BWAN Events | No |
| WebTX | Yes (via Netskope LogStreaming) |
Permissions
These permissions are needed for the plugin configuration.
- USAGE on Database
- USAGE on Schema
- INSERT on each target table
API Details
| Endpoint | Use Case |
|---|---|
| /v2/streaming/hostname | Used to obtain the base url for the ingest data endpoint. |
| /api/v2/statements | Execute SQL queries on snowflake (execute the show table schema query to get the table fields) |
| /api/v2/statements/{statementHandle} | Check the status of the SQL query executed by the statements API. |
| /v2/streaming/data/databases/{database}/schemas/{schema}/tables/{table}/rows | Used to ingest logs into tables on snowflake |
Resolve Streaming Ingest Hostname
Method: GET
Endpoint: {Account URL}/v2/streaming/hostname
Request Headers
| Key | Value |
|---|---|
| Authorization | Bearer {programmatic access token} |
| X-Snowflake-Authorization-Token-Type | PROGRAMMATIC_ACCESS_TOKEN |
| User-Agent | netskope-ce-7.0.0-cls-snowflake/v1.0.0 |
Query Parameters: None
Request Body: None
Response
{
"hostname": "abcd1234.snowflakecomputing.com"
}
Introspect Table Columns
Method: POST
Endpoint: {Account URL}/api/v2/statements
Request Headers
| Key | Value |
|---|---|
| Authorization | Bearer {programmatic access token} |
| X-Snowflake-Authorization-Token-Type | PROGRAMMATIC_ACCESS_TOKEN |
| User-Agent | netskope-ce-7.0.0-cls-snowflake/v1.0.0 |
| Content-Type | application/json |
Query Parameters: None
Request Body
{
"statement": "SHOW COLUMNS IN TABLE \"MY_DB\".\"MY_SCHEMA\".\"NETSKOPE_LOGS\"",
"timeout": 30,
"database": "MY_DB",
"schema": "MY_SCHEMA"
}
Response
{
"resultSetMetaData": {
"rowType": [
{ "name": "column_name" },
{ "name": "data_type" }
]
},
"data": [
["EVENT_TIME", "{\"type\":\"TIMESTAMP_NTZ\"}"],
["DATA_TYPE", "{\"type\":\"TEXT\"}"],
["SUBTYPE", "{\"type\":\"TEXT\"}"],
["RAW_DATA", "{\"type\":\"VARIANT\"}"],
["INGESTION_TIME", "{\"type\":\"TIMESTAMP_NTZ\"}"],
["SOURCE_CONFIGURATION_NAME", "{\"type\":\"TEXT\"}"]
]
}
Poll Statement Status
Method: GET
Endpoint: {Account URL}/api/v2/statements/{statementHandle}
Request Headers
| Key | Value |
|---|---|
| Authorization | Bearer {programmatic access token} |
| X-Snowflake-Authorization-Token-Type | PROGRAMMATIC_ACCESS_TOKEN |
| User-Agent | netskope-ce-7.0.0-cls-snowflake/v1.0.0 |
| Content-Type | application/json |
Query Parameters: None
Request Body: None
Response
{
"resultSetMetaData": {
"rowType": [
{ "name": "column_name" },
{ "name": "data_type" }
]
},
"data": [
["EVENT_TIME", "{\"type\":\"TIMESTAMP_NTZ\"}"],
["DATA_TYPE", "{\"type\":\"TEXT\"}"],
["SUBTYPE", "{\"type\":\"TEXT\"}"],
["RAW_DATA", "{\"type\":\"VARIANT\"}"],
["INGESTION_TIME", "{\"type\":\"TIMESTAMP_NTZ\"}"],
["SOURCE_CONFIGURATION_NAME", "{\"type\":\"TEXT\"}"]
]
}
Ingest Data
Method: POST
Endpoint: https://{streaming_host}/v2/streaming/data/databases/{database}/schemas/{schema}/tables/{table}/rows
Request Headers
| Key | Value |
|---|---|
| Authorization | Bearer {programmatic access token} |
| X-Snowflake-Authorization-Token-Type | PROGRAMMATIC_ACCESS_TOKEN |
| User-Agent | netskope-ce-7.0.0-cls-snowflake/v1.0.0 |
| Content-Type | application/x-ndjson |
| Content-Encoding | gzip |
Query Parameters
| Parameter | Description |
|---|---|
| requestId | A fresh UUID generated per batch. |
| retryCount | Starts at 0 and is incremented on each resend of the same batch. |
Request Body
{"EVENT_TIME":"2026-10-07T12:00:00.000000Z","DATA_TYPE":"alerts","SUBTYPE":"dlp","RAW_DATA":{"alert_type":"dlp","user":"jdoe@example.com","severity":"high"}}
{"EVENT_TIME":"2026-10-07T12:00:01.500000Z","DATA_TYPE":"alerts","SUBTYPE":"dlp","RAW_DATA":{"alert_type":"dlp","user":"asmith@example.com","severity":"medium"}}
Response
{
"status_code": 0,
"message": "Rows successfully appended."
}
Performance Matrix
This performance reading is conducted on a Large Stack CE with these VM specifications.
| Description | Specification |
|---|---|
| Stack details | Size: Large RAM: 32 GB CPU: 16 Cores |
| Alerts/Events ingested to SIEM | ~200k EPM |
| WebTX (via Netskope LogStreaming) ingested to SIEM | ~170k EPM |
User Agent
netskope-ce-7.0.0-cls-snowflake/v1.0.0
Workflow
- Create a Target Database, Schema, and Table(s) in Snowflake to get your Programmatic Access Token.
- Get your Snowflake Account URL.
- Configure the Snowflake Plugin.
- Configure a Log Shipper Business Rule.
- Configure Log Shipper Log Delivery.
- Validate the plugin.
Watch a Video
Click play to watch a video.
Create a Target Database, Schema, and Table(s) in Snowflake
- Log in to your Snowflake instance and go to Projects > Workspace.

- Create a new workspace or use any of the existing workspace and execute the below queries as per your requirement:
Single Table for all the logs
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, RAW_DATA VARIANT, INGESTION_TIME TIMESTAMP_NTZ, SOURCE_CONFIGURATION_NAME VARCHAR );
The INGESTION_TIME and SOURCE_CONFIGURATION_NAME fields are not mandatory
Per Data Type tables (Combined Column mode)
Alerts
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, RAW_DATA VARIANT, INGESTION_TIME TIMESTAMP_NTZ, SOURCE_CONFIGURATION_NAME VARCHAR );
The INGESTION_TIME and SOURCE_CONFIGURATION_NAME fields are not mandatory
Events
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, RAW_DATA VARIANT, INGESTION_TIME TIMESTAMP_NTZ, SOURCE_CONFIGURATION_NAME VARCHAR );
The INGESTION_TIME and SOURCE_CONFIGURATION_NAME fields are not mandatory
WebTX
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, RAW_DATA VARIANT, INGESTION_TIME TIMESTAMP_NTZ, SOURCE_CONFIGURATION_NAME VARCHAR );
The INGESTION_TIME and SOURCE_CONFIGURATION_NAME fields are not mandatory
Per Data Type Tables (Separate Column mode)
Alerts
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, INGESTION_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, SOURCE_CONFIGURATION_NAME VARCHAR, ACCESS_KEY_ID VARCHAR, ACCESS_METHOD VARCHAR, ACCOUNTTYPE VARCHAR, ACCOUNT_ID VARCHAR, ACCOUNT_NAME VARCHAR, ACKED VARCHAR, ACTION VARCHAR, ACTIONS_TAKEN VARCHAR, ACTIVITY VARCHAR, ACTIVITY_STATUS VARCHAR, ACTIVITY_TYPE VARCHAR, ACT_USER VARCHAR, AGGREGATED_USER VARCHAR, ALERT VARCHAR, ALERT_DETECTION_STAGE VARCHAR, ALERT_ID VARCHAR, ALERT_NAME VARCHAR, ALERT_SOURCE VARCHAR, ALERT_TYPE VARCHAR, ALL_POLICY_MATCHES VARIANT, ANOMALYDATA VARIANT, ANOMALY_TYPE VARCHAR, APP VARCHAR, APPACT VARCHAR, APPCATEGORY VARCHAR, APPSUITE VARCHAR, APP_ACTIVITY VARCHAR, APP_CATEGORY VARCHAR, APP_CCI_APPHOSTING_PROVIDER VARCHAR, APP_GDPR_LEVEL VARCHAR, APP_NAME VARCHAR, APP_SCOPES VARCHAR, APP_SESSION_ID NUMBER, ARCHIVE_SUBFILES VARIANT, ASSET_ID VARCHAR, ASSET_OBJECT_ID VARCHAR, AUDIT_CATEGORY VARCHAR, AUDIT_TYPE VARCHAR, BCC VARCHAR, BIN_TIMESTAMP NUMBER, BLOCK_REASON VARCHAR, BREACH_DATE NUMBER, BREACH_DESCRIPTION VARCHAR, BREACH_ID VARCHAR, BREACH_MEDIA_REFERENCES VARCHAR, BREACH_SCORE VARCHAR, BREACH_TARGET_REFERENCES VARCHAR, BROWSER VARCHAR, BROWSER_SESSION_ID NUMBER, BROWSER_VERSION VARCHAR, BYPASS_TRAFFIC VARCHAR, CATEGORY VARCHAR, CC VARCHAR, CCI NUMBER, CCL VARCHAR, CHANNEL VARCHAR, CLASSIFICATION_NAME VARCHAR, CLIENT_BYTES NUMBER, CLIENT_PACKETS NUMBER, CLOUD_PROVIDER VARCHAR, CO VARCHAR, COLLABORATED VARCHAR, COMPANY VARCHAR, COMPLIANCE_STANDARDS VARIANT, COMPUTER_NAME VARCHAR, CONNECTION_ID NUMBER, CONNECTION_TYPE VARCHAR, CONN_DURATION NUMBER, CONN_ENDTIME NUMBER, CONN_STARTTIME NUMBER, CONONICALNAME VARCHAR, COUNT NUMBER, CREATEDTIME VARCHAR, CREATED_DATE NUMBER, CUSTOM_ATTR VARIANT, CUSTOM_CONNECTOR VARCHAR, DEPARTMENT VARCHAR, DEPARTMENTNUMBER VARCHAR, DESTINATION_FILE_DIRECTORY VARCHAR, DESTINATION_FILE_NAME VARCHAR, DESTINATION_FILE_PATH VARCHAR, DETECTION_ENGINE VARCHAR, DETECTION_TYPE VARCHAR, DEVICE VARCHAR, DEVICECLASSIFICATION VARIANT, DEVICE_CLASSIFICATION VARCHAR, DINSID VARCHAR, DISPLAYNAME VARCHAR, DISTINGUISHEDNAME VARCHAR, DIVISION VARCHAR, DLP_FAIL_REASON VARCHAR, DLP_FILE VARCHAR, DLP_FINGERPRINT_CLASSIFICATION VARCHAR, DLP_FINGERPRINT_MATCH VARCHAR, DLP_FINGERPRINT_SCORE NUMBER, DLP_INCIDENT_ID NUMBER, DLP_IS_UNIQUE_COUNT VARCHAR, DLP_MAIL_PARENT_ID VARCHAR, DLP_PARENT_ID NUMBER, DLP_PROFILE VARCHAR, DLP_RULE VARCHAR, DLP_RULE_COUNT NUMBER, DLP_RULE_SCORE NUMBER, DLP_RULE_SEVERITY VARCHAR, DLP_SCAN_FAILED VARCHAR, DLP_UNIQUE_COUNT NUMBER, DNS_PROFILE VARCHAR, DOMAIN VARCHAR, DOMAIN_IP VARCHAR, DOWNLOAD_APP VARCHAR, DRIVER VARCHAR, DSTHOST VARCHAR, DSTIP VARCHAR, DSTPORT NUMBER, DST_COUNTRY VARCHAR, DST_GEOIP_SRC NUMBER, DST_LATITUDE FLOAT, DST_LOCATION VARCHAR, DST_LONGITUDE FLOAT, DST_REGION VARCHAR, DST_TIMEZONE VARCHAR, DST_ZIPCODE VARCHAR, DYNAMIC_CLASSIFICATION VARCHAR, EDR_APP VARCHAR, EEML VARCHAR, EMAIL_FROM_USER VARCHAR, EMAIL_MODIFIED NUMBER, EMAIL_SOURCE VARCHAR, EMAIL_TITLE VARCHAR, EMAIL_USER VARCHAR, EMPLOYEETYPE VARCHAR, ENCRYPTION_STATUS VARCHAR, ENCRYPT_FAILURE VARCHAR, ENDPOINTS VARCHAR, ENDPOINT_COUNT NUMBER, END_TIME VARCHAR, ENTERPRISE VARCHAR, ENTERPRISE_ID VARCHAR, EVENT_TYPE VARCHAR, EVENT_UUID VARCHAR, EVT_SRC_CHNL VARCHAR, EXPOSURE VARCHAR, EXTERNAL_COLLABORATOR_COUNT NUMBER, EXTERNAL_EMAIL NUMBER, EXT_LABELS VARIANT, FASTSCAN_RESULTS VARCHAR, FILENAME VARCHAR, FILEPATH VARCHAR, FILE_CATEGORY VARCHAR, FILE_CLS_ENCRYPTED BOOLEAN, FILE_EXPOSURE VARCHAR, FILE_ID VARCHAR, FILE_LANG VARCHAR, FILE_MD5 VARCHAR, FILE_NAME VARCHAR, FILE_OWNER VARCHAR, FILE_PASSWORD_PROTECTED VARCHAR, FILE_PATH VARCHAR, FILE_SIZE NUMBER, FILE_TYPE VARCHAR, FLLG VARCHAR, FLPP VARCHAR, FORWARD_TO_PROXY_XAU VARCHAR, FROMLOGS VARCHAR, FROM_OBJECT VARCHAR, FROM_STORAGE VARCHAR, FROM_USER VARCHAR, FROM_USER_CATEGORY VARCHAR, GATEWAY VARCHAR, GID NUMBER, GROUP_ VARCHAR, HOME_POP VARCHAR, HOSTNAME VARCHAR, HTTP_METHOD VARCHAR, HTTP_PORT NUMBER, HTTP_STATUS VARCHAR, HTTP_TRANSACTION_COUNT NUMBER, IAAS_ASSET_TAGS VARIANT, IAAS_REMEDIATED VARCHAR, IAAS_REMEDIATED_BY VARCHAR, IAAS_REMEDIATED_ON NUMBER, IAAS_REMEDIATION_ACTION VARCHAR, INCIDENT_ID NUMBER, INSTANCE VARCHAR, INSTANCE_ID VARCHAR, INSTANCE_NAME VARCHAR, INTERNAL_COLLABORATOR_COUNT NUMBER, IP_PROTOCOL VARCHAR, JA3 VARCHAR, JA3S VARCHAR, JUSTIFICATION_REASON VARCHAR, JUSTIFICATION_TYPE VARCHAR, LAST_APP VARCHAR, LAST_COUNTRY VARCHAR, LAST_DEVICE VARCHAR, LAST_LOCATION VARCHAR, LAST_NAME VARCHAR, LAST_REGION VARCHAR, LAST_TIMESTAMP NUMBER, LEGAL_HOLD_PROFILE_NAME VARCHAR, LH_CUSTODIAN_EMAIL VARCHAR, LH_CUSTODIAN_NAME VARCHAR, LH_DEST_APP VARCHAR, LH_DEST_INSTANCE VARCHAR, LH_FILEID VARCHAR, LH_FILENAME VARCHAR, LH_FILEPATH VARCHAR, LH_ORIGINAL_FILENAME VARCHAR, LH_SHARED VARCHAR, LH_SHARED_WITH VARCHAR, LH_VERSION VARCHAR, LOC VARCHAR, LOCAL_MD5 VARCHAR, LOCAL_SHA1 VARCHAR, LOCAL_SHA256 VARCHAR, LOCAL_SOURCE_TIME VARCHAR, LOCATION VARCHAR, LOGINTYPE VARCHAR, LOGINURL VARCHAR, LOG_FILE_NAME VARCHAR, MAIL VARCHAR, MALICIOUS VARCHAR, MALSITE_ACTIVE VARCHAR, MALSITE_CATEGORY VARIANT, MALSITE_CONFIDENCE NUMBER, MALSITE_CONSECUTIVE VARCHAR, MALSITE_COUNTRY VARCHAR, MALSITE_FIRST_SEEN NUMBER, MALSITE_HOSTILITY VARCHAR, MALSITE_ID VARCHAR, MALSITE_IP_HOST VARCHAR, MALSITE_LAST_SEEN NUMBER, MALSITE_LATITUDE FLOAT, MALSITE_LONGITUDE FLOAT, MALSITE_REGION VARCHAR, MALSITE_REPUTATION VARCHAR, MALWARE_ID VARCHAR, MALWARE_NAME VARCHAR, MALWARE_PROFILE VARCHAR, MALWARE_SEVERITY VARCHAR, MALWARE_TYPE VARCHAR, MAL_ID VARCHAR, MAL_SEV VARCHAR, MAL_TYPE VARCHAR, MANAGED_APP VARCHAR, MANAGEMENTID VARCHAR, MANAGER VARCHAR, MATCHED_USERNAME VARCHAR, MCP_ACTIVITY VARCHAR, MCP_CLIENT_CAPABILITIES VARCHAR, MCP_CLIENT_NAME VARCHAR, MCP_CLIENT_PROTOCOL_VERSION VARCHAR, MCP_METHOD VARCHAR, MCP_PROMPT_LIST VARCHAR, MCP_PROMPT_NAME VARCHAR, MCP_PROTOCOL_VERSION VARCHAR, MCP_RESOURCE_LIST VARCHAR, MCP_RESOURCE_URL VARCHAR, MCP_SERVER_CAPABILITIES VARCHAR, MCP_SERVER_NAME VARCHAR, MCP_SERVER_PROTOCOL_VERSION VARCHAR, MCP_TOOL_LIST VARCHAR, MCP_TOOL_NAME VARCHAR, MD5 VARCHAR, MEMBEROF VARCHAR, MESSAGE_ID VARCHAR, MESSAGE_SIZE NUMBER, METADATA VARIANT, MIME_TYPE VARCHAR, ML_DETECTION VARCHAR, MODIFIED NUMBER, MODIFIED_DATE NUMBER, NETSKOPE_ACTIVITY VARCHAR, NETSKOPE_POP VARCHAR, NETWORK VARCHAR, NETWORK_SESSION_ID VARCHAR, NOTIFY_TEMPLATE VARCHAR, NSDEVICEUID VARCHAR, NS_ACTIVITY VARCHAR, NUMBYTES NUMBER, NUM_SESSIONS NUMBER, NUM_USERS NUMBER, OBJECT VARCHAR, OBJECT_COUNT NUMBER, OBJECT_ID VARCHAR, OBJECT_TYPE VARCHAR, ORG VARCHAR, ORGANIZATION_UNIT VARCHAR, ORIGNAL_FILE_PATH VARCHAR, ORIG_TY VARCHAR, OS VARCHAR, OS_DETAILS VARCHAR, OS_FAMILY VARCHAR, OS_USER_NAME VARCHAR, OS_VERSION VARCHAR, OTHER_CATEGORIES VARIANT, OUTER_DOC_TYPE NUMBER, OWNER VARCHAR, OWNER_PDL VARCHAR, PAGE VARCHAR, PAGE_SITE VARCHAR, PARENT_ID VARCHAR, PARENT_PROCESS_NAME VARCHAR, PASSWORD_TYPE VARCHAR, PID VARCHAR, POLICY VARCHAR, POLICY_ACTION VARCHAR, POLICY_ACTIONS VARIANT, POLICY_ID VARCHAR, POLICY_NAME VARCHAR, POLICY_NAME_ENFORCED VARCHAR, POP_ID VARCHAR, PROCESS_CERT_SUBJECT VARCHAR, PROCESS_NAME VARCHAR, PROCESS_PATH VARCHAR, PROFILE_EMAILS VARIANT, PROFILE_HITS VARIANT, PROFILE_ID VARCHAR, PROTOCOL VARCHAR, PROTOCOL_PORT VARCHAR, PUBLISHER_CN VARCHAR, PUBLISHER_NAME VARCHAR, QDOMAIN VARCHAR, QTYPE VARCHAR, QUARANTINE_ACTION_REASON VARCHAR, QUARANTINE_FILE_ID VARCHAR, QUARANTINE_FILE_NAME VARCHAR, QUARANTINE_PROFILE VARCHAR, QUARANTINE_PROFILE_ID VARCHAR, Q_ADMIN VARCHAR, Q_APP VARCHAR, Q_INSTANCE VARCHAR, Q_ORIGINAL_FILENAME VARCHAR, Q_ORIGINAL_FILEPATH VARCHAR, Q_ORIGINAL_SHARED VARCHAR, Q_ORIGINAL_VERSION VARCHAR, Q_SHARED_WITH VARCHAR, RECORD_TYPE VARCHAR, REDIRECT_URL VARCHAR, REFERER VARCHAR, REGION_ID VARCHAR, REGION_NAME VARCHAR, RELATED_MALWARE VARCHAR, REMEDIATION_PROFILE VARCHAR, REQ VARCHAR, REQUEST_ID NUMBER, REQUEST_TYPE VARCHAR, REQ_CNT NUMBER, RESOURCE_CATEGORY VARCHAR, RESOURCE_GROUP VARCHAR, RESP VARCHAR, RESP_CNT NUMBER, RETRO_SCAN_NAME VARCHAR, RISK_LEVEL VARCHAR, RISK_LEVEL_ID NUMBER, RISK_SCORE NUMBER, SAMACCOUNTNAME VARCHAR, SAMACCOUNTTYPE VARCHAR, SANCTIONED_INSTANCE VARCHAR, SA_PROFILE_ID NUMBER, SA_PROFILE_NAME VARCHAR, SA_RULE_COMPLIANCE VARCHAR, SA_RULE_ID VARCHAR, SA_RULE_NAME VARCHAR, SA_RULE_SEVERITY VARCHAR, SCANNER_RESULT VARCHAR, SCAN_TIME NUMBER, SCAN_TYPE VARCHAR, SCOPES VARIANT, SCORE VARCHAR, SENDER VARCHAR, SERIAL VARCHAR, SERVERITY VARCHAR, SERVER_BYTES NUMBER, SERVER_PACKETS NUMBER, SESSIONID VARCHAR, SESSION_DURATION NUMBER, SESSION_NUMBER_UNIQUE NUMBER, SEVERITY VARCHAR, SEVERITY_ID NUMBER, SEVERITY_LEVEL VARCHAR, SEVERITY_LEVEL_ID NUMBER, SFWDER VARCHAR, SHA1 VARCHAR, SHA256 VARCHAR, SHAREDTYPE VARCHAR, SHARED_CREDENTIAL_USER VARCHAR, SHARED_DOMAINS VARCHAR, SHARED_TYPE VARCHAR, SHARED_WITH VARCHAR, SIGNATURE VARCHAR, SIGNATURE_ID NUMBER, SITE VARCHAR, SMTP_CLIENT_DOMAIN VARCHAR, SMTP_STATUS VARCHAR, SMTP_TO VARIANT, SPET NUMBER, SPST NUMBER, SRCIP VARCHAR, SRCPORT NUMBER, SRC_COUNTRY VARCHAR, SRC_GEOIP_SRC NUMBER, SRC_LATITUDE FLOAT, SRC_LOCATION VARCHAR, SRC_LONGITUDE FLOAT, SRC_NETWORK VARCHAR, SRC_REGION VARCHAR, SRC_TIME VARCHAR, SRC_TIMEZONE VARCHAR, SRC_ZIPCODE VARCHAR, START_TIME VARCHAR, SUBJECT VARCHAR, SUB_TYPE VARCHAR, SUPPRESSION_COUNT VARCHAR, SUPPRESSION_END_TIME NUMBER, SUPPRESSION_KEY VARCHAR, SUPPRESSION_START_TIME NUMBER, SURHN VARCHAR, TAGS VARCHAR, TELEMETRY_APP VARCHAR, THR VARCHAR, THREAT_MATCH_FIELD VARCHAR, THREAT_MATCH_VALUE VARCHAR, THREAT_SOURCE_ID NUMBER, THREAT_TYPE VARCHAR, THRESHOLD NUMBER, THRESHOLD_TIME NUMBER, TIMESTAMP NUMBER, TITLE VARCHAR, -- Title TOTAL_COLLABORATOR_COUNT NUMBER, TOTAL_PACKETS NUMBER, TO_OBJECT VARCHAR, TO_STORAGE VARCHAR, TO_USER VARCHAR, TO_USER_CATEGORY VARCHAR, TRAFFIC_TYPE VARCHAR, TRANSACTION_ID NUMBER, TRUE_FILETYPE VARCHAR, TRUE_OBJ_CATEGORY VARCHAR, TRUE_OBJ_TYPE VARCHAR, TRUE_TYPE_ID NUMBER, TRUST_COMPUTER_CHECKED VARCHAR, TSS_FAIL_REASON VARCHAR, TSS_LICENSE VARCHAR, TSS_MODE VARCHAR, TSS_SCAN VARCHAR, TSS_SCAN_FAILED VARCHAR, TUNNEL_ID VARCHAR, TUNNEL_TYPE VARCHAR, TUNNEL_UP_TIME NUMBER, TUR VARCHAR, TWO_FACTOR_AUTH VARCHAR, TYPE VARCHAR, UBA_AP1 VARCHAR, UBA_AP2 VARCHAR, UBA_INST1 VARCHAR, UBA_INST2 VARCHAR, UNIVERSAL_CONNECTOR VARCHAR, URL VARCHAR, UR_NORMALIZED VARCHAR, USB_DEVICE_ID VARCHAR, USB_DEVICE_NAME VARCHAR, USB_DEVICE_SN VARCHAR, USB_DEVICE_TYPE VARCHAR, USB_IS_ENCRYPTED BOOLEAN, USB_PRODUCT_ID VARCHAR, USB_VENDOR_ID VARCHAR, USER VARCHAR, USERAGENT VARCHAR, USERCOUNTRY VARCHAR, USERGROUP VARCHAR, USERIP VARCHAR, USERKEY VARCHAR, USERPRINCIPALNAME VARCHAR, USER_CATEGORY VARCHAR, USER_CONFIDENCE_INDEX NUMBER, USER_CONFIDENCE_LEVEL VARCHAR, USER_GENERATED VARCHAR, USER_ID VARCHAR, USER_NAME VARCHAR, USER_ROLE VARCHAR, USER_SPACE_ID VARCHAR, USER_SPACE_NAME VARCHAR, USER_TMP VARCHAR, USR_DISPLAY_NAME VARCHAR, USR_STATUS VARCHAR, USR_TITLE VARCHAR, USR_UDF_BUSINESSSEGMENTLEVEL1 VARCHAR, USR_UDF_BUSINESSSEGMENTLEVEL2 VARCHAR, USR_UDF_BUSINESSSEGMENTLEVEL3 VARCHAR, USR_UDF_BUSINESSSEGMENTLEVEL4 VARCHAR, USR_UDF_COMPANYNAME VARCHAR, USR_UDF_EMPLOYEEID VARCHAR, USR_UDF_PRIMARYDOMAIN VARCHAR, USR_UDF_SUPERVISORID VARCHAR, USR_UDF_SUPERVISORNAME VARCHAR, VIOLATING_USER VARCHAR, VIOLATING_USER_TYPE VARCHAR, WATCHLIST_NAME VARCHAR, WEB_UNIVERSAL_CONNECTOR VARCHAR, WEB_URL VARCHAR, WINDOWID NUMBER, WORKSPACE VARCHAR, WORKSPACE_ID VARCHAR, ZIP_PASSWORD VARCHAR, _ID VARCHAR, EXTRA_FIELDS VARIANT );
Events
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table> ( EVENT_TIME TIMESTAMP_NTZ, INGESTION_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, SOURCE_CONFIGURATION_NAME VARCHAR, ACCESS_METHOD VARCHAR, ACTING_USER VARCHAR, ACTION VARCHAR, ACTIVITY VARCHAR, ACTIVITY_TYPE VARCHAR, ALERT VARCHAR, ALERT_DETECTION_STAGE VARCHAR, ALERT_GENERATED BOOLEAN, ALERT_NAME VARCHAR, ALERT_TYPE VARCHAR, APP VARCHAR, APPACT VARCHAR, APPCATEGORY VARCHAR, APPSUITE VARCHAR, APP_ACTIVITY VARCHAR, APP_CCI_APPHOSTING_PROVIDER VARCHAR, APP_GDPR_LEVEL VARCHAR, APP_SESSION_ID NUMBER, ASN VARCHAR, ASSIGNEE VARCHAR, AS_ VARCHAR, -- as AUDIT_CATEGORY VARCHAR, AUDIT_LOG_EVENT VARCHAR, AUDIT_TYPE VARCHAR, BCC VARCHAR, BOOLEAN_METRIC_VALUE VARCHAR, BROWSER VARCHAR, BROWSER_SESSION_ID NUMBER, BROWSER_VERSION VARCHAR, BYPASS_REASON VARCHAR, BYPASS_TRAFFIC VARCHAR, CATEGORY VARCHAR, CC VARCHAR, CCI NUMBER, CCL VARCHAR, CHANNEL VARCHAR, CHANNEL_ID VARCHAR, CITY VARCHAR, CLASSIFICATION VARCHAR, CLIENT_BYTES NUMBER, CLIENT_INSTALL_TIME NUMBER, CLIENT_PACKETS NUMBER, CLIENT_VERSION VARCHAR, CLOUD_PROVIDER VARCHAR, COMPUTER_NAME VARCHAR, CONNECTION_ID NUMBER, CONNECTION_TYPE VARCHAR, CONN_DURATION NUMBER, CONN_ENDTIME NUMBER, CONN_STARTTIME NUMBER, CONONICALNAME VARCHAR, CONTINENT VARCHAR, COUNT NUMBER, COUNTRY VARCHAR, COUNT_METRIC_VALUE NUMBER, CREATED NUMBER, CUSTOM_ATTR VARIANT, CUSTOM_CONNECTOR VARCHAR, DATA_CENTER VARCHAR, DESTINATION_APP VARCHAR, DESTINATION_FILE_DIRECTORY VARCHAR, DESTINATION_FILE_NAME VARCHAR, DESTINATION_FILE_PATH VARCHAR, DESTINATION_INSTANCE_ID VARCHAR, DESTINATION_SITE VARCHAR, DETAILS VARIANT, DEVICE VARCHAR, DEVICE_CLASSIFICATION VARCHAR, DEVICE_HASH VARCHAR, DEVICE_ID VARCHAR, DEVICE_NAME VARCHAR, DEVICE_SN VARCHAR, DEVICE_TYPE VARCHAR, DINSID VARCHAR, DLP_FAIL_REASON VARCHAR, DLP_FILE VARCHAR, DLP_INCIDENT_ID NUMBER, DLP_IS_UNIQUE_COUNT VARCHAR, DLP_MAIL_PARENT_ID VARCHAR, DLP_MATCH_INFO VARIANT, DLP_PARENT_ID NUMBER, DLP_PROFILE VARCHAR, DLP_PROFILE_NAME VARCHAR, DLP_RULE VARCHAR, DLP_RULE_COUNT NUMBER, DLP_RULE_SEVERITY VARCHAR, DLP_SCAN_FAILED VARCHAR, DLP_UNIQUE_COUNT NUMBER, DNS_PROFILE VARCHAR, DOM VARCHAR, DOMAIN VARCHAR, DOMAIN_IP VARCHAR, DRIVER VARCHAR, DSTHOST VARCHAR, DSTIP VARCHAR, DSTPORT NUMBER, DST_COUNTRY VARCHAR, DST_GEOIP_SRC NUMBER, DST_LATITUDE FLOAT, DST_LOCATION VARCHAR, DST_LONGITUDE FLOAT, DST_REGION VARCHAR, DST_TIMEZONE VARCHAR, DST_ZIPCODE VARCHAR, DYNAMIC_CLASSIFICATION VARCHAR, EEML VARCHAR, EMAIL_FROM_USER VARCHAR, EMAIL_MODIFIED NUMBER, EMAIL_USER VARCHAR, ENCRYPTION_STATUS VARCHAR, ENDPOINT_POLICY_MATCH VARIANT, ENDPOINT_POLICY_MATCH_DESIRED_ACTION VARIANT, END_TIME VARCHAR, ENRICHED BOOLEAN, EVENT_RECOVERED BOOLEAN, EXECUTABLE_HASH VARCHAR, EXECUTABLE_SIGNED BOOLEAN, EXPOSURE VARCHAR, EXT_LABELS VARIANT, FILEPATH VARCHAR, FILE_LANG VARCHAR, FILE_MD5 VARCHAR, FILE_ORIGIN VARCHAR, FILE_OWNER VARCHAR, FILE_PATH VARCHAR, FILE_SIZE NUMBER, FILE_TYPE VARCHAR, FLLG VARCHAR, FLOW_STATUS VARCHAR, FLPP VARCHAR, FORWARD_TO_PROXY_PROFILE VARCHAR, FORWARD_TO_PROXY_XAU VARCHAR, FROMLOGS VARCHAR, FROM_USER VARCHAR, FROM_USER_CATEGORY VARCHAR, GUID VARCHAR, HEART_BEAT BOOLEAN, HOSTNAME VARCHAR, HOST_INFO_CLIENT_VERSION VARCHAR, HOST_INFO_DEVICE_MAKE VARCHAR, HOST_INFO_DEVICE_MODEL VARCHAR, HOST_INFO_HOSTNAME VARCHAR, HOST_INFO_LAST_UPDATE_TIMESTAMP NUMBER, HOST_INFO_MAC_ADDRESSES VARCHAR, HOST_INFO_MANAGEMENTID VARCHAR, HOST_INFO_NSDEVICEUID VARCHAR, HOST_INFO_OLD_NSDEVICEUID VARCHAR, HOST_INFO_OS NUMBER, HOST_INFO_OS_VERSION VARCHAR, HOST_INFO_SERIAL_NUMBER VARCHAR, HOST_INFO_STEERING_CONFIG VARCHAR, HTTP_TRANSACTION_COUNT NUMBER, INCIDENT_ID NUMBER, INLINE_DLP_MATCH_INFO VARIANT, INSTANCE VARCHAR, INSTANCE_ID VARCHAR, INTERNAL_COLLABORATOR_COUNT NUMBER, IP_PROTOCOL VARCHAR, ISP VARCHAR, JA3 VARCHAR, JA3S VARCHAR, JUSTIFICATION VARCHAR, JUSTIFICATION_REASON VARCHAR, JUSTIFICATION_TYPE VARCHAR, LAST_CONNECTED_FROM_PRIVATE_IP VARCHAR, LAST_CONNECTED_FROM_PUBLIC_IP VARCHAR, LAST_EVENT_TIMESTAMP NUMBER, LAST_SEEN_DEVICE_EVENT_ACTOR NUMBER, LAST_SEEN_DEVICE_EVENT_EVENT NUMBER, LAST_SEEN_DEVICE_EVENT_EVENT_DETAILS VARCHAR, LAST_SEEN_DEVICE_EVENT_NPA_STATUS NUMBER, LAST_SEEN_DEVICE_EVENT_SERVICE_NAME VARCHAR, LAST_SEEN_DEVICE_EVENT_STATUS NUMBER, LAST_SEEN_DEVICE_EVENT_STATUS_V2 NUMBER, LAST_SEEN_DEVICE_EVENT_TIMESTAMP NUMBER, LATEST_INCIDENT_ID NUMBER, LATITUDE FLOAT, LEGAL_HOLD_PROFILE_NAME VARCHAR, LH_CUSTODIAN_EMAIL VARCHAR, LH_CUSTODIAN_NAME VARCHAR, LH_DEST_APP VARCHAR, LH_DEST_INSTANCE VARCHAR, LH_FILEID VARCHAR, LH_FILENAME VARCHAR, LH_FILEPATH VARCHAR, LH_ORIGINAL_FILENAME VARCHAR, LH_SHARED VARCHAR, LH_SHARED_WITH VARCHAR, LH_VERSION VARCHAR, LOCAL_SOURCE_TIME VARCHAR, LOCATION VARCHAR, LOGINTYPE VARCHAR, LOGINURL VARCHAR, LOG_FILE_NAME VARCHAR, LONGITUDE FLOAT, MAL_SEV VARCHAR, MANAGED_APP VARCHAR, MANAGEMENTID VARCHAR, MCP_ACTIVITY VARCHAR, MCP_CLIENT_CAPABILITIES VARCHAR, MCP_CLIENT_NAME VARCHAR, MCP_CLIENT_PROTOCOL_VERSION VARCHAR, MCP_METHOD VARCHAR, MCP_PROMPT_LIST VARCHAR, MCP_PROMPT_NAME VARCHAR, MCP_PROTOCOL_VERSION VARCHAR, MCP_RESOURCE_LIST VARCHAR, MCP_RESOURCE_URL VARCHAR, MCP_SERVER_CAPABILITIES VARCHAR, MCP_SERVER_NAME VARCHAR, MCP_SERVER_PROTOCOL_VERSION VARCHAR, MCP_TOOL_LIST VARCHAR, MCP_TOOL_NAME VARCHAR, MD5 VARCHAR, METRIC_NAME VARCHAR, METRIC_TRUE_COUNT VARCHAR, METRIC_TYPE VARCHAR, METRIC_VALUE VARCHAR, MIME_TYPE VARCHAR, MODIFIED NUMBER, NETSKOPE_ACTIVITY VARCHAR, NETSKOPE_POP VARCHAR, NETWORK VARCHAR, NETWORK_SESSION_ID VARCHAR, NOTIFY_TEMPLATE VARCHAR, NSDEVICEUID VARCHAR, NS_ACTIVITY VARCHAR, NUMBYTES NUMBER, NUM_SESSIONS NUMBER, NUM_USERS NUMBER, OAUTH VARCHAR, OBJECT VARCHAR, OBJECT_ID VARCHAR, OBJECT_TYPE VARCHAR, ORG VARCHAR, ORGANIZATION_ VARCHAR, ORGANIZATION_UNIT VARCHAR, ORIGINAL_FILE_SNAPSHOT_ID VARCHAR, ORIGNAL_FILE_PATH VARCHAR, OS VARCHAR, OS_DETAILS VARCHAR, OS_FAMILY VARCHAR, OS_USER_NAME VARCHAR, OS_VERSION VARCHAR, OTHER_CATEGORIES VARIANT, OWNER VARCHAR, OWNER_PDL VARCHAR, PACKAGE_VERSION VARCHAR, PAGE VARCHAR, PAGE_SITE VARCHAR, PARENT_ID VARCHAR, PARENT_PROCESS_NAME VARCHAR, PID VARCHAR, POLICY VARCHAR, POLICY_ACTION VARCHAR, POLICY_ACTION_ENFORCED VARCHAR, POLICY_ID VARCHAR, POLICY_NAME VARCHAR, POLICY_NAME_ENFORCED VARCHAR, POLICY_VERSION VARCHAR, POP_NAME VARCHAR, POP_PINNED VARCHAR, PORT VARCHAR, POSTAL_CODE VARCHAR, PRINTER_IDENTIFIER VARCHAR, PROCESS_CERT_SUBJECT VARCHAR, PROCESS_NAME VARCHAR, PROCESS_PATH VARCHAR, PRODUCT_ID VARCHAR, PROTOCOL VARCHAR, PROTOCOL_PORT VARCHAR, PUBLISHER_CN VARCHAR, PUBLISHER_IP VARCHAR, PUBLISHER_NAME VARCHAR, PUBLISHER_POP VARCHAR, PUBLISHER_PORT NUMBER, QDOMAIN VARCHAR, QTYPE VARCHAR, Q_SHARED_WITH VARCHAR, RBI_TEMPLATE_ID VARCHAR, RBI_TEMPLATE_NAME VARCHAR, RECORD_TYPE VARCHAR, REFERER VARCHAR, REGION VARCHAR, REQ VARCHAR, REQUEST_ID NUMBER, REQ_CNT NUMBER, RESP VARCHAR, RESPONSE_TIME NUMBER, RESP_CNT NUMBER, RESP_CONTENT_LEN NUMBER, RESP_CONTENT_TYPE VARCHAR, RETRO_SCAN_NAME VARCHAR, RISK_SCORE NUMBER, SAMACCOUNTNAME VARCHAR, SAMPLED_TEXT_SIZE NUMBER, SANCTIONED_INSTANCE VARCHAR, SA_RULE_COMPLIANCE VARCHAR, SCAN_TYPE VARCHAR, SERIAL VARCHAR, SERVERITY VARCHAR, SERVER_BYTES NUMBER, SERVER_PACKETS NUMBER, SESSIONID VARCHAR, SESSION_DURATION NUMBER, SESSION_NUMBER_UNIQUE NUMBER, SEVERITY VARCHAR, SEVERITY_LEVEL VARCHAR, SHA256 VARCHAR, SHARED_WITH VARCHAR, SITE VARCHAR, SMTP_BLOCK_REASON VARCHAR, SMTP_CLIENT_DOMAIN VARCHAR, SMTP_TO VARIANT, SOURCE_FILE_DIRECTORY VARCHAR, SOURCE_FILE_NAME VARCHAR, SOURCE_FILE_PATH VARCHAR, SPET NUMBER, SPST NUMBER, SRCIP VARCHAR, SRCPORT NUMBER, SRC_COUNTRY VARCHAR, SRC_GEOIP_SRC NUMBER, SRC_LATITUDE FLOAT, SRC_LOCATION VARCHAR, SRC_LONGITUDE FLOAT, SRC_NETWORK VARCHAR, SRC_REGION VARCHAR, SRC_TIME VARCHAR, SRC_TIMEZONE VARCHAR, SRC_ZIPCODE VARCHAR, SSL_DECRYPT_POLICY VARCHAR, START_TIME VARCHAR, STATUS VARCHAR, SUB_TYPE VARCHAR, SUPPORTING_DATA VARIANT, SUPPRESSION_END_TIME NUMBER, SUPPRESSION_KEY VARCHAR, SUPPRESSION_START_TIME NUMBER, TAGS VARCHAR, TELEMETRY_APP VARCHAR, THR VARCHAR, THREAT_TYPE VARCHAR, TIMESTAMP NUMBER, TITLE VARCHAR, TOTAL_COLLABORATOR_COUNT NUMBER, TOTAL_PACKETS NUMBER, TO_USER VARCHAR, TRAFFIC_TYPE VARCHAR, TRANSACTION_ID NUMBER, TRUE_OBJ_CATEGORY VARCHAR, TRUE_OBJ_TYPE VARCHAR, TSS_FAIL_REASON VARCHAR, TSS_MODE VARCHAR, TSS_SCAN_FAILED VARCHAR, TUNNEL_ID VARCHAR, TUNNEL_TYPE VARCHAR, TUNNEL_UP_TIME NUMBER, TUR VARCHAR, TYPE VARCHAR, UNC_PATH VARCHAR, UNIVERSAL_CONNECTOR VARCHAR, URL VARCHAR, UR_NORMALIZED VARCHAR, USB_DEVICE VARCHAR, USER VARCHAR, USERAGENT VARCHAR, USERIP VARCHAR, USERKEY VARCHAR, USERPRINCIPALNAME VARCHAR, USER_CATEGORY VARCHAR, USER_CONFIDENCE_INDEX NUMBER, USER_CONFIDENCE_LEVEL VARCHAR, USER_GENERATED VARCHAR, USER_ID VARCHAR, USER_INFO_DEVICE_CLASSIFICATION_STATUS NUMBER, USER_INFO_ORGKEY VARCHAR, USER_INFO_USERKEY VARCHAR, USER_INFO_USERNAME VARCHAR, VENDOR_ID VARCHAR, VIOLATION VARCHAR, WEB_UNIVERSAL_CONNECTOR VARCHAR, WORKSPACE VARCHAR, WORKSPACE_ID VARCHAR, ZIPCODE VARCHAR, ZIP_FILE_ID VARCHAR, ZIP_PASSWORD VARCHAR, _ID VARCHAR, EXTRA_FIELDS VARIANT );
WebTX
CREATE TABLE IF NOT EXISTS <db>.<schema>.<table>( EVENT_TIME TIMESTAMP_NTZ, INGESTION_TIME TIMESTAMP_NTZ, DATA_TYPE VARCHAR, SUBTYPE VARCHAR, SOURCE_CONFIGURATION_NAME VARCHAR, BYTES NUMBER, CS_BYTES NUMBER, CS_CONTENT_TYPE VARCHAR, CS_HOST VARCHAR, CS_METHOD VARCHAR, CS_REFERER VARCHAR, CS_URI_PORT NUMBER, CS_URI_QUERY VARCHAR, CS_URI_SCHEME VARCHAR, CS_USER_AGENT VARCHAR, RS_BYTES NUMBER, RS_STATUS NUMBER, SC_BYTES NUMBER, SC_CONTENT_TYPE VARCHAR, SC_STATUS NUMBER, SR_BYTES NUMBER, TIME_TAKEN NUMBER, X_ACTION VARCHAR, X_ACTION_REASON VARCHAR, X_CATEGORY VARCHAR, X_CLIENT_SSL_ERR VARCHAR, X_CS_ACCESS_METHOD VARCHAR, X_CS_ACCESS_PROXY VARIANT, X_CS_APP VARCHAR, X_CS_APP_ACTIVITY VARCHAR, X_CS_APP_CATEGORY VARCHAR, X_CS_APP_CCI NUMBER, X_CS_APP_CCL VARCHAR, X_CS_APP_FROM_USER VARCHAR, X_CS_APP_INSTANCE_ID VARCHAR, X_CS_APP_INSTANCE_NAME VARCHAR, X_CS_APP_INSTANCE_TAGS VARIANT, X_CS_APP_OBJECT_ID VARCHAR, X_CS_APP_OBJECT_NAME VARCHAR, X_CS_APP_OBJECT_TYPE VARCHAR, X_CS_APP_SUITE VARCHAR, X_CS_APP_TAGS VARCHAR, X_CS_APP_TO_USER VARCHAR, X_CS_CONNECT_HOST VARCHAR, X_CS_CONNECT_PORT NUMBER, X_CS_CONNECT_USER_AGENT VARCHAR, X_CS_CONNECT_XAU VARCHAR, X_CS_DST_IP VARCHAR, X_CS_DST_PORT NUMBER, X_CS_HTTP_VERSION VARCHAR, X_CS_IP_CONNECT_XFF VARCHAR, X_CS_IP_XFF VARCHAR, X_CS_NSCLIENT_TUNNEL_TYPE VARCHAR, X_CS_PAGE_ID NUMBER, X_CS_PARENT_PROCESS VARCHAR, X_CS_PID NUMBER, X_CS_PPID NUMBER, X_CS_PROCESS VARCHAR, X_CS_SESSION_ID NUMBER, X_CS_SITE VARCHAR, X_CS_SNI VARCHAR, X_CS_SRC_IP VARCHAR, X_CS_SRC_IP_EGRESS VARCHAR, X_CS_SRC_PORT NUMBER, X_CS_SSL_CIPHER VARCHAR, X_CS_SSL_ENGINE_ACTION VARCHAR, X_CS_SSL_ENGINE_ACTION_REASON VARCHAR, X_CS_SSL_FRONTING_ERROR VARCHAR, X_CS_SSL_HANDSHAKE_ERROR VARCHAR, X_CS_SSL_JA3 VARCHAR, X_CS_SSL_MALFORMED_SSL VARCHAR, X_CS_SSL_VERSION VARCHAR, X_CS_TIMESTAMP NUMBER, X_CS_TRAFFIC_TYPE VARCHAR, X_CS_TUNNEL_ID VARCHAR, X_CS_URI_PATH VARCHAR, X_CS_URL VARCHAR, X_CS_XAU VARCHAR, X_C_AUTHN_SOURCE VARCHAR, X_C_AUTHN_SURROGATE VARCHAR, X_C_AUTHN_SURROGATE_STATUS VARCHAR, X_C_AUTHN_USER VARCHAR, X_C_AUTHZ_GROUPS VARIANT, X_C_AUTHZ_OU VARCHAR, X_C_AUTHZ_SOURCE VARCHAR, X_C_BROWSER VARCHAR, X_C_BROWSER_VERSION NUMBER, X_C_COUNTRY VARCHAR, X_C_DEVICE VARCHAR, X_C_DEVICE_CLASSIFICATION VARCHAR, X_C_DEVICE_UID VARCHAR, X_C_HOSTNAME VARCHAR, X_C_LATITUDE FLOAT, X_C_LOCAL_TIMESTAMP NUMBER, X_C_LOCATION VARCHAR, X_C_LONGITUDE FLOAT, X_C_NSCLIENT_CLIENT_PROFILE VARCHAR, X_C_NSCLIENT_STEERING_PROFILE VARCHAR, X_C_NSCLIENT_VERSION VARCHAR, X_C_OS VARCHAR, X_C_OS_FAMILY VARCHAR, X_C_OS_VERSION VARCHAR, X_C_REGION VARCHAR, X_C_TIMEZONE VARCHAR, X_C_USER_CONFIDENCE_INDEX NUMBER, X_C_ZIPCODE NUMBER, X_EIP_POLICY_FOOTPRINT VARCHAR, X_EIP_POLICY_NAME VARCHAR, X_ERROR VARCHAR, X_POLICY_ACTION VARCHAR, X_POLICY_CATEGORIES VARIANT, X_POLICY_DST_HOST VARCHAR, X_POLICY_DST_HOST_SOURCE VARCHAR, X_POLICY_DST_IP VARCHAR, X_POLICY_JUSTIFICATION_REASON VARCHAR, X_POLICY_JUSTIFICATION_TYPE VARCHAR, X_POLICY_NAME VARCHAR, X_POLICY_SRC_IP VARCHAR, X_REQUEST_ID NUMBER, X_RS_FILE_CATEGORY VARCHAR, X_RS_FILE_LANGUAGE VARCHAR, X_RS_FILE_MD5 VARCHAR, X_RS_FILE_SHA256 VARCHAR, X_RS_FILE_SIZE NUMBER, X_RS_FILE_TYPE VARCHAR, X_R_CERT_END NUMBER, X_R_CERT_EXPIRED VARCHAR, X_R_CERT_INCOMPLETE_CHAIN VARCHAR, X_R_CERT_ISSUER_CN VARCHAR, X_R_CERT_MISMATCH VARCHAR, X_R_CERT_REVOCATION_CHECK VARCHAR, X_R_CERT_REVOKED VARCHAR, X_R_CERT_SELF_SIGNED VARCHAR, X_R_CERT_START NUMBER, X_R_CERT_SUBJECT_CN VARCHAR, X_R_CERT_UNTRUSTED_ROOT VARCHAR, X_R_CERT_VALID VARCHAR, X_R_COUNTRY VARCHAR, X_R_LATITUDE FLOAT, X_R_LOCATION VARCHAR, X_R_LONGITUDE FLOAT, X_R_REGION VARCHAR, X_R_ZIPCODE VARCHAR, X_SC_NOTIFICATION_NAME VARCHAR, X_SERVER_SSL_ERR VARCHAR, X_SR_DST_IP VARCHAR, X_SR_DST_PORT NUMBER, X_SR_FORWARD_DEST VARCHAR, X_SR_HEADERS_NAME VARCHAR, X_SR_HEADERS_VALUE VARCHAR, X_SR_SRC_IP VARCHAR, X_SR_SRC_PORT NUMBER, X_SR_SSL_CIPHER VARCHAR, X_SR_SSL_CLIENT_CERTIFICATE_ERROR VARCHAR, X_SR_SSL_ENGINE_ACTION VARCHAR, X_SR_SSL_ENGINE_ACTION_REASON VARCHAR, X_SR_SSL_HANDSHAKE_ERROR VARCHAR, X_SR_SSL_JA3S VARCHAR, X_SR_SSL_MALFORMED_SSL VARCHAR, X_SR_SSL_VERSION VARCHAR, X_SSL_BYPASS VARCHAR, X_SSL_BYPASS_REASON VARCHAR, X_SSL_POLICY_ACTION VARCHAR, X_SSL_POLICY_CATEGORIES VARCHAR, X_SSL_POLICY_DST_HOST VARCHAR, X_SSL_POLICY_DST_HOST_SOURCE VARCHAR, X_SSL_POLICY_DST_IP VARCHAR, X_SSL_POLICY_ISSUER VARCHAR, X_SSL_POLICY_NAME VARCHAR, X_SSL_POLICY_SRC_IP VARCHAR, X_SUPPORT VARCHAR, X_S_CUSTOM_SIGNING_CA_ERROR VARCHAR, X_S_DP_NAME VARCHAR, X_TENANT_ID NUMBER, X_TP_ENGINE VARIANT, X_TP_MALWARE_NAME VARIANT, X_TP_RESULT VARIANT, X_TP_SEVERITY VARIANT, X_TRANSACTION_ID NUMBER, X_TYPE VARCHAR, EXTRA_FIELDS VARIANT );
Grant Permissions for Database, Schema, and Table(s) in Snowflake
-
Log in to your Snowflake instance and go to Projects > Workspace.

-
Create a new workspace or use any of the existing workspace, click Add New > SQL File. Paste thesequeries in the sql file and execute them one by one:
-- Role, scoped to exactly this database/schema/table(s) CREATE ROLE IF NOT EXISTS NETSKOPE_CE_ROLE; GRANT USAGE ON DATABASE NETSKOPE_DB TO ROLE NETSKOPE_CE_ROLE; GRANT USAGE ON SCHEMA NETSKOPE_DB.PUBLIC TO ROLE NETSKOPE_CE_ROLE; GRANT INSERT ON TABLE NETSKOPE_DB.PUBLIC.NETSKOPE_LOGS TO ROLE NETSKOPE_CE_ROLE; -- repeat the GRANT INSERT line per table if you're in Per Data Type mode GRANT INSERT ON TABLE <db>.<schema>.<table> TO ROLE NETSKOPE_CE_ROLE; -- Service user, locked to that role CREATE USER IF NOT EXISTS NETSKOPE_CE_USER TYPE = SERVICE DEFAULT_ROLE = NETSKOPE_CE_ROLE; GRANT ROLE NETSKOPE_CE_ROLE TO USER NETSKOPE_CE_USER; -- Programmatic Access Token, welded to that role — not to ACCOUNTADMIN or any broader role ALTER USER NETSKOPE_CE_USER ADD PROGRAMMATIC ACCESS TOKEN NETSKOPE_CE_TOKEN ROLE_RESTRICTION = 'NETSKOPE_CE_ROLE' DAYS_TO_EXPIRY = 365;
Make sure you update the database name, schema name, and table names and DAYS_TO_EXPIRY as per your requirement. -
Copy the generated token as it will be used for configuring the plugin.
Get your Snowflake Account URL
-
Log in to your Snowflake instance and navigate to Account > View Account Details page.

-
Copy the Account/Server URL. Make sure you add https:// at the beginning of the URL.

Configure the Snowflake Plugin
-
In Cloud Exchange, go to Settings > Plugin Store. Search for and select the Snowflake v1.0.0 (CLS) plugin.

-
Enter a plugin configuration name, and make sure you have the Snowflake Default Mapping file selected.

-
Click Next and enter the Configuration Parameters:
- Account URL: Your Snowflake account URL. Make sure you add https:// at the beginning of the URL.
- Programmatic Access Token: The Programmatic Access Token for the Snowflake user you created previously.
- Database: Snowflake database holding the target table(s). The database name provided must exactly match what is present on Snowflake.
- Schema: Snowflake schema within the Database above. The schema name provided must exactly match what is present in Snowflake.
- Ingestion Mode: How many tables this configuration writes to. ‘Single Table’ sends Alerts, Events and WebTx to one table. ‘Per Data Type’ sends each selected data type to its own table.
- Per Data Type (One Table per Type)
- Alerts Table Name: Table that receives Alerts. Fill this in to ingest Alerts; leave it blank to skip them. Case-sensitive – must exactly match the name Snowflake stores the table under. It must already exist.
- Events Table Name: Table that receives Events. Fill this in to ingest Events; leave it blank to skip them. Case-sensitive: must exactly match the name Snowflake stores the table under, and it must already exist.
- WebTx Table Name: Table that receives WebTx. Fill this in to ingest WebTx; leave it blank to skip it. Case-sensitive – must exactly match the name Snowflake stores the table under. It must already exist.
- Single Table
Table Name: Table that receives Alerts, Events and WebTx. It must be a Combined-mode table, one with a RAW_DATA VARIANT column, because a Single Table does not support Separate Fields. The name provided must exactly match what is present on Snowflake.
- Per Data Type (One Table per Type)


-
Click Save. Your new plugin appears on the Log Shipper > Plugins page.

Configure a Log Shipper Business Rule for Snowflake
-
In Log Shipper, go to the Business Rules.
-
By default, there is a business rule that filters all alerts and events. If you want to filter out any specific type of alert or event, click Create New Rule and configure a new business rule by adding the rule name and filter(s).

-
Click Save.

Configure Log Shipper Log Delivery for Snowflake
-
In Log Shipper, go Log Delivery and click Add Log Delivery Configuration.
-
Select the Source plugin (CLS Netskope Log Shipper or any other source plugin), Destination plugin (CLS Snowflake), a business rule. For WebTx, select Source plugin (CLS AWS Netskope LogStreaming), and Destination plugin (CLS Snowflake). When finished, click Save.
-
After the Log Delivery is added, the data will start to be pulled from the Netskope tenant or source platform then transformed, and ingested into the Snowflake platform.


Validate the Snowflake Plugin
Validate the Pull
To validate the pulling of Events, Alerts and WebTX, go to Logging in Cloud Exchange and search for the pulled logs.







Validate the Push
To validate the plugin workflow in Cloud Exchange:
Go to Logging and Search for ingested Events, Alerts, WebTx and Logs with the filter “message contains ingested”. The ingested logs will be filtered.











To validate the push on the Snowflake:
Log in to your Snowflake instance and go to Project > Workspace.

Create a new workspace or use an already created workspace to execute the query.
Here are some of the ingested Alerts, Events and WebTX in a table with separate column:







Here are some of the ingested Alerts, Events and WebTX in a separate tables with combined format:



Here are some of the ingested Alerts, Events and WebTX in a combined table:


Sample ingested alerts, events and WebTX with custom mapping:



Troubleshooting the Snowflake Plugin
Authentication or Authorization Failure
If the user encounters an “Authentication or authorization failed. Verify the Account Identifier and the credentials…” error, it could be due to one of the following reasons:
- The Programmatic Access Token is wrong, expired, or revoked.
- The Snowflake user is blocked by a network policy that does not allow the CE node’s egress IP.
- The role behind the token lacks INSERT on the target table or USAGE on the database or schema.
What to do:
- Verify that the Programmatic Access Token is valid and has not expired.
- Ensure that the CE node’s egress IP is allowed by any network policy covering the Snowflake user.
- Confirm that the role has USAGE on the database and schema, and INSERT on each target table. Refer to the Configuration on Snowflake instance section.
Getting error on the plugin card
If you observe errors on the plugin card but no corresponding error logs, it may be because some data was skipped by the destination plugin due to its configuration parameters. In such cases, the plugin card may display an error even though no explicit error logs are generated.


What to do: If you are using different tables for alerts/events/WebTx and only provide table names for any 1 or 2 tables then make sure the business rule does not filter any additional data.
Table Not Found
If the user encounters a “Table ‘<table>’ was not found, or the role behind these credentials cannot see it.” error, it could be due to one of these reasons:
- The table does not exist in the configured database and schema.
- The table name, database name, or schema name is typed with the wrong case.
- The role behind the token does not have visibility of the table.
What to do: To solve the above-mentioned issue, follow the points mentioned below.
- Verify that the table exists in the configured database and schema in Snowflake.
- Ensure the Database, Schema, and Table Name values match exactly the case stored in Snowflake.
- Confirm that the role has sufficient privileges so that SHOW COLUMNS returns the table’s columns. Refer to the Configuration on Snowflake instance section
Single Table Mode Points at a Separate Fields Table
If the user encounters a “Table ‘<table>’ has no RAW_DATA column, so it would be used in ‘Separate Fields’ mode, which is not supported with ‘Single Table’ ingestion.” error, it could be due to the following reason:
The table configured for Single Table ingestion mode does not have a RAW_DATA VARIANT column.
What to do: To solve the above-mentioned issue, follow the points mentioned below.
Switch the Ingestion Mode to Per Data Type and assign a separate table per data type, or create a new Snowflake table with a RAW_DATA VARIANT column and update the configuration.
Snowpipe Streaming reports “Ingested successfully” but the target table stays empty — verify with Snowflake’s ERROR_TABLE
The snowflake_cls plugin ingests rows via Snowflake’s Snowpipe Streaming REST API. This API acknowledges a request synchronously (HTTP 200, status_code: 0) as soon as the payload is parsed — the actual row-by-row validation and commit into the table happens asynchronously, afterward, inside Snowflake. This means:
CE’s own logs will show “Sent N of N log(s) to table ‘<table>'” and “Ingested N … successfully” — a clean, error-free run from CE’s point of view. But if even one column’s incoming value doesn’t match its declared Snowflake type (e.g. a text value sent into a NUMBER column), Snowflake silently rejects that row after telling the plugin it succeeded. CE has no way to detect this on its own. Net effect: the plugin reports 100% success, but SELECT COUNT(*) on the target table shows far fewer rows than were “ingested” — in the worst case, zero.
What to do:
-
Turn on error logging for the target table (one-time, per table):
ALTER TABLE NETSKOPE_DB.PUBLIC.NETSKOPE_WEBTX_SC SET ERROR_LOGGING = TRUE;
This tells Snowflake to retain the asynchronous validation failures from Snowpipe Streaming so they become queryable, instead of disappearing silently.
-
Re-run the ingestion (or just let the next scheduled batch run) so failing rows are captured by the now-enabled error log.
-
Query the error table to see exactly why and where it’s failing:
SELECT TIMESTAMP, ERROR_METADATA:error_message::STRING AS WHY, ERROR_METADATA:error_source::STRING AS COLUMN_AT_FAULT, ERROR_DATA:"$1"::STRING AS ORIGINAL_ROW FROM ERROR_TABLE(NETSKOPE_DB.PUBLIC.NETSKOPE_WEBTX_SC) WHERE ERROR_METADATA:service::STRING = 'snowpipe_streaming' ORDER BY TIMESTAMP DESC;This returns the actual Snowflake-side error message, the offending column, and the raw row content — the exact diagnostic CE’s own logs cannot provide.
-
Cross-check every column’s data type against the source schema, to catch the mismatch class of bug before it happens again:
SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_PRECISION, NUMERIC_SCALE, CHARACTER_MAXIMUM_LENGTH FROM NETSKOPE_DB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'NETSKOPE_WEBTX_SC' ORDER BY ORDINAL_POSITION;
Compare this against the Netskope Tenant’s documented/expected schema — any String-typed source field landing on a NUMBER/FLOAT column, or a numeric field whose actual values aren’t plain numbers (version strings, comma-joined lists, “N/A”, etc.), is a prime candidate for this failure mode.
-
Fix the source data (preferred) or the column type, re-run, and verify:
- ERROR_TABLE(…) returns no new rows for the latest run, and
- SELECT COUNT(*) on the target table matches the plugin’s logsIngested count exactly.
Known Behaviors
- The column mode (Combined or Separate Fields) is detected automatically from the target table structure. A table that has a RAW_DATA VARIANT column is used in Combined mode; a table without it is used in Separate Fields mode. This is not a configurable field.
- Single Table ingestion mode supports Combined tables only. Pointing a Single Table configuration at a table without a RAW_DATA column is rejected during validation.
- The plugin never creates or alters tables, databases, schemas, users, roles, or grants in Snowflake. All target objects must exist before saving the configuration.
- If the table columns are altered on the Snowflake instance then the user needs to edit the CLS Snowflake plugin configuration to reflect the changes in the plugin configuration.

