Snowflake

Governed Enterprise Intelligence on Snowflake

Orisdale designs governed business logic and semantic intelligence for Snowflake-based Enterprise Intelligence Systems.

Snowflake

How Orisdale extends Snowflake

Snowflake provides the governed data and semantic foundation. Orisdale adds governed business logic, semantic preparation, and controlled AI experience design on top, so Cortex Agents and Cortex AI capabilities interpret trusted, well-defined business context rather than raw tables.

Orisdale is a registered partner-program participant with Snowflake.

  • Governed tables and views
  • Semantic models and Cortex Analyst
  • Cortex Agents and Cortex AI capabilities
  • Cortex Search and AI Functions
  • In-platform data governance

Reference architecture

Snowflake reference pattern

Reference pattern. Not a demonstrated deployment and not a Snowflake endorsement. Semantic views do not by themselves prevent a query from reading base tables.

Reference pattern

Snowflake reference patternReference pattern. Not a demonstrated deployment and not a Snowflake endorsement. Semantic views do not by themselves prevent a query from reading base tables. Connected stages: Enterprise sources, Ingested Snowflake data, Governed query, Interpretation, Human review. Drawn boundaries: Snowflake platform boundary.Snowflake platform boundarySource systemsOwned outside SnowflakeIngested tablesSelected source dataSemantic viewsNative Snowflake objectsApproved definitionsApproved rule versionsQuery executionSQL inside SnowflakeCortex AnalystGenerates the queryBusiness experienceBusiness experienceHuman reviewerPending review

Snowflake platform boundary

Ingested tables

Selected source data

Data · Authorized fields → Approved definitions

Semantic views

Native Snowflake objects

Data · Semantic context → Cortex Analyst

Approved definitions

Approved rule versions

Query · Approved definition → Query execution

Query execution

SQL inside Snowflake

Data · Query result → Business experience

Source systems

Owned outside Snowflake

Data · Selected records → Ingested tables

Cortex Analyst

Generates the query

Query · Generated SQL → Query execution

Business experience

Business experience

Feedback · Finding for review → Human reviewer

Human reviewer

Pending review

  • Data flow
  • Query and control
  • Human feedback

Download SVG

Cortex Analyst generates SQL. A semantic view does not by itself stop a query from reading base tables. Snowflake documents a standard-SQL routing fallback. Snowflake Cortex Analyst routing.

  • Native to Snowflake
  • Orisdale contribution

Discuss a Snowflake deployment pattern