Schema creation automation

[nagmo]

is there a way to create the schema automatically?
in Looker for example when you connect the DB you get an automatic view per table and fields are defined as measures or dimensions by default.
is there any way to do that on cube? (other then implementing it ourselves)

[paveltiunov]

Hey @nagmo ! Have you tried to generate schema in Playground?

[chicco785]

@paveltiunov in our case the playground won't help much, in the sense that yes it generate the schemas, but as far I understand you still have to save then the resulting file in the app and restart id. It would be nice to have a functionality similar to the query builder for react dashboard apps. I.e. a SchemaBuilder. Suppose you need a new cube because you added a new table, it would be nice to have the possibility to create such cube schema from the app and store it in the GraphQL backend.

[paveltiunov]

@chicco785 Makes sense. This is certainly outside of our roadmap as of right now. Cube.js provides easy ways to generate a schema based on external definitions: https://cube.dev/docs/schema-execution-environment#async-module.

I'd leave this one open for community contribution. Looking forward to PRs here!