What is the naming pattern for schemas and tables in my DB?
Octolis does not replicate your data inside of its own internal database.
It has been designed to handle all data treatments directly into a database that you own.
This approach gives you extensive control and flexibility to turn your data warehouse more operational and put it at the center of your (modern) data stack.
This also means Octolis creates different resources inside of your database, below are the naming patterns we use.
Schemas naming patterns
Public namespace (octolis_{{customer_shortname}}_public): stateful resources that you might access (e.g. for BI use cases).
Private namespace (octolis_{{customer_shortname}}_private): stateful resources that we use to work with data (not user-friendly for BI use cases).
Temporary namespace (octolis_{{customer_shortname}}_temporary): temporary resources (deleted after some time (not user-friendly for BI use cases).
We also include a random string at the end of the table names to make sure they are unique
In all cases, please make sure not to directly alter/drop any resource managed by Octolis inside of the DB. This would compromise the app's ability to work properly.