咨询Metabase表分析connections及Question模块内CONNECTIONS的含义

Hey there! Let me clarify what those "Connections" mean in Metabase, based on my experience using the tool for data exploration.

1. What does "Metabase connections" mean in table analysis? #

In the context of Metabase’s table analysis features, "Connections" refers to established relationships between tables. These relationships can be:

• Database-native foreign key links: Metabase automatically scans your database to detect formal foreign key constraints that link tables (e.g., a user_id column in an orders table pointing to the id column in a users table).
• Manual relationships: If your database doesn’t use formal foreign keys, you can create custom connections in Metabase’s Data Model section to link tables together—these also count as "Connections" in the analysis view.

These connections are key for building cross-table queries, exploring related data, and understanding how your dataset is structured.

2. Why does the "x CONNECTIONS" box show 0 when viewing a table’s fields? #

That specific "CONNECTIONS" count on the table field view (the one next to "x FIELDS") tracks how many recognized relationships exist between the current table and other tables in your database, from Metabase’s perspective. Here are the most common reasons it shows 0:

• No relationships exist at all: Your table isn’t linked to any other tables via database foreign keys, and you haven’t set up any manual relationships in Metabase’s Data Model settings.
• Metabase failed to auto-detect existing relationships: Metabase relies on scanning your database’s schema to pick up foreign keys. If your tables use non-standard naming conventions (e.g., user_fk instead of user_id), or if the foreign keys aren’t properly indexed, Metabase might miss them. You can fix this by manually adding connections in Admin > Data Model.
• Permission limitations: In rare cases, if your Metabase account doesn’t have access to view other tables that might be connected to this one, those relationships won’t appear here, resulting in a 0 count.

内容的提问来源于stack exchange，提问作者Ryan Dahl