https://www.growthbook.io/ logo
Join Slack
Powered by
Hello everyone! We have set up GrowthBook with Mat...
# ask-questions
i
Hello everyone! We have set up GrowthBook with Matomo as our data source and are now trying to run an A/A-test to confirm our setup. However, the DB queries for the metrics associated with the test are failing since there's a reference to a Matomo table that doesn't exist. The metric queries themselves work fine, it's just the test queries that are failing. I can't find any way to adjust the query to reference the correct table name. Does anyone know how this can be done?
s
Hi, try to edit the query there 😉
i
@stale-branch-42032 Thanks for the suggestion but it's unfortunately not these ones that are failing, but the ones I can view when clicking here:
And maybe they're accessible from somewhere else but I can't seem to find where 😄
🫤 1
s
Sorry, that it doesn't help. In our case, it was there. In All Metrics / fact Tables and data sources, we needed to update our references
i
Thanks for trying! I've had to update these and the fact tables as well, it's just the test queries that I can't find a way to modify...
f
GrowthBook doesnt join to a table thats not one set by you or adjustable by you
Thomas is correct, take a look at the assignment queries
if you view the queries that have the error, you can share the block that has that table name, and i can tell you where to edit it
i
Thank you @fresh-football-47124, that is good to know - it's the beginning of the test query:
Copy code
-- Our metric 
WITH
  __identities_user_id as (
    SELECT
      anonymous_id,
      user_id
    FROM
      (
        SELECT
          user_id,
          conv(hex(idvisitor), 16, 16) as anonymous_id
        FROM
          matomo__log_visit
      ) i
    GROUP BY
      anonymous_id,
      user_id
  ),
...
and it's this table that doesn't exist - I just need to remove one underscore. This section is not a part of the assignment query, would be super grateful if you could point me in the right direction!
I realized that I can probably solve this by re-adding Matomo as a data source and removing the existing connection
f
So that Identities is editable from the data source page
metrics & data -> Data sources -> (your data source)
at the top, you'll see the identifiers, and then under that is the identities joins
you can edit this SQL
(fyi, this table is used because a metric is returning one identifier (like user_id) and the experiment is returning a different identifier (like anon_id) - this join tells the query how to map between the two. You may find that the metric can return this identifier directly, but just has to be edited to return it)
i
Ok, thank you for explaining! Didn't realize there was a query to be edited there. Good to know!
15 Views
Open in Slack
PreviousNext
Powered by