PROJECT OPTIONS

Database

Project-wide settings for the target table names and for the data that is read.

Table prefix

A text that Full Convert puts in front of every target table name. For example, a prefix of exp_ turns Customers into exp_Customers.

Name casing

Tunes the table and column names in the target to your expectations.

  • Default picks the casing the target database is most comfortable with, so names don't need quoting. Some databases prefer uppercase, some lowercase.
  • Uppercase and Lowercase force one casing everywhere.
  • Unchanged preserves the names exactly as they are in the source.
  • Camel case, Pascal case, Snake case and Screaming snake rewrite the names in that style, so OrderDetails becomes orderDetails, OrderDetails, order_details or ORDER_DETAILS. Handy when the source and target follow different naming conventions.

Source WHERE filter

Copies only part of the data. The condition is applied to every table in the project, so only use it when the columns it mentions exist in all tables, such as a tenant_id or an updated_at column. For a single table, use the per-table filter in the table mapping instead. If a table has both, the two conditions are combined.

Target WHERE filter

Applied when reading the target tables, which happens in replication projects during comparison. Use it the same way to compare only part of the target data.

Previous
Performance

If this was useful,
our newsletter will be too.

Get monthly insights on data engineering, AI, and building critical infrastructure - direct from the Spectral Core team and CEO Damir Bulic.