Data modeling best practices: a curated list. We'll focus on modular modeling, and explore the essential model layers.

How-to create data lineage from sql queries

A simple data modeling visualization from your DDLs

The evolution of data engineering and new patterns for common analytics management

The importance of having a clear and organized representation of your database structure.

Organizing your SQL queries and getting started with Datascale's SQL notes

Why data dictionary is important to your business and data teams

Here are some key steps to effectively document data.

Open source SQL tools and utils

Rethinking saved queries: SQL notes as knowledge building blocks

Selected quotes from thought leaders on why CTE is better than subquery:

A way to draw your SQL queries as ER diagrams: a powerful tool for complex query visualization.

Using DAG to represent a sequence of data transformation tasks from SQL CTEs.

Auto save new changes and compare version history diff

How our design reflects evolving SaaS trends. Some common design patterns for SaaS apps:

Visualize any time series data in a minute using this GPT prompt.

Automatically validate and fix SQL for you. Never worry about anti-pattern code again.