Snowflake FAQ and Troubleshooting
This article contains:
- A list of frequently asked questions related to connecting Snowflake to Tenable One Cloud Exposure. For detailed integration instructions, see Connect Snowflake.
- Account status and troubleshooting information.
Permissions and Integration
During integration, Tenable is granted the necessary permissions to scan your Snowflake environment. These include:
- MONITOR USAGE on the account — Allows Tenable to view account-level usage information.
- MONITOR on the account — Allows Tenable to view the operational status and metadata of account resources.
- USAGE on the Tenable dedicated warehouse — Grants access to the compute resource used for scanning.
- IMPORT SHARE on the account — Allows the integration to import shared data at the account level. This permission is granted automatically during DSPM onboarding.
- IMPORTED PRIVILEGES on the database — Enables access to shared databases after the account-level IMPORT SHARE permission is granted.
- USAGE on the database and all current and future schemas: Allows visibility into the database structure.
- SELECT on all current and future tables in the database: Required to read data values for classification.
- SNOWFLAKE.GOVERNANCE_VIEWER on the database — Required to inspect applied object tags, masking policies, and row access policies.
- SNOWFLAKE.OBJECT_VIEWER on the database — Grants account-wide visibility into object metadata for comprehensive asset discovery and inventory.
- SNOWFLAKE.SECURITY_VIEWER on the database — Enables analysis of user roles, privileges, and network configurations to identify security risks.
All permissions are granted automatically as part of the Snowflake integration process. No additional configuration is needed.
Scheduled Scans and Maintenance
Cloud Exposure uses a scheduled task in Snowflake to automatically integrate newly discovered databases. Disabling or removing the task will stop scans from running, preventing Tenable from updating Data Protection findings for the account.
If the account status is Missing Data Protection permissions:
- Re-run the integration script to reapply the required roles and permissions.
- Make sure network access is correctly configured to allow Tenable IP addresses. For more details, see Grant Tenable Network Access.
Database Scope and Discovery
No. In-account scanning is not currently supported for Snowflake. All scans are performed externally by Tenable from the relevant cloud region.
No. External tables are not supported for scanning.
Organization Support
Cloud Exposure does not currently support organization-level integration. Each Snowflake account must be integrated individually and granted the required permissions.
Authentication and Security
Cloud Exposure uses a unique, customer-specific 4096-bit private-public key pair to authenticate to your Snowflake environment. This secure, key-based authentication is established during the integration process and enables ongoing access for data classification and inventory scanning.
Licensing
Snowflake scanning is available with the Enterprise license only. If your organization uses a different license tier and you’d like to enable Snowflake support, contact your Tenable representative. For details, see the Licensing page.
Snowflake Feature Support
Cloud Exposure currently supports Inventory and Data Protection for Snowflake. CSPM, CIEM, and policy capabilities are not available for Snowflake at this time.
To request extended support, such as additional feature coverage or new capabilities, you can submit a feature request to our product team.
Network Access
If your Snowflake account enforces network restrictions, you must explicitly allow access from Tenable IP addresses to enable scanning.
See Grant Tenable Network Access for the required script and steps.
Account Status and Troubleshooting
Cloud Exposure displays a Status for each Snowflake account on the Accounts > Snowflake page, indicating, for example, whether Tenable can connect to the account, and helping you troubleshoot potential integration issues.
| Status | Description |
|---|---|
| Connected | Cloud Exposure successfully connected to the Snowflake account. |
| Deleting, this may take a while... | You deleted the account in Cloud Exposure, and the process is still in progress. |
| Access denied | The Tenable user cannot connect to Snowflake due to invalid credentials or missing permissions. |
| Connected with issues | The account is connected, but one or more features are not working due to missing permissions. See Snowflake: Grant Data Protection Permissions. |