Configuring the destination database schema creation

By default, during data generation to Databricks Delta tables, Structural creates the database schema for the destination database tables, then populates the database tables based on the workspace configuration.

To manage the database schema yourself, set the environment setting TONIC_DATABRICKS_SKIP_CREATE_DB to true. You can configure TONIC_DATABRICKS_SKIP_CREATE_DB from the Environment Settings tab on Structural Settings.

When TONIC_DATABRICKS_SKIP_CREATE_DB is true, then Structural does not create the destination database schema. Before you run data generation, you must create the destination database schema.

Note that you can override this setting in individual workspaces. For more information, go to Advanced workspace overrides.

For a diagram of the data generation process when you manage the destination schema, go to Data process - User-managed destination schema.