Displaying data from Tracker Store (PostgreSQL)

Rasa Open Source
1

Hey there,

I have a test setup, where I run Rasa (1.10.10) and setup a remote PostgreSQL DB as a Tracker Store. I wanted to see if I can write some SQL to further look into what has been stored in the Tracker Store, especially in the column “data”, which seems to store a lot of information in JSON.

However, the column data type seems to be text and not JSON, right?

Am I missing something here?

Thanks! Mo

2

I was able to resolve this by casting type text to json in the SQL statement.

1 Like
3

select data::json->>‘parse_data’ from public.events limit 10

You should be to change parse_data by the fieldname that you require