What would you use for SQL to Databricks migration: JDBC, ODBC, or ADF Copy activity, and why?
For the SQL portion, validate migration completeness by comparing object row counts between the SQL source and Databricks target. Return only objects that are missing from one side or have different counts.
object_name, source_row_count, target_row_count, and validation_status.SOURCE_ONLY, TARGET_ONLY, and COUNT_MISMATCH statuses, ordered by object_name ascending.| Column | Type | Description |
|---|---|---|
| object_namePK | VARCHAR(100) | Name of the SQL source object |
| source_row_count | BIGINT | Number of rows in the source object |
| Column | Type | Description |
|---|---|---|
| object_namePK | VARCHAR(100) | Name of the Databricks target object |
| target_row_count | BIGINT | Number of rows in the target object |