fix: fix joined table with aliases in metric

[rephus]

Closes: #9726

Solution

Generate a mapping with all the joins tables and aliases so we can evaluate the alias in the dimension reference method

Description:

This PR is only fixing the specified issue with nested joins , alias and sql metric. There are other scenarios that are not covered on this PR , like dimensions, user attributes, etc. THe approach should be similar to this fix though.

Before

After:

Reviewer actions

• I have manually tested the changes in the preview environment
• I have reviewed the code
• I understand that "request changes" will block this PR from merging

[netlify]

✅ Deploy Preview for peaceful-bassi-cbf284 canceled.

Name	Link
🔨 Latest commit	3945669
🔍 Latest deploy log	https://app.netlify.com/sites/peaceful-bassi-cbf284/deploys/66275e3c6791a2000855f866

[almeidabbm]

When trying to compile the same join alias you have on the screenshots using the CLI:

diff --git a/examples/full-jaffle-shop-demo/dbt/models/schema.yml b/examples/full-jaffle-shop-demo/dbt/models/schema.yml
index 624508de6..6118fd529 100755
--- a/examples/full-jaffle-shop-demo/dbt/models/schema.yml
+++ b/examples/full-jaffle-shop-demo/dbt/models/schema.yml
@@ -93,6 +93,7 @@ models:
     meta:
       joins:
         - join: customers
+          alias: foo
           sql_on: ${customers.customer_id} = ${orders.customer_id}
     columns:
       - name: order_id
@@ -102,6 +103,9 @@ models:
         description: This is a unique identifier for an order
         meta:
           metrics:
+            first_name_count:
+              type: count_distinct
+              field: ${foo.first_name} IS NOT NULL
             unique_order_count:
               type: count_distinct
             completed_or_shipped_order_count:

I am getting this error:

[rephus]

When trying to compile the same join alias you have on the screenshots using the CLI:

Fixed, there might be more like this like I mentioned in the description

This PR is only fixing the specified issue with nested joins , alias and sql metric. There are other scenarios that are not covered on this PR , like dimensions, user attributes, etc. THe approach should be similar to this fix though.

[almeidabbm]

SUPER!! LGTM 🚀

[lightdash-bot]

🎉 This PR is included in version 0.1075.1 🎉

The release is available on:

• 0.1075.1
• GitHub release

Your semantic-release bot 📦🚀