Is your feature request related to a problem? Please describe.
As an engineer, I often want to cross-reference logs from Phoenix with other data or logs. The easiest way to do this would be to store all relevant information in the same database. However, Phoenix currently only supports logging to the public schema and this cannot be change. This can lead to conflicts when utilizing other services and discourages best practices for DB administration.
Describe the solution you'd like
An environment variable such as PHOENIX_SCHEMA that allows us to specify the schema Phoenix uses. Alternately, logging to an identifiable schema name like phoenix by default
Describe alternatives you've considered
I've considered using multiple databases but that is unwieldy and requires data replication. I've also considered running jobs on schedule to write data to another schema, this is still on the table as I consider how to structure metadata for immediate querying.
@Bruenia We added PHOENIX_SQL_DATABASE_SCHEMA for this purpose in v4.33.0. Please give it a try and let us know if you encounter additional issues. Thanks!
Is your feature request related to a problem? Please describe. As an engineer, I often want to cross-reference logs from Phoenix with other data or logs. The easiest way to do this would be to store all relevant information in the same database. However, Phoenix currently only supports logging to the
public
schema and this cannot be change. This can lead to conflicts when utilizing other services and discourages best practices for DB administration.Describe the solution you'd like An environment variable such as
PHOENIX_SCHEMA
that allows us to specify the schema Phoenix uses. Alternately, logging to an identifiable schema name likephoenix
by defaultDescribe alternatives you've considered I've considered using multiple databases but that is unwieldy and requires data replication. I've also considered running jobs on schedule to write data to another schema, this is still on the table as I consider how to structure metadata for immediate querying.