2 Replies Latest reply on Jul 26, 2018 2:53 AM by Anuj Vaijapurkar

    Getting error: failed to find conversion function from unknown to text; Error while executing the query

    Anuj Vaijapurkar

      Hi there,

       

      I am trying to pull a value from a JSON field of Postgres Table. I am using the Tableau Custom SQL as my Postgre Function isn't visible in the data source.

      below is my sql:

       

      select transaction_id, transaction_metadata ->> 'username' as user_name from transactions where transaction_date >= current_date - interval '30 days'.

       

      This query runs properly in pgAdmin. Also I see the proper results (data set) in the Tableau data source pane but when I place the dimensions on the sheet, it throws an error

       

      failed to find conversion function from unknown to text; Error while executing the query

       

      Any suggestions? Also why can't I see my Postgre Functions in the tableau? Aren't they supported like SQL Server's stored procedure?