统一RAG工具

Install the package

Include the following package_display_name package version in your packages.yml file: > TIP: Check dbt Hub for the latest installation instructions or read the dbt docs for more information on installing packages.

packages:
  - package: fivetran/unified_rag
    version: [">=0.2.0", "<0.3.0"]

(Optional) Additional configurations

#### Customizing Chunk Size for Vectorization The rag__unified_document and upstream platform specific *__document models were developed to limit approximate chunk sizes to 5,000 tokens, optimized for OpenAI models. However, you can adjust this limit by setting the max_tokens variable in your dbt_project.yml:

vars:
    document_max_tokens: 5000 # Default value

#### Changing the Build Schema By default this package will build the Unified RAG staging models within a schema titled (<target_schema> + _unified_rag_source) and the Unified RAG final models within a schema titled (<target_schema> + _unified_rag) in your target database. If this is not where you want your modeled Unified RAG data to be written to, add the following configuration to your dbt_project.yml file:

models:
    unified_rag:
        +schema: my_new_schema_name # leave blank for just the target_schema
        staging:
            +schema: my_new_schema_name # leave blank for just the target_schema

#### Change the source table references If an individual source table has a different name than the package expects, add the table name as it appears in your destination to the respective variable:

IMPORTANT: See this project's dbt_project.yml variable declarations to see the expected names.

```yml

(Optional) Orchestrate your models with Fivetran Transformations for dbt Core™

<details><summary>Expand for details</summary> <br>

Fivetran offers the ability for you to orchestrate your dbt project through Fivetran Transformations for dbt Core™. Learn how to set up your project for orchestration through Fivetran in our Transformations for dbt Core setup guides. </details>

Unified RAG dbt Package

This dbt package transforms data from Fivetran's Unified RAG connector into analytics-ready tables.

What does this dbt package do?

This package enables you to generate unstructured document data for Retrieval Augmented Generation (RAG) applications and combine data from HubSpot deals, Jira issues, and Zendesk tickets. It creates enriched models with metrics focused on text chunks prepared for semantic search and LLM workflows.

Note: Redshift destinations are not currently supported due to the stringent character limitations within string datatypes. If you would like Redshift destinations to be supported, please comment within our logged Feature Request.

How do I use the dbt package?

You can either add this dbt package in the Fivetran dashboard or import it into your dbt project:

• To add the package in the Fivetran dashboard, follow our Quickstart guide.
• To add the package to your dbt project, follow the setup instructions in the dbt package's README file to use this package.

How is this package maintained and can I contribute?

Package Maintenance

The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.