Snowflake Revefi Integration FAQ
Frequently asked questions about connecting Snowflake to Revefi and common setup issues.
Overview
Use this page to find quick answers to common Snowflake and Revefi integration questions during setup and operations. If you don’t see your question, contact [email protected].
Connection & Authentication
Which authentication methods are supported?
Revefi supports key-pair authentication (recommended).
While Revefi supports username/password authentication, it highly discourages the use of it. Snowflake is deprecating basic username/password in Nov 2025.
How do I find my Snowflake account identifier?
Identify the account identifier using the steps listed here.
Warehouses
What warehouse size should I use for onboarding to Revefi?
Start with MEDIUM during onboarding; afterwards reduce to XSMALL/SMALL based on workload.
Data Access
What permissions does Revefi need on Snowflake?
Revefi operates on a metadata access principle, meaning we only extract the metadata, query logs, and aggregated statistics from your Snowflake environment. By default, we never access raw records or personally identifiable information (PII).
What is the minimum level of access required?
The minimum setup requires metadata-only access, which typically involves:
USAGE on databases, schemas, and warehouses
MONITOR privileges to read query history and execution details
Access to Snowflake’s ACCOUNT_USAGE views (e.g., QUERY_HISTORY, TABLES, COLUMNS)
This is usually enough to enable Revefi to monitor data quality and query performance.
Does Revefi ever need data-level access?
Not by default. However, Revefi does incorporate data-level checks for issues like missing values, anomalies, or referential integrity. For these advanced capabilities, customers may optionally grant SELECT on specific tables.
Warehouse Management
What permissions are needed for Revefi to auto manage my warehouse?
Before Revefi can auto manage your Snowflake warehouse, you need to give Revefi the permissions. Follow the step 5 from the onboarding guide.
After you have given the appropriate permissions, you will need to set the Revefi DB in the connection. This should
match the db name you chose for revefi_db variable from the onboarding guide.
Security
Can I restrict Revefi by IP allowlist?
Yes. Add Revefi IPs listed in the Snowflake setup page to your Snowflake network policy if applicable.
Is key-pair authentication required?
Strongly recommended for Snowflake. Basic auth will be blocked by Snowflake starting Nov 2025.
Troubleshooting
I don’t see tables or views in a database
Confirm USAGE on the database and schemas and REFERENCES on tables/views, including FUTURE grants.
Contact
Still need help? Reach out via your Revefi Support ([email protected]).
Updated about 3 hours ago