QS custom query - don't have access to varchar data types

Question & Answer
,
1

Hi,
what could be the reason, please we don’t have access to the varchar data type fields (Postgres DB). We are able to access “integer” data type fields, but for the “varchar” we receive an error: " 12 fields were skipped because they use unsupported data types"
We use Custom SQL - query to PostgreSQL:

image
image588×651 19.7 KB

Direct query to the DB shows all the table fields, varchar incl.

2

Hi @rstoyanova - Is it possible to put the column names in the select statement and run the sql, see whether you are able to see the data or not.

Regards - Sanjeeb

3

Hi @Sanjeeb2022
, please see the error, when we try to select 2 of the “unsupported” fields:

image
image881×589 32.4 KB

As we can see, the error is for datetime and varchar DB fields.

Regards

4

Hi @rstoyanova - This is weird. Can you please share the postgres version. and also click on the show details.

It will be good if you can raise a request to AWS Customer support team so that they can validate this error and guide you. To raise a request, please follow the below link -

Let’s hear from other experts - @David_Wong @duncan @ErikG

Regards - Sanjeeb

5

Hi @Sanjeeb2022
I updated the screenshot above with the details.

Regards

6

Hi @rstoyanova - Thanks.Can you please give the column list to see the details? If you can give the complete sql, that will also work.

Regards - Sanjeeb.

7

Hello @rstoyanova and @Sanjeeb2022 !

@rstoyanova are you able to follow up on the details @Sanjeeb2022 asked about above?

It has been some time since we have heard from you but would still like to help you find a solution? If we do not hear from you in 7 days this post will be archived.

8

Hi @Sanjeeb2022 , @duncan
we found a decision - using cast the fields in the script to text, date etc:

Select [field_name]:TEXT
,[filed_name]:Date
from …

it resolved the problem.

Regards

1 Like
9

Hey @rstoyanova !

Thank you for sharing your solution!