icons
Lineage Graph

Welcome!

Welcome to the auto-generated documentation for your dbt project!

You can use the Project and Database navigation tabs on the left side of the window to explore the models in your project.

Project Tab

The Project tab mirrors the directory structure of your dbt project. In this tab, you can see all of the models defined in your dbt project, as well as models imported from dbt packages.

Database Tab

The Database tab also exposes your models, but in a format that looks more like a database explorer. This view shows relations (tables and views) grouped into database schemas. Note that ephemeral models are not shown in this interface, as they do not exist in the database.

Graph Exploration

You can click the blue icon on the bottom-right corner of the page to view the lineage graph of your models.

On model pages, you'll see the immediate parents and children of the model you're exploring. By clicking the Expand button at the top-right of this lineage pane, you'll be able to see all of the models that are used to build, or are built from, the model you're exploring.

Once expanded, you'll be able to use the --select and --exclude model selection syntax to filter the models in the graph. For more information on model selection, check out the dbt docs.

Note that you can also right-click on models to interactively filter and explore the graph.

More information

8 search results

trajectory_with_type model

Show -3 more
select * from {{ ref('trajectory') }} t inner join {{ ref('type_distribution') }} td on t.id = td.id where t.id = 1

type_distribution model

This dbt model calculates a distribution of automobile types from the "traffic" table.

columns: type, type columns: vehicle_count, vehicle_count columns: Automobile_type, Automobile_type Show 0 more
{{ config(materialized='view') }} with type_distribution as ( select type, count(*) as vehicle_count from traffic group by 1 ) select * from type_distribution

trajectory model

This dbt model extracts trajectory data from the "automobiles" table.

columns: id, id columns: track_id, track_id columns: lat, lat Show 2 more
{{ config(materialized='table') }} with trajectory_data as ( select id, track_id, lat, lon, time from automobiles ) select * from trajectory_data

spatial model

This dbt model calculates heatmap data from the "automobiles" and "traffic" tables.

columns: type, type columns: lat, lat columns: lon, lon Show 2 more
{{ config(materialized='table') }} with heatmap_data as ( select type, lat, lon, count(*) as point_count from automobiles join traffic using (track_id) group by 1, 2, 3 ) select * from heatmap_data

distance_traveled model

This dbt model calculates a summary of distance data from the "traffic" table.

columns: type, type columns: total_distance, total_distance columns: Automobile_type, Automobile_type Show 0 more
{{ config(materialized='view') }} with distance_summary as ( select type, sum(traveled_d::numeric) AS total_distance from traffic group by 1 ) select * from distance_summary

average model

This dbt model calculates a summary of timely data from the "automobiles" table.

columns: time, time columns: speed, speed columns: lat_acc, lat_acc Show 1 more
{{ config(materialized='view') }} with timely_summary as ( SELECT time, Round(AVG(Cast(speed as numeric)),2) as "speed", Round(AVG(Cast(lat_acc as numeric)),2) as "lat_acc", Round(AVG(Cast(lon_acc as numeric)),2) as "lon_acc" from automobiles GROUP BY "time" ) SELECT * FROM timely_summary

automobiles_info model

This dbt model calculates a summary of automobile data from the "traffic" table.

columns: Automobile type, Automobile type columns: Automobile count, Automobile count columns: Avg distance traveled, Avg distance traveled Show 5 more
{{ config(materialized='table') }} with summary as ( SELECT type as "Automobile type", count(type) as "Automobile count", Round(AVG(Cast(traveled_d as numeric)),2) as "Avg distance traveled", Round(AVG(cast(avg_speed as numeric)),2) as "Avg speed by automobile" from traffic GROUP BY type ORDER BY "Automobile count" ASC ) SELECT * from summary

acceleration model

This dbt model extracts acceleration data from the "automobiles" table.

columns: id, id columns: track_id, track_id columns: lat_acc, lat_acc Show 2 more
{{ config(materialized='table') }} with acceleration_data as ( select id, track_id, lat_acc, lon_acc, time from automobiles ) select * from acceleration_data
Show -12 more