Adding ColumnGeographicRole LONGITUDE/LATITUDE to existing dataset causes an error: Invalid ColumnTag added for column with name latitude

Question & Answer
1

What would be the proper way to mark two DECIMAL fields as geospatial fields in a QuickSight DataSet?

I tried to add the following definition to an existing DataSet and deploy a totally new one but received an error: Invalid request provided: Invalid ColumnTag added for column with name latitude (Service: QuickSight, Status Code: 400

Any advice appreciated!

        "CastColumnTypeOperation": {
         "ColumnName": "latitude",
         "NewColumnType": "DECIMAL"
        },
        "TagColumnOperation": {
         "ColumnName": "latitude",
         "Tags": [
          {
           "ColumnDescription": {
            "Text": "foo"
           },
           "ColumnGeographicRole": "LATITUDE"
          }
         ]
        }
       },
       {
        "CastColumnTypeOperation": {
         "ColumnName": "longitude",
         "NewColumnType": "DECIMAL"
        },
        "TagColumnOperation": {
         "ColumnName": "longitude",
         "Tags": [
          {
           "ColumnDescription": {
            "Text": "bar"
           },
           "ColumnGeographicRole": "LONGITUDE"
          }
         ]
        }
       },
1 Like
2

Hello @markusl , welcome to the Quicksight community!

Can you try the solution in the article below? I think it is similar to what you ran into:

Let me know if this helps!

1 Like