multiple user scenarios

[dataders]

Firebolt currently doesn't support schemas, so it's similar to SingleStore in that way. However, a core functionality of dbt is letting multiple users work in the same database without stepping on one another's toes. This is done conventionally by prefixing schema names with the schema given in the target (dbt Docs: What is a custom schema?)

One thing that Firebolt does that you might want to consider recommending is prefixing alias names instead of schema names. Check out their docs section on Supporting Concurrent Development

[pmishchenko-ua]

This is a cool idea, I think prefixing is also used in MySQL/SingleStore to add some structure to the set of tables, so this mechanism seems to be pretty helpful, I guess. I tested this with the latest adapter version, so I'm going to update our dbt docs with this info.