Introducing Tx: Data transformations and automation together with relational modeling
Plan: Tx is a standalone product license that includes all the features of existing SqlDBM plans and data automation and transformation features
Databases:
Snowflake
other CDPs will be included in the future
What is Tx
Tx projects fuse relational modeling with transformational logic to provide a multidimensional view of data relationships and dependencies—providing a complete overview of your Snowflake data landscape. Plan, validate, transform, and deploy using an all-in-one integrated online platform that supports your teams across every stage of data modeling and analytics.
Guided overview:
What Tx offers
Observe and model the relational data landscape and use it to guide and enforce transformational logic and data flows. Tx projects keep relational and transformational views of your data in perfect sync, allowing you to plan new designs and avoid duplicate or siloed data.
“Tx brings in continuity across your relational and transformational models”
- Keith Belanger
Cloud-Native SaaS Solution:
Optimizes data automation across all analytical data strategies (Dimensional, Data Vault, Medallion…)Model-Driven Approach:
Integrates relational and transformational data modeling.Flexible Manual Coding:
Offers adaptability for customized needs.Intuitive Graphical Interface:
Includes customizable templates for ease of use.Unified Platform:
Supports consistent, repeatable, high-quality workflows.Accessible to All Users:
Suitable for both technical experts and non-specialists.Optimized for Snowflake:
Ensures robust data processing and transformation capabilities.
Accelerated time-to-market
Design, validate, build, test, deploy, and get it right the first time.
Best practices built-in and enforced
Reusable and configurable templates provide consistent, modular code
Supports all modeling methodologies
Tx templates can be fine-tuned to support any methodology from Kimball to Data Vault
How Tx drives data quality
SqlDBM combines the best of code-first and GUI-based solutions for a powerful development experience. Our Tx templates allow users to wrap complex SQL logic in reusable boiler-plate standards to accelerate and automate the creation of repeatable objects such as dimensions, views, Data Vault objects, or anything else you create.
Using Tx templates in conjunction with macros, tests, and SQL Snippets allows users to create modular, consistent, DRY (don't repeat yourself) code, helping make development consistent and maintainable.
How Tx integrates with existing SqlDBM features
Tx projects add data transformation and automation to SqlDBM’s robust set of features, such as collaboration, data discovery, and data governance. Finally, an all-in-one data solution that empowers teams from design to deployment and supports them afterward with intuitive documentation and governance functionality. From business users to data engineers, SqlDBM Tx projects offer an all-in-one solution to everyday modeling needs.
How to try Tx
Interested? Reach out to us to learn more about Tx and try it for yourself.