I would like the drawing to be in polygon format, but it is coming as circles, if i join the dots, the polygon is totally wrong the polygon design.
dimension: bounds {
type: location
sql_latitude: ST_Y(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));;
sql_longitude: ST_X(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));;
}