Comments (8)
I need more details to reproduce this:
- dbt version(s)
- Metabase version(s)
- Database type(s), e.g. PostgreSQL, Snowflake, BigQuery
- Exposures type(s), e.g. dashboard, question from a table, question from another question, native SQL query
Can you also try other versions between 1.0.1 and 1.3.1 to narrow down when the bug was introduced?
from dbt-metabase.
python = "3.10"
dbt-snowflake = "1.7.1"
dbt-metabase = "1.3.1"
dbt-core = "1.7.6"
- Metabase 1.49.14
- Snowflake
- A full exposure dump, so all of them? We have everything in our Metabase, the exposure file ends up ~15k lines.
Other versions:
- Dependencies work in dbt-metabase 1.0.3 for me. After that, the dependencies stop populating in 1.1.0
from dbt-metabase.
Dependencies work up to dbt-metabase 1.1.0 for me. After that, the dependencies stop populating.
Are you saying 1.1.0 is the last version working or the first version not working?
I can't reproduce your problem with the sandbox project running the same versions of dbt, Metabase and Snowflake, not sure what's different about your environment.
Assuming 1.1.0 is where it started though, #228 seems like the most likely culprit. Here's my blind attempt at reverting that change in #262, can you try installing that branch and see if that fixes it?
pip install git+ssh://[email protected]/gouline/dbt-metabase.git@fix/260
from dbt-metabase.
Oh I see, that's not clear. I edited my response. It works in 1.0.3, but in the next release of 1.1.0 it does not work.
I'll try that branch.
from dbt-metabase.
That did not fix it.
from dbt-metabase.
🤔 I'm having a different error on 1.0.3 now, that, you tell me, if this new error I have, is related to the missing dependencies error or not:
dbt-metabase exposures
runs fine (when I'm using dbt-metabase 1.0.3) with dependencies populated, but when I run dbt docs generate
I get an error where:
Exposure 'exposure.ex.__b_example__data' (models/exposures/exposures.yml) depends on a source named 'example_db_b.example_table' which was not found
This error, I think, is because:
I have three databases connected in Metabase, let's say database A, B and C. I have dbt configured to only look at database A. In Metabase we have custom SQL questions written for all three. This error is failing on a question in Metabase that is written for database b, which is not in dbt's output because I only have it on database a.
Is this related or different? If it's different I'll make a new issue.
from dbt-metabase.
Not much I can do without being able to reproduce this, unfortunately. See if you can write a query that exhibits your 1.3.1 issue against the sandbox project or your own minimal sample project that you can share as a repository (removing anything proprietary), then I can have a look.
from dbt-metabase.
To help you troubleshoot, I created a debug branch exposure-depends-dump
to try. This writes dependencies missing from the dbt model lookup as unknown('table')
in the exposure YAML and dumps those lookups in debug.yml:
- If
depends_on
are still empty, that means it's not extracting table names from your questions - If there are unknowns, that means it can't find dbt models corresponding to the extracted tables in your manifest
pip install git+ssh://[email protected]/gouline/dbt-metabase.git@exposure-depends-dump
from dbt-metabase.
Related Issues (20)
- Fix the docstring of DBTInterface because schema seems not ignored by the manifest parser HOT 1
- Configure API timeout for calls made to Metabase HOT 4
- Supporting metabase "Display values" for foreign keys (/api/field/XXX/dimension) HOT 1
- Accept True in the --metabase_verify option to default to the default CAs. HOT 2
- Requests failing due to "include_hidden" not being valid boolean string HOT 1
- Collection inclusion for exposures
- Exposures command fails. dbtmetabase/_exposures.py; Function: __extract_card_exposures(); dbt-metabase: 1.0.1
- --metabase_exclude_sources - Doesn't work after release HOT 1
- Add support for constraints HOT 1
- Add option for choosing continuation strategy for when models or fields are not synced HOT 1
- Add wildcard syntax to table filters HOT 1
- Exposure Extraction Error | In Case of Missing Cards in collection HOT 3
- Ability to manage additional table metadata via DTB documentation HOT 1
- "Display values" in a foreign key HOT 1
- HTTP Timeouts, how do I increase the timeout? HOT 3
- IndexError: list index out of range HOT 1
- Pass Metabase database ID when exporting models HOT 2
- Auto-Create Metabase Questions from dbt Models HOT 3
- Hidden visibility table columns should not be synced
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt-metabase.