Extract text column from message_log Rasa X

[Deprecated] Rasa X Community Edition
1

Hello Team, I am implementing a PoC and decided to use Docker Compose Quick installation.

I have always used Rasa OSS and this time I want to showcase benefits from Rasa-x

Is there any way using rasa-x to extract a table like this? or some columns?

43%20PM
43%20PM3562×832 298 KB

from rasa / message_log table I am exporting the ‘text’ column.

In addition, do you have any example of how customers running Rasa in production perform ETL in the db? (recommended practices, lessons learned … so on)

thanks!

2

Hi @WilliamAriasZ,

Are you running on Windows or Linux/Mac ?

You can connect to the Postgresql db using the psql that is part of the postgresql docker container.

3

Hello @Arjaan, yes, that is exactly what I usually do, forgot to mention that screenshot corresponds to my Linux Server, where I read tables from Postgres. I was wondering if you have any other suggestion from your experience or customers when it comes to ETL. Thanks