Workspace configuration settings

The workspace details for a new or edited workspace specifies information about the workspace and the workspace data.

Common workspace fields

All workspaces have the following fields, used to identify the workspace and indicate the connector type:
  1. 1.
    In the Workspace name field, enter the name of the workspace.
  2. 2.
    In the Workspace description field, provide a brief description of the workspace. The description can contain up to 200 characters.
  3. 3.
    In the Tags field, provide a comma-separated list of tags to assign to the workspace. For more information on managing tags, go to Assigning tags to a workspace.

Workspace type (data generation or data science mode)

Depending on your Tonic license agreement, you can either:
Under Data Science Mode, the Enable Data Science Mode toggle determines whether the workspace is a data generation workspace or a data science mode workspace.
  • If your instance only supports data generation workspaces, then the toggle is not displayed.
  • If your instance only supports data science mode workspaces, then the toggle is displayed and locked in the on position.
  • If your instance supports both data generation and data science mode workspaces, then the toggle is displayed. By default, it is in the off position, indicating to create a data generation workspace. To create a data science mode workspace, toggle Enable Data Science Mode to the on position.

Connection type

Under Connection Type, select the type of database to connect to. You cannot change the connection type on a child workspace.
For data generation, the source and destination databases are always of the same type.
The Basic and Professional licenses limit the number and type of data connectors you can use.
  • A Basic instance can only use one data connector type, which can be either PostgreSQL or MySQL. After you create your first workspace, any subsequent workspaces must use the same data connector type.
  • A Professional instance can use up two different data connector types, which can be any type other than Oracle. After you create workspaces that use two different data connector types, any subsequent workspaces must use one of those data connector types.
For a data science mode workspace, there is also a CSV option, which allows you to use uploaded CSV files as the source of your model data.
If you don't see the database that you want to connect to, or you want to have different database types for your source and destination database, contact [email protected].

Connection details

When you select a connector type, Tonic updates the view to display the connection fields used for that connector type. The specific fields vary based on the connector type.

Source and destination settings

For most connector types, for data generation workspaces, there is a Source Settings section and a Destination Settings section. For data science mode workspaces, there is only a Source Settings section.
The Source Settings section provides connection information for the source database. You cannot change the source database connection for a child workspace.
The Destination Settings section provides connection information for the destination database. Tonic does not create the destination database. It must exist before you generate data.

Copying source connection details to the destination database

For Destination Settings, select Copy Settings from Source to copy the source connection details to the destination database, if both databases are in the same location. Tonic does not copy the connection password.

Testing the database connections

You use the Test Source Connection and Test Destination Connection options to verify that Tonic can use the connection details to connect to the database. Tonic uses the connection details to try to reach the source or destination database, and indicates whether it succeeded or failed. We strongly recommend that you test the connections.
The environment setting TONIC_TEST_CONNECTION_TIMEOUT_IN_SECONDS determines the number of seconds before a connection test times out. You can configure this setting from the Environment Settings tab on Tonic Settings. By default, the connection test times out after 15 seconds.

Other connection options

Writing to container artifacts

Some data connectors allow you to choose to write the transformed data to container artifacts instead of to a database server. For more information, go to Writing data generation output to a container repository.

File storage type for a file connector workspace

For a file connector workspace, the source data comes from files that you upload from either cloud storage or a local file system. You identify the type of file storage. For cloud storage, you also provide the output location. For more information, go to Configuring the file connector storage type and output options.

Upsert configuration

For data connectors that support upsert, the connection details include an Upsert section to allow you to enable and configure upsert. For more information, go to Enabling and configuring upsert.

Workspace statistics seed

For generators where consistency is enabled, a statistics seed enables consistency across data generation runs. The Tonic-wide statistics seed value ensures consistency across both data generation runs and workspaces.
In the workspace configuration, use the Override Statistics Seed setting to override the Tonic-wide statistics seed value. You can either disable consistency across data generations, or provide a seed value for the workspace. The workspace seed value ensures consistency across data generation runs for that workspace, and across other workspaces that have the same seed value.
For details about using seed values to ensure consistency across data generation runs and databases, go to Enabling consistency across runs or multiple databases.

Uploading CSV files for data science mode

For a data science mode workspace, instead of connecting to a database, you can upload one or more CSV files that contain the data that you want to use. Each file that you upload becomes a table in your source data. You can then issue model queries against the data.
To indicate to use CSV files to provide the source data, for Connection Type, under Upload your own data, click CSV.

Adding CSV files

Under Add dataset files, to add files to the list, either:
  • Click Select files to upload, then select the files.
  • Drag and drop the files from your machine.
You cannot upload a file with the same name as an existing file in the list. To replace the data in an existing file, you must delete the file and then upload the updated file.

Configuring an uploaded file

To configure the options for a file:
  1. 1.
    If the file includes a heading row, then toggle Treat first row as column header to the on position.
  2. 2.
    In the Column Delimiter field, provide the character that is used as delimiter. The default is a comma.
  3. 3.
    In the Escape Character field, provide the character that is used to escape characters. The default is a backslash (\).
  4. 4.
    In the Quote Character field, provide the character that is used to quote text. The default is the double quote.
  5. 5.
    In the NULL Character field, provide the text used to indicate a null value. The default is \N.
  6. 6.
    To display a preview of the data in the file, click Expand.

Removing a file

To remove a file, click Remove.

Blocking data generation for all schema changes

For data generation workspaces, most connectors have a Block data generation if schema changes detected toggle. The setting is usually in the Source Server section.
By default, the option is turned off. When the option is off, Tonic only blocks data generation when there are conflicting schema changes. Tonic does not block data generation when there are non-conflicting schema changes.
If this option is turned on, then if Tonic detects any changes at all to the schema, then data generation is blocked until you resolve the schema changes. For more information, go to Viewing and resolving schema changes.
Last modified 2mo ago