Mapbox Points aren't Populating using SQL

[tayvionp]

I am building an AWS dashboard/app that maps the longitude and latitude on mapbox, to get a visual of where logins are successful.

Currently, I am using {{[ formatDataAsArray(_.pick(successful_console_logins.data,['latitude','longitude'])) ]}} to grab the data from the SQL query and it does accurately shows the arrays when i hover over the points field however it is not populating the points on the the map

here's a screenshot of my current mapbox settings

[Tess]

Hi @tayvionp The points field expects an array of objects, but it looks like your input is evaluating to an array with an array of objects. If you remove the square brackets around {{[ formatDataAsArray(_.pick(successful_console_logins.data,['latitude','longitude'])) ]}} to {{formatDataAsArray(_.pick(successful_console_logins.data,['latitude','longitude'])) }}, does it work?