How to create database view?

Helennnnn · June 8, 2020, 10:47pm

Hi,
I want to apply field filter on custom column. Looks like the possible way is to create database view. But I do not know how to create database view in Metabase so that I can use field filter on this view.

Is there any way to create database view so that field filter can use on this view?

Thanks

CZvacko · June 9, 2020, 7:23am

Hi, as I know, database view cannot be created in Metabase, it need to be created directly in database server.

Helennnnn · June 9, 2020, 4:02pm

Hi,
Thanks for your reply!

I do not have privilege to create view in database server. Is there any way to apply field filter on custom column?

Thanks

flamber · June 9, 2020, 4:05pm

@Helennnnn No, Field Filters are currently limited to a column in a table/view.

Helennnnn · June 9, 2020, 4:32pm

Hi,
Thanks for your response!

dbuser · August 27, 2023, 2:21pm

@flamber is that still the case that field filters can not apply to a result which is a union of tables ? (relates to my question from today)

Luiggi · August 28, 2023, 10:58am

Try building a view with the result of the 2 tables then field filters will be able to work there

dbuser · August 28, 2023, 11:03am

@Luiggi a View would be created on the DB itself (like POSTGRESQL) - not MetaBase, right ?

Luiggi · August 29, 2023, 7:15am

Yes, Metabase can’t create views