Hello,
I'm using metabase (v0.50.6) on top of a Postgres (PostgreSQL 15.3). The table I want to query is put into this postgres through airbyte (it is a table of Github pull requests). It has the following schema :
| column_name | data_type |
|---|---|
| _airbyte_meta | jsonb |
| base | jsonb |
| created_at | timestamp with time zone |
| updated_at | timestamp with time zone |
| requested_teams | jsonb |
| requested_reviewers | jsonb |
| _airbyte_extracted_at | timestamp with time zone |
| _airbyte_generation_id | bigint |
| id | bigint |
| head | jsonb |
| user | jsonb |
| number | bigint |
| assignee | jsonb |
| assignees | jsonb |
| closed_at | timestamp with time zone |
| merged_at | timestamp with time zone |
| milestone | jsonb |
| body | character varying |
| _airbyte_raw_id | character varying |
| repository | character varying |
| state | character varying |
| title | character varying |
| author_association | character varying |
| commits_url | character varying |
I can make sql queries on the table, even on jsonb. However while using "question", I can't have a result because I have No field found from table "...".
Side effect, in a sql query, I can't have a field filter on the field "created_at" or "closed_at".
I have a feeling that this is because of the JSONB fields, but no certainty. What do you think ?