Blog

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

Blog

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

Blog

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

Norapath Arjanurak

Analytics Engineer at Datascale

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 DDL to ER diagram

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

Improving SQL Data Analysis through Database Diagrams

This comprehensive guide explores the importance of data modeling in structuring and visualizing data for better analysis.

May 31, 2024

data-modeling

Norapath Arjanurak

Analytics Engineer at Datascale

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 DDL to ER diagram

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

Improving SQL Data Analysis through Database Diagrams

This comprehensive guide explores the importance of data modeling in structuring and visualizing data for better analysis.

May 31, 2024

data-modeling

Norapath Arjanurak

Analytics Engineer at Datascale

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 DDL to ER diagram

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

Improving SQL Data Analysis through Database Diagrams

This comprehensive guide explores the importance of data modeling in structuring and visualizing data for better analysis.

May 31, 2024

data-modeling