Skip to main content

Snowflake Credentials

Description#

General#

  • Documentation: https://docs.snowflake.com/en/
  • Summary: Snowflake is a cloud-based data warehousing company that offers various data storage and associated analytics services. The services can be accessed using various drivers, and authenticating with a username and password. This detector looks for snowflake uri connection patterns.
  • IPs allowlist: Snowflake allows to restrict the access to a given IPs allowlist. See documentation for more details.
  • Scopes: The access to given databases and resources can be customized and revoked using Snowflake SQL queries. See the documentation for more details on users and security management.

Revoke the secret#

User accesses to given databases and resources can be customized and revoked using SQL queries.

Check for suspicious activity#

A user can display login history in a Snowflake query to audit recent connection attempts.

Details for Snowflake uri#

  • Category: Data storage

  • Company: Snowflake

  • High recall: True

  • Validity check available: False

  • Minimum number of matches: 8

  • Occurrences found for one million commits: very rare

  • Prefixed: True

  • PreValidators:

- type: FilenameBanlistPreValidator  banlist_extensions:  - ^(cs|x|p|s|r)?html5?~?$  - ^[aps]?cssc?~?$  - ^lock$  - ^mdx?~?$  - ^storyboard(c|er)?~?$  - ^xib$  banlist_filenames: []  check_binaries: false- type: ContentWhitelistPreValidator  patterns:  - snowflakecomputing\.com

Examples#

- text: >    CONNECTION_URI="db:snowflake://root:m42ploz2wd@aze4567.us-east-12.snowflakecomputing.com/thegift"  host: aze4567.us-east-12.snowflakecomputing.com  username: root  password: m42ploz2wd  scheme: snowflake  database: thegift  connection_uri: snowflake://root:m42ploz2wd@aze4567.us-east-12.snowflakecomputing.com/thegift
# Test special characters in password- text: >    CONNECTION_URI="db:snowflake://root:m42p!o@2wd@aze4567.us-east-12.snowflakecomputing.com/thegift"  host: aze4567.us-east-12.snowflakecomputing.com  username: root  password: m42p!o@2wd  scheme: snowflake  database: thegift  connection_uri: snowflake://root:m42p!o@2wd@aze4567.us-east-12.snowflakecomputing.com/thegift