| Virtual Transformation engine automates generation of reliable and consistent SQL statements from meta-data |
Reduces manual coding by more than 90%. Fully qualified and quoted object and column names. Transformations include: column names, SQL expressions, UDF calls, and literals. Reliable, consistent VIEW columns list with COMMENTs, Snowflake Tags and Dynamic data masking. |
Dramatically increases productivity and quality eliminating 90%+ of hand coding. |
| “Virtual Views” |
Generate editable SELECT statements with fully qualified column names directly from meta-data View Definitions. |
End SELECT * issues. Facilitates testing. Reduces database object clutter. |
| Name Transformation |
Easily create new VIEW Definitions with new column names. |
Fully qualified, meaningful column names for both Virtual Views and created VIEWs. Create different column names to provide context for different use cases, including natural native language and multiple language translations. |
| Generated SQL statements are not executed by AltaSQL |
“Look before you execute.” |
No surprises. Modify and enhance when needed. Use appropriate warehouses and Roles. Development process agnostic. Incorporate into procedural code, CI/CD pipelines, dataops, etc. |
| Pure SQL, delivered as easy-to-use Snowflake Secure UDFs |
No YAML, macros, GUI. Open architecture. Nothing to install. |
Simple to use. Enables true bulk editing, bulk generation, and bulk deployment improving time-to-delivery. |
| Unlimited usage |
Fixed, monthly subscription. |
Predictable spend and budgeting. |
| Starts with your existing meta-data |
Every TABLE and VIEW has usable meta-data. |
Rapidly and reliably augment and enhance existing analytic infrastructure. |
| User defined meta-data catalog, AltaSQL Tags |
Create “Query Containers” with unlimited user defined meta-data types beyond generative meta-data including: documentation, code, instructions, and more. |
Provides an entirely new level of functionality for developers and end users. Reduces script clutter. |
| Downloadable file with “Ready to Execute” function calls |
User Defined Function calls with all columns preset to either “<required>” for required arguments or NULL for optional arguments. Simply fill in argument values; call by name allows reordering and omitting optional arguments. |
AltaSQL’s “Ready-to-Execute” functions simplify and enable rapid development and testing of generated SQL statements with all AltaSQL and Snowflake options in a single function. |
| “Plug and Play” SQL generation decomposes SQL generation into component parts |
Modular construction of SQL statements. |
Extraordinary flexibility, control and reuse of individual components of SQL statements, e.g., VIEW column list, SELECT, FROM clause, Post FROM clauses. |
| Fully automated CREATE VIEW DDL |
Eliminates hand coding of CREATE VIEW DDL |
Automatic pre-SELECT column list with comments, column tags and data masking, CREATE VIEW options, object tags and RBAC |
| Common Table Expressions (CTEs) |
Create CTEs for generation from View Definitions |
Define complex business logic and semantics |
