"ingestionConfig": { "transformConfigs": [{ "columnName": "visits_case", "transformFunction": "Groovy((CASE WHEN visits = 1 and (first_tab = 'true' or first_tab = 'null') then 1 else 0 end), visits_case)" } }

Syntax looks incorrect. Curly brackets are needed for function: https://docs.pinot.apache.org/developers/advanced/ingestion-level-transformations#column-transformation

U mean in transformation function, shall I pass both visits and first_tab as well ?

Is first tab one of the Pinot columns? Is yes, then yes you need to pass both

The syntax is still incorrect, look at the doc I sent

"ingestionConfig": { "transformConfigs": [{ "columnName": "visits_case", "transformFunction": "Groovy({(CASE WHEN visits = 1 and (first_tab = 'true' or first_tab = 'null') then 1 else 0 end)}, visits, first_tab)" }, { "columnName": "isbounce_case", "transformFunction": "Groovy({(case when isbounce = 'true' then 1 else 0 end)}, isbounce)" }, { "columnName": "isunique_case", "transformFunction": "Groovy({(case when isunique = 'true' then 1 else 0 end)}, isunique)" }, { "columnName": "isendandisbounce_case", "transformFunction": "Groovy({(case when isbounce = 'true' and eventnumber = 1 then 1 else 0 end)}, isend,isbounce)" }, { "columnName": "isend_case", "transformFunction": "Groovy({(case when isend = 'true' then 1 else 0 end)}, isend)" }, { "columnName": "eventnumber_case", "transformFunction": "Groovy({(case when eventnumber = 1 then 1 else 0 end)}, eventnumber)" }] },

awesome