Can not see the new view I've just created on my database

Get Help
1

Hi,

I’ve just created a new view on dbeaver, but I can’t see it on Metabase.

I’ve already tried to:

  • sync database schema
  • rescan field value
  • close the browser
  • CTRL + F5

But it doesn’t work.

Can i try something else to fix the problem?

I can’t update metabase on my own (I have the 0.60.2.2. version).

2

Does the Metabase user have permission to see the view?

3

Yes, it does! Also, I don’t have problems with previously loaded views, only with the new ones.

4

Then force a sync and send us the logs

5

Thank you! In the end, I solved the problem.

I tried to execute the view on metabase, even if I couldn’t see it:

select * from [database]

and I got:

Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='

So I updated the view, resolving a collation mismatch by standardizing text fields to utf8mb4_unicode_ci.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.