Redshift Serverless is missing Geospacial data types

0

This was added to provisioned Redshift 2021-11-24 (https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-redshift-spatial-geography-datatype/), yet is still not available in Redshift Serverless. Meanwhile, the documentation offers no indication whatsoever that there's functionality that's only available with the provisioned version of Redshift (https://docs.aws.amazon.com/redshift/latest/dg/geospatial-overview.html).

I have a test table in Serverless Redshift which I test every couple days, and it'd be so much simpler if I just had a rough idea of when (or if?) there's a plan for Serverless to have feature parity with non-serverless Redshift. Furthermore, a listing of what other features are missing would be very helpful in determining if the service is even something we want to be using.

The test query is as simple as:

alter table test_db.main.test_table

add column GeoLocation geography;

ERROR: Column "geolocation" has unsupported type "geography".

asked a year ago65 views
2 Answers
1

Please, consider that Redshift Serverless is still in preview.

When you encounter such problems, send them with details to ***redshift-preview-serverless@amazon.com ***.

Including what syntax tried and errors you got.

The team will, then, be able to investigate.

EXPERT
answered a year ago
  • Is that still the recommended path, after filing a Support Ticket? From my point of view, I've reported this issue multiple times already, I'm just trying to find out if a timeline exists where it'll be solved.

  • @AWS-User-9279990, yes that is the recommended path, during a preview that is the way the team capture requests to prioritize the new features.

    you do not need a support ticket. the email is enough. Sometime getting a ETA will not be possible though.

0

Hi, as mentioned earlier, Serverless is still in preview and changes may be happening frequently.

I was able to create and alter table successfully in Redshift Serverless using datatype ‘geography’ so you may want to test this now.

create table x (geolocation geography) show table x

Create table test1 (name char(10))

alter table test1 add column geolocation geography

Almost all provisioned features are available in Redshift Serverless with the exception of DMS & KDF which are not certified yet in Serverless.

Nita_S
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions