This content has been marked as final. Show 2 replies
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?