Postgresql, Redshift, Etl, Transformation, Data Warehouse.
data in the application database, and our data warehouse doesn’t support PostGIS data types, we’ll have to extract Latitude and Longitude from Points stored in the database. All location related data will be stored in double precision floating point in Redshift. Point While for creating a point