Naming-Convention

如何修復 Metabase 中列的命名?

  • December 30, 2018

Metabase目前導入列名並嘗試找出措辭。這個約定在我的模式中被徹底打破了。例如,當它掃描我的 PostgreSQL 數據庫時,它會帶入如下列,

As St Tre As Appoint Or Name First
As St Tre As Appoint Or Name Last
As St Tre As Name First
As St Tre As Name Last
As St Tre As Name Organization
As St Tre As Name Prefix Cd
As St Tre As Name Short
As St Tre As Name Suffix Cd
As St Tre As Per Sent Type Cd
As St Tre As Primary Phone Ext
As St Tre As Primary Phone Number

實際上它們看起來像,

assttreaspersenttypecd   
assttreasnameorganization
assttreasnamelast        
assttreasnamesuffixcd    
assttreasnamefirst       
assttreasnameprefixcd    
assttreasnameshort       
assttreasstreetaddr1     

assttreas“助理司庫”的簡寫在哪裡。有沒有簡單的方法來解決這個問題或禁用這個“功能”。

您可以在管理 -> 設置 -> 正常中禁用“友好的表和欄位名稱”:

在此處輸入圖像描述

完成後,轉到 Databases -> your_db_name 並觸發“立即同步數據庫模式”和“立即重新掃描欄位值”操作:

在此處輸入圖像描述

引用自:https://dba.stackexchange.com/questions/220750