Postgres table schema for Jira data pipeline csv

[Sean Kim]

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),
project_name varchar(1000),
created_date varchar(50),

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Sean Kim]

Thank you for the relpy