Reported impact
Business outcome
Orchid Security accelerated analysis by 80%, examined more than 1 million user identities, and gave customers a near-real-time view of identity risk across thousands of applications.
- Productivity Improvement
- Risk Reduction
- Scalability
Solution
Orchid Security uses Snowflake, dbt, Dynamic Tables, Snowpark, and Metabase to analyze identity risk across huge enterprise application estates. Customer application data, authorized accounts, authentication flows, groups, and permissions are ingested into Snowflake at high frequency, where dbt models, Dynamic Tables, and Snowpark-based analysis keep pipelines refreshed and let the team compute complex identity graphs without moving data to separate environments. The platform feeds dashboards and Metabase-style self-service views that expose security coverage, unsecured applications, and the riskiest identities, while natural-language exploration helps both customers and internal users investigate findings quickly. By keeping computation close to hundreds of millions of accounts and thousands of applications, Orchid shortened analysis cycles from hours to minutes and gave customers a near-real-time picture of identity risk.
Data flow
Application, identity, and access data is ingested into Snowflake, modeled with dbt, and kept current with Dynamic Tables. Snowpark performs deeper graph-style analysis in place, and the resulting risk views are delivered through dashboards and Metabase to both Orchid teams and customers.