User defined table in database used by temporal to store history

Community Support
1

Hi Maxim/ Thiomir

Is it feasible to create a user defined table in the schema used by temporal to store the history of workflows. If we do that, does it will create any impact.

Thanks.

2

Event histories are stored in temporal db, history_node table already.
You should not have to create custom tables in temporal db. If you need your event histories (and visibility data) to persist past namespace retention period consider using archival.

3

Hi @tihomir,

I will not touch any of the tables for temporal, but I want to have a table in parallel with tables used by temporal in same schema. Can we do that??

Thanks

4

I guess if you modified schemas and build your custom image, see for example for postgres: temporal/schema.sql at master · temporalio/temporal · GitHub
Still not sure about your use case and why you would want it