Postgres table schema for Jira data pipeline csv

Sean Kim_bltm13

I've been reading about data pipeline and dashboard for Jira.

https://confluence.atlassian.com/adminjiraserver0904/deploy-the-devops-dashboard-in-powerbi-1188768785.html

Here's my question.

Why are all the data types in the Postgres table varchar? Is it because of how the Power BI dashboard template is setup?

eg.

id varchar(50),<br>project_name&nbsp;varchar(1000),<br>created_date&nbsp;varchar(50),

 

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

It's because the varchar data type is the most appropriate one to capture the data you will get flowing from the app.  It's not so much PowerBI itself, it's that PowerBI finds it easiest to understand the data it extracts best as varchar.