[BUG]: Teradata conversion - getting error after making changes in base config

[soumyadhasharath]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Application crashed

Current Behavior

After making few changes in base config file - base_teradata2databricks_sql.json, transpiler is failing with errors.

Logs:
ERROR [d.l.bladebridge.transpiler] RUN ERROR: Unmatched ( in regex; marked by <-- HERE in m/^(\s*?).\bcatch\s\( <-- HERE / at PERL2EXE_STORAGE/DBCatalog/SQLParser.pm line 2371.
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] at PERL2EXE_STORAGE/DBCatalog/SQLParser.pm line 2371.
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] DBCatalog::SQLParser::categorize_statement(DBCatalog::SQLParser=HASH(0xc44a908), "MERGE INTO employees_td tgt\x{a}USING employees_stage src\x{a}ON tgt."...) called at PERL2EXE_STORAGE/DBCatalog/SQLParser.pm line 1766
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] DBCatalog::SQLParser::analyze_statement(DBCatalog::SQLParser=HASH(0xc44a908), "MERGE INTO employees_td tgt\x{a}USING employees_stage src\x{a}ON tgt."..., 0) called at PERL2EXE_STORAGE/DBCatalog/SQLParser.pm line 1634
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] DBCatalog::SQLParser::analyze_file(DBCatalog::SQLParser=HASH(0xc44a908), "C:/Users/user~1.user/AppData/Local/Temp/bladerunner_dfw11k91"...) called at PERL2EXE_STORAGE/DBCatalog/SQLParser.pm line 666
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] DBCatalog::SQLParser::normalize_import(DBCatalog::SQLParser=HASH(0xc44a908)) called at (eval 25) line 393
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] main::run_converter() called at (eval 26) line 1
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] eval 'run_converter()' called at C:\Users\user.user.databricks\labs\remorph-transpilers\bladebridge\lib.venv\Lib\site-packages\databricks\labs\bladebridge\Converter\bin\Windows\dbxconv.exe line 365
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler]
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler]
08:43:33 DEBUG [d.l.l.t.lsp.lsp_engine] 08:43:33 ERROR [d.l.bladebridge.transpiler] Conversion failed

Expected Behavior

Conversion should be successful without any error

Steps To Reproduce

1. Make config changes to comment some of the Teradata commands like BT, ET etc.

2. Added this regular expression to handle some patterns in line_subst & removed all comments.
   {
   "from": "(?i)Save_Env_Var",
   "to": "-- Save environment variable using Databricks widgets or Python variables"
   },
   {
   "from": "(?i)Create_Timestamped_File",
   "to": "-- Create timestamped file in Databricks (manual handling required)"
   },
   {
   "from": "(?i)(\w+)\s*=\s*date\\s*\\+\"%Y%m%d%H%M%S\"",
   "to": "SET $1 = date_format(current_timestamp(), 'yyyyMMddHHmmss')"
   },

3. Run the transipler after making changes in base file.

lsp-server.log

Relevant log output or Exception details

Logs Confirmation

• I ran the command line with --debug
• I have attached the lsp-server.log under USER_HOME/.databricks/labs/remorph-transpilers/<converter_name>/lib/lsp-server.log

Sample Query

Operating System

Windows

Version

latest via Databricks CLI

[simone-dbx-labs]

@PaataTa could you help with this please?

[PaataTa]

@soumyadhasharath can we get on call ? I need source file and actual config, failing pattern does not seem to be in patterns added here :
{
"from": "(?i)Save_Env_Var",
"to": "-- Save environment variable using Databricks widgets or Python variables"
},
{
"from": "(?i)Create_Timestamped_File",
"to": "-- Create timestamped file in Databricks (manual handling required)"
},
{
"from": "(?i)(\w+)\s*=\sdate\s\+"%Y%m%d%H%M%S"",
"to": "SET $1 = date_format(current_timestamp(), 'yyyyMMddHHmmss')"
},

[soumyadhasharath]

Hi, Sure we can get on the call, please let me know suitable slots.

PFA for input files used, and configs.

Please note: After adding the new patterns was getting json format error, hence removed all comments from base_teradata2databricks_sql.json, final_master_dbx_sql_scripting.json, general_sql_specs.json

Config.zip

Sample.zip

[PaataTa]

@soumyadhasharath I am available all day today , I am in Dubai time zone.

[soumyadhasharath]

@PaataTa - thank you for letting me know, can we connect at 4.30pm IST with this Zoom link. Kindly confirm.
Topic: Lakebridge- bug ID 2228
Time: Jan 16, 2026 04:30 PM Mumbai, Kolkata, New Delhi
Join Zoom Meeting
https://us04web.zoom.us/j/73088201321?pwd=ghq1wLCV8TVyxLVutwWZ3TgKbkwwaZ.1

Meeting ID: 730 8820 1321
Passcode: GBR6iJ

[PaataTa]

@soumyadhasharath Thank You, will join at 4:30.