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 --models 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

307 search results

stg_lever__contact_phone model

...Table capturing the phone numbers associated with a contact....

columns: contact_id, contact_id columns: index, index columns: phone_type, phone_type Show 2 more
...with base as ( select * from {{ ref('stg_lever__contact_phone_tmp') }} ), f...

stg_lever__offer model

...Table of the data sent to an opportunity for a position they have been offe...

columns: _fivetran_synced, _fivetran_synced columns: created_at, created_at columns: creator_user_id, creator_user_id Show 3 more
...with base as ( select * from {{ ref('stg_lever__offer_tmp') }} ), fields as...

stg_lever__requisition_offer model

...Table relating offers to their associated requisitions....

columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced columns: offer_id, offer_id Show 1 more
...{{ config(enabled=var('lever_using_requisitions', True)) }} with base as ( ...

stg_lever__opportunity_stage_history model

...Table capturing the different stages that each opportunity has passed throu...

columns: opportunity_id, opportunity_id columns: stage_id, stage_id columns: to_stage_index, to_stage_index Show 3 more
...with base as ( select * from {{ ref('stg_lever__opportunity_stage_history_t...

stg_lever__opportunity_stage_history_tmp model

columns: opportunity_id, opportunity_id columns: updated_at, updated_at columns: _fivetran_synced, _fivetran_synced Show 3 more
...select * from {{ var('opportunity_stage_history') }}...

int_lever__posting_tags model

...Table aggregating tags associated with each posting....

columns: posting_id, posting_id columns: tags, tags Show -1 more
...with posting_tag as ( select * from {{ var('posting_tag') }} ), agg_tags as...

int_lever__opportunity_contact_info model

...Table relating opportunities with their contact info (from `int_lever__cont...

columns: _fivetran_synced, _fivetran_synced columns: archived_at, archived_at columns: archived_reason_id, archived_reason_id Show 36 more
...with opportunity as ( -- this builds off the source opportunity table, inco...

stg_lever__opportunity_tag model

...Table relating opportunities to their tags....

columns: opportunity_id, opportunity_id columns: tag_name, tag_name columns: _fivetran_synced, _fivetran_synced Show 0 more
...with base as ( select * from {{ ref('stg_lever__opportunity_tag_tmp') }} ),...

stg_lever__user model

...Table of Lever users (anyone who has been invited to join the recruiting ef...

columns: _fivetran_synced, _fivetran_synced columns: access_role, access_role columns: created_at, created_at Show 5 more
...with base as ( select * from {{ ref('stg_lever__user_tmp') }} ), fields as ...

stg_lever__posting_tag_tmp model

columns: posting_id, posting_id columns: tag, tag columns: _fivetran_deleted, _fivetran_deleted Show 1 more
...select * from {{ var('posting_tag') }}...

stg_lever__interviewer_user_tmp model

columns: interview_id, interview_id columns: user_id, user_id columns: _fivetran_synced, _fivetran_synced Show 0 more
...select * from {{ var('interviewer_user') }}...

stg_lever__archive_reason model

...Table of reasons for archiving candidates, exiting them from the hiring pip...

columns: archive_reason_id, archive_reason_id columns: archive_reason_title, archive_reason_title columns: _fivetran_synced, _fivetran_synced Show 0 more
...with base as ( select * from {{ ref('stg_lever__archive_reason_tmp') }} ), ...

int_lever__requisition_users model

...Table relating requisitions to its stakeholders....

columns: _fivetran_synced, _fivetran_synced columns: is_backfill, is_backfill columns: compensation_band_currency, compensation_band_currency Show 21 more
...{{ config(enabled=var('lever_using_requisitions', True)) }} with lever_user...

stg_lever__posting model

...Table capturing job postings that candidates can apply to....

columns: _fivetran_synced, _fivetran_synced columns: job_commitment, job_commitment columns: job_department, job_department Show 12 more
...with base as ( select * from {{ ref('stg_lever__posting_tmp') }} ), fields ...

stg_lever__feedback_form_field_tmp model

columns: feedback_form_id, feedback_form_id columns: field_index, field_index columns: value_index, value_index Show 8 more
...select * from {{ var('feedback_form_field') }}...

stg_lever__feedback_form model

...Table capturing feedback forms that have been completed after interviewing ...

columns: _fivetran_synced, _fivetran_synced columns: completed_at, completed_at columns: created_at, created_at Show 10 more
...with base as ( select * from {{ ref('stg_lever__feedback_form_tmp') }} ), f...

stg_lever__posting_tag model

...Table associating job postings with all associated tags....

columns: posting_id, posting_id columns: tag_name, tag_name columns: _fivetran_synced, _fivetran_synced Show 0 more
...with base as ( select * from {{ ref('stg_lever__posting_tag_tmp') }} ), fie...

stg_lever__posting_interview_tmp model

columns: interview_id, interview_id columns: posting_id, posting_id columns: _fivetran_synced, _fivetran_synced Show 0 more
...select * from {{ var('posting_interview') }}...

stg_lever__archive_reason_tmp model

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 1 more
...select * from {{ var('archive_reason') }}...

stg_lever__application_tmp model

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: archived_at, archived_at Show 12 more
...select * from {{ var('application') }}...
Show 287 more