So, i've created a view in my postgres by necessity. When I synchronize the db the view appears, but when I try to do queries on it the columns aren't available to filter but i can summarize by count of rows and its ok.
My view:
On Admin -> Data Model:
The Diagnostic Info and Logs about the view are below.
Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+10-post-Ubuntu-2ubuntu218.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+10-post-Ubuntu-2ubuntu218.04",
"os.name": "Linux",
"os.version": "4.15.0-96-generic",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2020-05-28",
"tag": "v0.35.4",
"branch": "release-0.35.x",
"hash": "b3080fa"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}
Logs:
-
[ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables We found new tables: (Table 'jira.new_operacoes')
-
[ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables Updating descriptions for tables: (Table 'jira.new_operacoes')'jira.new_operacoes'"
-
[ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 INFO metabase.api.table Table 'new_operacoes' is visible. Resynchronizing
-
[ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 ERROR metabase.sync.util Error syncing Fields for Table 'Table 341 'jira.new_operacoes''
-
[ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:33:34-03:00 ERROR metabase.sync.util Error syncing Fields for Table 'Table 341 'jira.new_operacoes''