Hey guys, i'm facing a very similar case to this one:
https://discourse.metabase.com/t/cant-change-timestamp-type-to-other-than-day/
But oddly enough this started happenning a day ago and coudn't solve my problem with the tips in this discussion.
The underlying data type is a timestamp.
Also ran the metadata for the column :
"description":null,"database_type":"timestamp(3) with time zone","semantic_type":"type/JoinTimestamp","table_id":101,"coercion_strategy":null,"table":{"description":null,"entity_type":"entity/GenericTable","schema":"stitch_zendesk","db":{"description":"Dados de saúde e zendesk","features":["full-join","basic-aggregations","standard-deviation-aggregations","expression-aggregations","percentile-aggregations","foreign-keys","right-join","left-join","native-parameters","nested-queries","expressions","set-timezone","regex","case-sensitivity-string-filter-options","binning","inner-join","advanced-math-expressions"],"cache_field_values_schedule":"0 0 4 * * ? ","timezone":"UTC","auto_run_queries":true,"metadata_sync_schedule":"0 37 * * * ? ","name":"Presto-BQ","settings":null,"caveats":null,"creator_id":null,"is_full_sync":true,"updated_at":"2022-07-21T19:16:47.858094Z","cache_ttl":null,"details":{"additional-options":null,"schema":null,"ssl":false,"password":"MetabasePass","let-user-control-scheduling":false,"kerberos":false,"port":8080,"advanced-options":true,"host":"presto-sql-service","tunnel-enabled":false,"user":"pipouser","catalog":"bigquery"},"is_sample":false,"id":5,"is_on_demand":false,"options":null,"engine":"presto","initial_sync_status":"complete","refingerprint":true,"created_at":"2021-08-16T18:03:35.6743Z","points_of_interest":null},"show_in_getting_started":false,"name":"ticket_metrics","caveats":null,"updated_at":"2022-07-21T17:58:33.359214Z","active":true,"id":101,"db_id":5,"visibility_type":null,"field_order":"database","initial_sync_status":"complete","display_name":"ticket_metrics","created_at":"2021-09-03T19:37:13.343439Z","points_of_interest":null},"name":"solved_at","fingerprint_version":5,"has_field_values":"none","settings":null,"caveats":null,"fk_target_field_id":null,"dimensions":[],"updated_at":"2022-07-21T19:59:28.904003Z","custom_position":0,"effective_type":"type/","active":true,"nfc_path":null,"parent_id":null,"id":1782,"last_analyzed":"2021-09-03T19:41:25.535288Z","position":2,"visibility_type":"normal","preview_display":true,"display_name":"solved_at","database_position":2,"name_field":null,"fingerprint":{"global":{"distinct-count":493,"nil%":0.08037383177570093},"type":{"type/DateTime":{"earliest":"2019-11-25T14:47:31Z","latest":"2020-04-29T12:53:50Z"}}},"created_at":"2021-09-03T19:39:30.123152Z","base_type":"type/","points_of_interest":null}
Anyone have any idea on how to solve this? Thanks!
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10",
"os.name": "Linux",
"os.version": "4.9.0-9-amd64",
"user.language": "en",
"user.timezone": "Brazil/East"
},
"metabase-info": {
"databases": [
"presto"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.1"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-05-31",
"tag": "v0.43.2",
"branch": "release-x.43.x",
"hash": "433d533"
},
"settings": {
"report-timezone": "UTC"
}
}
}