# Structural differences and limitations with Databricks {% hint style="info" %} **Required license:** Professional or Enterprise {% endhint %} ## No automatic sensitivity scans For a Databricks workspace, Structural does not automatically run sensitivity scans. You must [run the sensitivity scan manually](/app/generation/identify-sensitive-data/running-the-structural-sensitivity-scan.md#sensitivity-scan-manual) or [set up scheduled sensitivity scans](/app/generation/identify-sensitive-data/running-the-structural-sensitivity-scan.md#sensitivity-scan-schedule). ## No workspace inheritance Databricks workspaces do not support workspace inheritance. ## Table mode limitations You can only assign the [De-Identify](/app/generation/table-modes.md#de-identify) or [Truncate](/app/generation/table-modes.md#truncate) table modes. For Truncate mode, the table is ignored completely. The table does not exist in the destination database. While you cannot assign the [Incremental](/app/generation/table-modes.md#incremental) table mode in a Databricks workspace, you can replicate the effect. To do this: * The data must include partition columns. * You must set `spark.sql.sources.partitionOverwriteMode=dynamic`. ## Generator limitations Based on the version of Databricks, a Databricks workspace can only use the following generators:
Databricks 10.4 and earlierDatabricks 11.3 and later
Address
Alphanumeric String Key
ASCII Key
Business Name
Categorical
Character Scramble
Character Substitution
Company Name
Conditional
Constant
Continuous
Custom Categorical
Date Truncation
Email
File Name
Find and Replace
FNR
Geo
HIPAA Address
Hostname
Integer Key
IP Address
MAC Address
Name
Noise Generator
Null
Numeric String Key
Phone
Random Boolean
Random Double
Random Hash
Random Integer
Random Timestamp
Random UUID
Regex Mask
Sequential Integer
Shipping Container
SSN
Struct Mask
Timestamp Shift
Unique Email
URL
UUID Key
XML Mask

Address
Business Name

Categorical

Character Scramble

Company Name

Conditional

Constant

Continuous

Custom Categorical

Date Truncation

Email

FNR

HIPAA Address

Integer Key

IP Address

JSON Mask

MAC Address

Name

Noise Generator

Null

Random Double

Random Hash

Random Integer

Random UUID
Regex Mask

SSN

Struct Mask

Timestamp Shift Generator

UUID Key

## No subsetting, but support for table filtering Databricks workspaces do not support subsetting. However, for tables that use the De-Identify table mode, you can provide a `WHERE` clause to filter the table. For details, go to [Using table filtering for data warehouses and Spark-based data connectors](/app/generation/subsetting/table-filtering.md). ## No upsert Databricks workspaces do not support upsert. ## No output to a container repository For Databricks workspaces, you cannot write the destination data to a container repository. ## No post-job scripts For Databricks workspaces, there is no option to run post-job scripts after a job. You can create [webhooks](/app/workflows/webhooks.md) that are triggered by data generation jobs. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.tonic.ai/app/setting-up-your-database/databricks/databricks-tonic-differences.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.