No quite sure what you request here, but
Searched for the field id 816 (which is the one Billing Date) on the logs and found just stuff like this:
[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-11T12:37:12+01:00 DEBUG metabase.server.middleware.log GET /api/field/816/values 200 25.3 ms (4 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (2 idle, 0 queued) (108 total active threads) Queries in flight: 0 (0 queued)
[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-11T12:37:38+01:00 DEBUG metabase.server.middleware.log PUT /api/field/816 200 10.8 ms (5 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (114 total active threads) Queries in flight: 0 (0 queued)
Also went to metabase db and searched for the field
and the info:
{
"metabase_field": [
{
"id" : 816,
"created_at" : "2021-01-12T15:15:40.958Z",
"updated_at" : "2021-08-11T11:37:38.009Z",
"name" : "BILLING_DATE",
"base_type" : "type/Date",
"semantic_type" : "type/CreationDate",
"active" : true,
"description" : null,
"preview_display" : true,
"position" : 41,
"table_id" : 54,
"parent_id" : null,
"display_name" : "Billing Date",
"visibility_type" : "normal",
"fk_target_field_id" : null,
"last_analyzed" : "2021-01-12T15:17:25.537Z",
"points_of_interest" : null,
"caveats" : null,
"fingerprint" : "{"global":{"distinct-count":74,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2015-07-20T00:00:00Z","latest":"2052-03-20T00:00:00Z"}}}",
"fingerprint_version" : 5,
"database_type" : "DATE",
"has_field_values" : "none",
"settings" : "{"time_enabled":null,"view_as":"auto","date_abbreviate":true}",
"database_position" : 41,
"custom_position" : 0,
"effective_type" : "type/Date",
"coercion_strategy" : null
}
]}
Regarding field values on metabase_field_values table, I couldn't find any record for that field
Any other suggestions?
Rgds