How to Retrieve Column Names and GUIDs in Bold BI Data Source created with PostgreSQL connection

Published:

In Bold BI, the GUID is used as the column name to resolve the large column name issue, as only 64 characters are allowed in PostgreSQL. This article will guide you on how to get the column names in a table along with their respective GUIDs created by Bold BI. You can get the GUIDs in two ways

From Bold BI application
From your database server

Note: This is applicable only for Extract mode data sources.

Steps to Retrieve Column Names and it’s GUIDs from Bold BI

Navigate to Data Sources Page
Select the data source and select the Edit Connection option.
Select the table which you want to get the GUIDs and click the menu option
Click the View Schema.
Here you can find the GUIDs of the table columns with its respective names.
You can copy the GUID using Ctrl + C by selecting the cell

Steps to Retrieve Column Names and it’s GUIDs from PostgreSQL server

Open pgAdmin and connect to your PostgreSQL server.
Select the database which is used as Data store in Bold BI stie.
Execute the following SQL command:

SELECT c.column_name, pgd.description
FROM pg_catalog.pg_statio_all_tables as st
INNER JOIN pg_catalog.pg_description pgd ON (pgd.objoid=st.relid)
INNER JOIN information_schema.columns c ON (pgd.objsubid=c.ordinal_position AND c.table_schema=st.schemaname AND c.table_name=st.relname)
WHERE c.table_name = 'tablename' AND c.table_schema = 'tableschema'

Note: Replace tablename and tableschema with your table name and schema name.