I cannot see the Data Warehouse tables I need in FileMaker

Problem

I made an ODBC connection to the Data Warehouse from FileMaker using the instructions provided in Accessing the Data Warehouse with FileMaker - Overview.

In FileMaker, I don't see the tables I need. Instead, I only see a few tables, such as CREDIT_CARD_SWEEPER or STAR.

However, using BrioQuery and the same ODBC connection and credentials, I can see everything I need.

What am I missing with FileMaker?

Background

Most of the "tables" in the Data Warehouse are actually "views". A view is a virtual table that presents a customized set of data from one or more of the underlying tables in the Warehouse.

For most uses at MIT, this is not an important distinction, but it does affect how we need to configure FileMaker.

Solution

When configuring your connection to the Data Warehouse in FileMaker, make sure to check the "Views" checkbox in FileMaker's "Edit Data Source" dialog box (found under File > Manage > External Data Sources):

1. In the Name field, type warehouse.
2. Select Type: ODBC.
3. Under Filter by Type, check the box for Views.
4. You may also check the boxes for Tables and System Tables, if desired, but most users will not need to do so.
5. Under Schema Name, type WAREUSER. (Optional, but recommended.)

For full configuration instructions, see:
Accessing the Data Warehouse with FileMaker - Configuration Instructions

See also: https://en.wikipedia.org/wiki/View_(SQL)