Unsupported data types

Question & Answer
1

We are pulling data from the third party source (post-gres sql). I am unable to import one of the columns as its datatype is unsupported. I can not alter the data type as its coming from third party. How can i still import it as I need that column to report metrics.

image
image1319×372 29.1 KB

2

I’m wondering if QuickSight UI allows you to specify a different data type to use for this column. Do you see it in the list on the left? Can you set data type to String?

3

I am not able to see that column. It’s not getting imported in the dataset.

4

How is the dataset being imported? Are you uploading or pulling it in from a different source?

5

I am pulling it from different datasource

6

Hi,

its very simple to change the field name and its data type. but the data in column should be validated. like integer must contains 0-9 or no spaces etc.

You must review data for those columns before upload to SPICE.

For data uploading you should review this video it may be help you :slight_smile:

1 Like
7

If it is failing even before doing the field listing, you may consider rewriting this as a custom sql query and changing the ip_address field to string there. postgreSQL has cidr and inet types which are typically used for ip addresses and I would suspect QuickSight is having trouble handling these fields. So you could request them in a custom query like so

  SELECT
      ... 
      text(ip_address) AS ip_address
  FROM
    ...
1 Like