Skip to content
snowflake logo in light blue

Simplify data access control for Snowflake

No database view explosion or role bloat to contain. No more data extracts to manage. Okera provides dynamic row-level security and fine-grained access control for Snowflake.

Maximize the value of the Snowflake Data Cloud while protecting regulated, sensitive, and personal data with safe data access control for Snowflake

two keys outlined in yellow

Control

Dynamically apply user-appropriate row-level filters, data masking, and de-identification techniques at the point of query to comply with data privacy regulations and security mandates.

yellow circle

Centralization

All data access policies can be managed and enforced in one place, instead of synchronizing data access controls across disparate end-user BI tools and Snowflake.

Simplicity

Define user entitlements as human-readable data governance policies. Leverage user attribute data from external systems to build access policies and eliminate unmanageable view explosion and role bloat.

Visibility

All data access requests are automatically logged for every individual user, down to the exact query, timestamp, access method, data attributes including sensitivity level, and whether requests are approved or denied.

How it Works

Analysts and data scientists can continue to use Snowflake Worksheets, as well as their preferred third-party BI and data science tools. There is no need to change existing query definitions, dashboards, or reports. Just simply point to Okera’s native secure data gateway for Snowflake. Users get the full power of the Snowflake SQL syntax as normal.
Authorization occurs in a blink of an eye. Okera analyzes each query, evaluates data and user attributes, and dynamically applies row-level filtering and advanced data security and privacy functions such as tokenization and masking. Rewritten queries are then pushed down to Snowflake, which optimizes each query for security and performance.

Okera’s support for native Snowflake capabilities include:

Want to see more? Sign up for a demo.