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

322 search results

rag_hubspot__document model

Each record represents a HubSpot Deal, enriched with data about it's relevant engagement notes, company, contact, and owner information.

columns: document_id, document_id columns: title, title columns: url_reference, url_reference Show 6 more
{{ config(enabled=var('rag__using_hubspot', True)) }} with deal_document as ( select * from {{ ref('int_rag_hubspot__deal_document') }} ), grouped as ( select * from {{ ref('int_rag_hubspot__deal_comment_documents_grouped') }} ), final as ( select cast(deal_document.deal_id as {{ dbt.type_string() }}) as document_id, coalesce(deal_document.title, grouped.title) as title, deal_document.url_reference, 'hubspot' as platform, deal_document.source_relation, coalesce(grouped.most_recent_chunk_update, deal_document.created_on) as most_recent_chunk_update, coalesce(grouped.chunk_index, 0) as chunk_index, coalesce(grouped.chunk_tokens, 0) as chunk_tokens_approximate, {{ dbt.concat([ "deal_document.comment_markdown", "'\\n\\n## COMMENTS\\n\\n'", "coalesce(grouped.comments_group_markdown, '')"]) }} as chunk from deal_document left join grouped on grouped.deal_id = deal_document.deal_id and grouped.source_relation = deal_document.source_relation ) select * from final

rag__unified_document model

Each record represents a chunk of text prepared for semantic-search and additional fields for use in LLM workflows.

columns: unique_id, unique_id columns: document_id, document_id columns: title, title Show 8 more
{{ config( materialized='table' if unified_rag.is_databricks_sql_warehouse() else 'incremental', partition_by = {'field': 'update_date', 'data_type': 'date'} if target.type not in ['spark', 'databricks'] else ['update_date'], cluster_by = ['update_date'], unique_key='unique_id', incremental_strategy = 'insert_overwrite' if target.type in ('bigquery', 'databricks', 'spark') else 'delete+insert', file_format='delta' ) }} {%- set enabled_variables = ['rag__using_jira', 'rag__using_zendesk', 'rag__using_hubspot'] -%} {%- set queries = [] -%} {% for platform in enabled_variables %} {% if var(platform, true) == true -%} {%- set platform_name = platform | replace('rag__using_', '') -%} {%- set unique_key_fields = ['document_id', 'platform', 'chunk_index', 'source_relation'] -%} {% set select_statement = ( "select \n" ~ " " ~ dbt_utils.generate_surrogate_key(unique_key_fields) ~ " as unique_id, \n" ~ " document_id, \n" ~ " title, \n" ~ " url_reference, \n" ~ " platform, \n" ~ " source_relation, \n" ~ " most_recent_chunk_update, \n" ~ " cast(most_recent_chunk_update as date) as update_date, \n" ~ " chunk_index, \n" ~ " chunk_tokens_approximate, \n" ~ " chunk \n" ~ "from " ~ ref('rag_' ~ platform_name ~ '__document')) %} {% if is_incremental() %} {% set select_statement = select_statement ~ "\n where cast(most_recent_chunk_update as date) >= (select max(update_date) from " ~ this ~ ")" %} {% endif %} {% do queries.append(select_statement) -%} {% endif -%} {% endfor %} {%- if queries | length > 1 -%} {{ queries | join(' union all ') }} {%- else -%} {{ queries[0] }} {%- endif %}

zendesk_user seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: active, active Show 29 more

zendesk_ticket_comment seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: body, body Show 7 more

zendesk_ticket seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: allow_channelback, allow_channelback Show 33 more

jira_user seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: email, email Show 4 more

jira_status seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: description, description Show 2 more

jira_priority seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: description, description Show 1 more

jira_issue seed

columns: id, id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 26 more

jira_comment seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: author_id, author_id Show 6 more

hubspot_owner seed

columns: owner_id, owner_id columns: _fivetran_synced, _fivetran_synced columns: created_at, created_at Show 6 more

hubspot_engagement_note seed

columns: engagement_id, engagement_id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 9 more

hubspot_engagement_email seed

columns: engagement_id, engagement_id columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced Show 17 more

hubspot_engagement_deal seed

columns: deal_id, deal_id columns: engagement_id, engagement_id columns: engagement_type, engagement_type Show 3 more

hubspot_engagement_contact seed

columns: contact_id, contact_id columns: engagement_id, engagement_id columns: engagement_type, engagement_type Show 3 more

hubspot_engagement_company seed

columns: company_id, company_id columns: engagement_id, engagement_id columns: engagement_type, engagement_type Show 3 more

hubspot_engagement seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: active, active Show 7 more

hubspot_deal seed

columns: deal_id, deal_id columns: is_deleted, is_deleted columns: deal_pipeline_id, deal_pipeline_id Show 10 more

hubspot_contact seed

columns: _fivetran_deleted, _fivetran_deleted columns: _fivetran_synced, _fivetran_synced columns: property_email, property_email Show 9 more

hubspot_company seed

columns: id, id columns: is_deleted, is_deleted columns: _fivetran_synced, _fivetran_synced Show 10 more
Show 302 more