Blog

Learn about Datascale's engineering, product developments, data management and more.

Featured

Efficient Ways to Organize Data Models

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

Jul 7, 2024

data-modeling

Efficient Ways to Organize Data Models

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

Jul 7, 2024

data-modeling

Efficient Ways to Organize Data Models

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

Jul 7, 2024

data-modeling

How can Datascale help Visualize Data Models? (3NF vs Dimensional)

A simple data modeling visualization from your DDLs

Jun 2, 2024

data-modeling

How can Datascale help Visualize Data Models? (3NF vs Dimensional)

A simple data modeling visualization from your DDLs

Jun 2, 2024

data-modeling

How can Datascale help Visualize Data Models? (3NF vs Dimensional)

A simple data modeling visualization from your DDLs

Jun 2, 2024

data-modeling

Our Design Patterns for Organizing Database Diagrams

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

Jun 6, 2024

data-modeling

Our Design Patterns for Organizing Database Diagrams

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

Jun 6, 2024

data-modeling

Our Design Patterns for Organizing Database Diagrams

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

Jun 6, 2024

data-modeling

Data Modeling

A Guide to Transformational Modeling with A BigQuery Dataset

Part 3: How to effectively transform raw data with dbt using the ER diagram of a BigQuery information schema.

Jul 10, 2024

data-modeling

A Guide to Transformational Modeling with A BigQuery Dataset

Part 3: How to effectively transform raw data with dbt using the ER diagram of a BigQuery information schema.

Jul 10, 2024

data-modeling

A Guide to Transformational Modeling with A BigQuery Dataset

Part 3: How to effectively transform raw data with dbt using the ER diagram of a BigQuery information schema.

Jul 10, 2024

data-modeling

BigQuery Information Schema: DDL to ER Diagram

Part 2: how to visualize DDL with PK & FK references from BigQuery's information schema into an ER diagram

Jun 28, 2024

data-modeling

BigQuery Information Schema: DDL to ER Diagram

Part 2: how to visualize DDL with PK & FK references from BigQuery's information schema into an ER diagram

Jun 28, 2024

data-modeling

BigQuery Information Schema: DDL to ER Diagram

Part 2: how to visualize DDL with PK & FK references from BigQuery's information schema into an ER diagram

Jun 28, 2024

data-modeling

BigQuery Information Schema: Primary Key and Foreign Key

Part 1: how to query DDL, metadata, and constraints from BigQuery's information schema to create an ER diagram.

Jun 19, 2024

data-modeling

BigQuery Information Schema: Primary Key and Foreign Key

Part 1: how to query DDL, metadata, and constraints from BigQuery's information schema to create an ER diagram.

Jun 19, 2024

data-modeling

BigQuery Information Schema: Primary Key and Foreign Key

Part 1: how to query DDL, metadata, and constraints from BigQuery's information schema to create an ER diagram.

Jun 19, 2024

data-modeling

Metadata Management

From Enriched Dimensions to Common Analytical Patterns

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

Jun 6, 2024

data-management

From Enriched Dimensions to Common Analytical Patterns

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

Jun 6, 2024

data-management

From Enriched Dimensions to Common Analytical Patterns

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

Jun 6, 2024

data-management

Tips on How to Organize Your SQL Queries

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

May 2, 2024

data-management

Tips on How to Organize Your SQL Queries

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

May 2, 2024

data-management

Tips on How to Organize Your SQL Queries

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

May 2, 2024

data-management

What's a Data Dictionary and Why is it Crucial?

Why data dictionary is important to your business and data teams

Apr 25, 2024

data-management

What's a Data Dictionary and Why is it Crucial?

Why data dictionary is important to your business and data teams

Apr 25, 2024

data-management

What's a Data Dictionary and Why is it Crucial?

Why data dictionary is important to your business and data teams

Apr 25, 2024

data-management

Productivity & AI

Directory of SQL tools and Utils

Open source SQL tools and utils

Mar 15, 2024

Directory of SQL tools and Utils

Open source SQL tools and utils

Mar 15, 2024

Directory of SQL tools and Utils

Open source SQL tools and utils

Mar 15, 2024

PARA method for SQL notes

Rethinking saved queries: SQL notes as knowledge building blocks

Mar 14, 2024

productivity

PARA method for SQL notes

Rethinking saved queries: SQL notes as knowledge building blocks

Mar 14, 2024

productivity

PARA method for SQL notes

Rethinking saved queries: SQL notes as knowledge building blocks

Mar 14, 2024

productivity

Automate time series plot with ChatGPT

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

Nov 28, 2023

Automate time series plot with ChatGPT

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

Nov 28, 2023

Automate time series plot with ChatGPT

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

Nov 28, 2023

SQL Patterns

CTEs > Subqueries

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

Jan 26, 2024

sql-patterns

CTEs > Subqueries

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

Jan 26, 2024

sql-patterns

CTEs > Subqueries

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

Jan 26, 2024

sql-patterns

Visualize SQL to ER diagram

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

Jan 25, 2024

sql-patterns

Visualize SQL to ER diagram

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

Jan 25, 2024

sql-patterns

Visualize SQL to ER diagram

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

Jan 25, 2024

sql-patterns

Understanding DAG in SQL

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

Jan 20, 2024

sql-patterns

Understanding DAG in SQL

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

Jan 20, 2024

sql-patterns

Understanding DAG in SQL

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

Jan 20, 2024

sql-patterns

Changelog

Introducing Version History

Auto save new changes and compare version history diff

Dec 6, 2023

changelog

Introducing Version History

Auto save new changes and compare version history diff

Dec 6, 2023

changelog

Introducing Version History

Auto save new changes and compare version history diff

Dec 6, 2023

changelog

Design Updates: Multi-views & Double-layered Sidebar

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

Nov 29, 2023

changelog

Design Updates: Multi-views & Double-layered Sidebar

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

Nov 29, 2023

changelog

Design Updates: Multi-views & Double-layered Sidebar

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

Nov 29, 2023

changelog

Introducing SQL Linter with SQLFluff

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

Oct 16, 2023

changelog

Introducing SQL Linter with SQLFluff

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

Oct 16, 2023

changelog

Introducing SQL Linter with SQLFluff

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

Oct 16, 2023

changelog