Snowflake

Publisher: Splunk
Connector Version: 1.1.3
Product Vendor: Snowflake
Product Name: Snowflake
Product Version Supported (regex): ".*"
Minimum Product Version: 6.2.1

This app supports investigative and data manipulation actions on Snowflake

Port Details

The app uses HTTPS protocol for communicating with Snowflake. Below are the default ports used by the Splunk SOAR Connector.

SERVICE NAME	TRANSPORT PROTOCOL	PORT
https	tcp	443

Roles

Roles are used by Snowflake to control access to objects within the organization and allow users to perform actions against those objects. Users can have several roles granted to them, and can also have a default role assigned. Since a user is allowed to switch roles during a session in order to have the appropriate permissions to perform certain actions, the Snowflake app accomodates this by having an optional 'role' parameter in each of the actions. If this parameter is left blank, the default role assigned to the user will be used.

Configuration Variables

The below configuration variables are required for this Connector to operate. These variables are specified when configuring a Snowflake asset in SOAR.

VARIABLE	REQUIRED	TYPE	DESCRIPTION
account	required	string	Account Identifier (i.e. .snowflakecomputing.net, not the entire URL)
username	required	string	Username
password	required	password	Password

Supported Actions

test connectivity - Validate the asset configuration for connectivity using supplied configuration
run query - Perform a SQL query
disable user - Disable a Snowflake user
show network policies - List available network policies
describe network policy - List the details of a network policy
update network policy - Update an existing network policy
remove grants - Remove a specified granted role from a Snowflake user

action: 'test connectivity'

Validate the asset configuration for connectivity using supplied configuration

Type: test
Read only: True

Action Parameters

No parameters are required for this action

Action Output

No Output

action: 'run query'

Perform a SQL query

Type: investigate
Read only: False

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
query	required	Query string	string	sql query
role	optional	Role to use to execute action	string
warehouse	optional	Warehouse	string
database	optional	Database	string
schema	optional	Schema	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.data	string
action_result.status	string		success
action_result.message	string		Total rows: 4
action_result.summary.total_rows	numeric		4
action_result.parameter.role	string		accountadmin
action_result.parameter.query	string	sql query	select * from test_table;
action_result.parameter.schema	string		testschema
action_result.parameter.database	string		test1db
action_result.parameter.warehouse	string		warehouse1
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1

action: 'disable user'

Disable a Snowflake user

Type: investigate
Read only: False

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
username	required	Snowflake user name	string	user name
role	optional	Role to use to execute action	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.parameter.username	string	user name	test1
action_result.data.*.status	string		Statement executed successfully.
action_result.status	string		success
action_result.message	string		Status: Statement executed successfully.
action_result.summary.status	string		Statement executed successfully.
action_result.parameter.role	string		accountadmin
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1

action: 'show network policies'

List available network policies

Type: investigate
Read only: True

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
role	optional	Role to use to execute action	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.data.*.name	string		MYPOLICY1
action_result.parameter.role	string		accountadmin
action_result.data.*.comment	string		testing app
action_result.data.*.created_on	string		2022-12-19 14:10:12.084000-08:00
action_result.data.*.entries_in_allowed_ip_list	numeric		2
action_result.data.*.entries_in_blocked_ip_list	numeric		1
action_result.status	string		success
action_result.message	string		Total policies: 1
action_result.summary.total_policies	numeric		1
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1

action: 'describe network policy'

List the details of a network policy

Type: investigate
Read only: True

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
policy_name	required	Name of policy to describe	string	snowflake policy name
role	optional	Role to use to execute action	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.data.*.name	string		ALLOWED_IP_LIST
action_result.data.*.value	string	ip	192.168.1.0/24,192.168.2.0/24
action_result.status	string		success
action_result.message	string
action_result.parameter.policy_name	string	snowflake policy name	mypolicy1
action_result.parameter.role	string		accountadmin
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1

action: 'update network policy'

Update an existing network policy

Type: investigate
Read only: False

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
policy_name	required	Name of network policy to update	string	snowflake policy name
role	optional	Role to use to execute action	string
allowed_ip_list	optional	Comma-separated list of IPs to replace current allow list. Add an empty list to clear all IPs from allow list.	string
blocked_ip_list	optional	Comma-separated list of IPs to replace current block list. Add an empty list to clear all IPs from block list.	string
comment	optional	Replace current comment on network policy	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.data.*.status	string		Statement executed successfully.
action_result.status	string		success
action_result.message	string		Network policy mypolicy1 was updated successfully
action_result.parameter.comment	string		updated policy a new update
action_result.parameter.policy_name	string	snowflake policy name	mypolicy1
action_result.parameter.role	string		accountadmin
action_result.parameter.allowed_ip_list	string		192.168.1.0/24, 192.168.2.0/24 192.168.10.0/24
action_result.parameter.blocked_ip_list	string		192.168.1.1, 192.168.2.1 192.168.10.1, 192.168.10.5, 192.168.10.6
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1

action: 'remove grants'

Remove a specified granted role from a Snowflake user

Type: investigate
Read only: False

Action Parameters

PARAMETER	REQUIRED	DESCRIPTION	TYPE	CONTAINS
username	required	Username	string	user name
role_to_remove	required	Role to remove from user	string
role	optional	Role to use to execute action	string

Action Output

DATA PATH	TYPE	CONTAINS	EXAMPLE VALUES
action_result.data.*.status	string		Statement executed successfully.
action_result.status	string		success
action_result.message	string		Role accountadmin was successfully removed from user
action_result.parameter.username	string	user name	test2
action_result.parameter.role_to_remove	string		accountadmin
summary.total_objects	numeric		1
summary.total_objects_successful	numeric		1