We're Looking for 10 dbt Developers to Test Relationship-Aware JOINs — 12 Months Free

2026-11-18来源 dev.to DataEnglish
We're Looking for 10 dbt Developers to Test Relationship-Aware JOINs — 12 Months Free

IntaLink for dbt is live on the VS Code Marketplace. We're opening 10 founding-user spots with free access, updates, and direct engineering support.

We're looking for 10 developers working on real dbt projects to join the IntaLink for dbt Founding User Program.

Selected participants will receive:

  • 12 months of free access to the agreed IntaLink for dbt setup.
  • Free product updates throughout the access period.
  • Dedicated 1:1 engineering support for onboarding and technical questions.
  • Priority assistance with relationship discovery and JOIN challenges.
  • A direct opportunity to influence what we build next.

We're particularly interested in developers dealing with complex schemas, missing foreign keys, and JOIN conditions that take too much time to investigate.

What Does IntaLink for dbt Actually Do?

A dbt model can compile successfully and still produce incorrect results.

Consider a familiar situation: you need to join orders with order items, but order_id appears multiple times in the items table.

The SQL may be valid. The JOIN may even look reasonable. But if you aggregate at the wrong grain, the result can silently inflate your metrics.

Other problems are less obvious. Two tables may have a useful relationship without a declared foreign key. Or the relationship may pass through several models, with columns renamed along the way.

IntaLink for dbt is designed to bring relationship information into the development workflow rather than leaving every engineer to rediscover it.

1. Discover Relationships Before Writing JOINs

IntaLink Cloud examines authorized database metadata and column-value evidence to identify candidate relationships.

Developers can inspect those relationships in a graph, review supporting evidence, and decide which relationships should be used.

The VS Code extension then consumes the reviewed relationship set. It does not independently scan the database to discover relationships.

[Insert screenshot 1: IntaLink relationship graph]

Relationship graph showing candidate connections and review status.

2. Get Relationship-Aware JOIN Suggestions in VS Code

When writing SQL in a dbt model, the extension can suggest related tables or models after JOIN.

It can also suggest eligible field conditions after ON, using the available relationship information and SQL aliases.

Instead of searching through schemas or copying a JOIN from another model, developers can inspect relevant suggestions without leaving their editor.

[Insert screenshot 2: JOIN autocomplete in VS Code]

Relationship-aware suggestions while writing a dbt model.

3. Inspect the Evidence Behind a Relationship

A suggested relationship shouldn't be treated as correct simply because a tool found it.

IntaLink exposes information such as:

  • Column-value inclusion.
  • Distinct-value statistics.
  • Inferred relationship cardinality.
  • Relationship review status.

That evidence helps developers decide whether a candidate relationship is appropriate for their use case.

The extension also supports relationship lineage inheritance through eligible dbt transformations, including certain renames, casts, CTEs, and ref() chains.

These capabilities reduce investigation work, but they don't replace checking business meaning or the intended analytical grain.

[Insert screenshot 3: JOIN condition suggestion and relationship evidence]

Relationship evidence displayed alongside a suggested JOIN condition.

4. Catch Potential JOIN Fanout

One of the more expensive JOIN mistakes is row multiplication.

For example, joining an order-level model to an order-item-level model can duplicate order-level measures if the aggregation grain isn't handled correctly.

IntaLink for dbt can flag certain non-unique JOIN keys and suggest checking whether aggregation is needed before the JOIN.

It doesn't automatically guarantee the correctness of your query. It gives you an earlier warning about a risk worth investigating.

[Insert screenshot 4: JOIN fanout warning]

A potential fanout warning in the SQL development workflow.

A Practical Challenge for Our First 10 Users

We're not asking developers to test every feature or build a demonstration project just for us.

Bring one real JOIN problem you're unsure about.

It might involve:

  • Tables with no declared foreign keys.
  • Multiple possible JOIN paths.
  • Unclear relationship cardinality.
  • Unexpected row multiplication.
  • A dbt model whose relationships are difficult to trace.

Our engineering team will help you evaluate whether IntaLink for dbt can make that task easier.

We want to learn what works, what doesn't, and which parts of the workflow still require too much manual investigation.

How to Get Started

IntaLink for dbt is available as a VS Code extension.

To use its relationship-aware features, you'll need a supported dbt project, a generated target/manifest.json, and an IntaLink account with an available reviewed relationship set.

The typical workflow is:

  1. Connect an authorized data source in IntaLink Cloud.
  2. Discover and review candidate relationships.
  3. Make the reviewed relationship set available to the extension.
  4. Open your dbt project in VS Code and generate its manifest with dbt parse.
  5. Use relationship suggestions while writing JOINs.
  6. Review the evidence and investigate potential fanout warnings.

The Founding User Program includes onboarding assistance for selected participants.

Apply for the Founding 10 Program

We're selecting 10 developers with real dbt development needs, rather than simply rewarding the first 10 sign-ups.

If you're interested, tell us a little about your dbt project and one relationship or JOIN challenge you'd like to investigate.

Explore IntaLink for dbt and Contact Our Team

Install IntaLink for dbt from the VS Code Marketplace

Selected participants will receive 12 months of free access and updates, along with dedicated 1:1 engineering support under the program's agreed terms.

We're starting with 10 developers because we want to work closely with real projects and build around problems that actually matter.

10 founding users. 12 months free. Real dbt JOIN challenges.

Disclosure: I'm part of the team building IntaLink for dbt. This is an invitation to work directly with us, not an independent product review.

原文:https://www.a8q9.cn/en/article/we-re-looking-for-10-dbt-developers-to-test-relationship-aware-joins-12-months-f-de8ad6.html

相关文章