I need a hint how to remove the HTML tags from dim_vulnerability.descritption.
So far, I have imported the entire dim_vulnerability table directly into PowerBI and deleted the unnecessary columns within powerBI and removed HTML tags, e.g. in the column description.
In order to optimise the performance of my PowerBI dashboard, I have started to build saved views on PGAdmin and then connect them to PowerBI.
Now I have read the following in the data warehouse schema for “description”:
A verbose description for the vulnerability. The description is represented using HTML markup that can be “flattened” using the htmlToText() function.
How do I integrate this directly into my simple query?
EXTRACT(YEAR FROM dv.date_published) AS published_year,
FROM dim_vulnerability dv