🧱 AltaSQL Views: Metadata-Rich, Fully Expressive Foundation
AltaSQL-generated VIEWs are real Snowflake VIEWs, but they’re automatically constructed using structured, serially reusable metadata, offering a rich layer of enhancements not available in raw SQL or Semantic Views alone:
✅ Key Enrichments AltaSQL Adds:
|
Feature |
Description |
|---|---|
|
Full SQL Expressiveness |
AltaSQL supports any SQL you can write in Snowflake, including expressions, CTEs, CASE, window functions, etc. |
|
Column-Level Comments |
Automatically embedded from imported metadata, carried forward when creating new View Definition |
|
Snowflake Tags |
Add business logic, ownership, classification, or other custom metadata. |
|
Dynamic Data Masking (DDM) |
Integrated into generated CREATE VIEW statements for sensitive data. |
|
Column Aliasing & Quoting |
Produces business-readable names like “Customer Name” instead of CUST_NAME. |
|
Multi-language View Support |
Automatically creates localized views (e.g., English, German, Dutch). |
|
Multiple Naming Conventions |
e.g., natural language, camelCase, snake_case, space-delimited—auto-generated from one source. |
|
Plug-and-Play Reuse |
View Definitions can be reused, extended, cloned, or transformed modularly. |
💡 Result: AltaSQL views form a rich semantic foundation with deep metadata and expressive SQL logic—ideal for governance, reuse, and data transformation.
🧠 Snowflake Semantic Views: Logical Business Layer
Semantic Views are not actual views—they are metadata-only logical models for defining dimensions, metrics, relationships, etc.
❗ Limitations:
💡 Result: Semantic Views depend on rich, expressive underlying VIEWs—this is exactly where AltaSQL excels.
🔄 Richness Continuum
|
Layer |
Purpose |
Enrichment Level |
Notes |
|---|---|---|---|
|
AltaSQL View |
Reusable, governed SQL logic |
🔥🔥🔥🔥🔥 |
Metadata-rich, documented, expressive SQL |
|
Snowflake Semantic View |
Logical business abstraction |
🔥🔥 |
Adds semantic relationships and metrics, not logic |
|
Raw Table/View |
Base data |
🔥 |
No abstraction, tagging, or automation |
🧩 The Ideal Stack
🚀 Bottom Line
AltaSQL VIEWs are richer, more expressive, and better governed than what Semantic Views can create or express. Snowflake’s Semantic Views need AltaSQL or equivalent engineered VIEWs underneath to function as a robust business layer.
