CONNECT Engine - ODBC: Too long value for SRCDEF

DROP TABLE IF EXISTS scada_data_processing.`t1_temp_aux_eo_ots_with_consumption_subset_population`;

CREATE TABLE scada_data_processing.`t1_temp_aux_eo_ots_with_consumption_subset_population` 

(

  `NumOT` varchar(36) NOT NULL,

  `OT_With_Consumption` BOOLEAN

) ENGINE=CONNECT

  TABLE_TYPE=ODBC

  CONNECTION="exp_operativa"  

  OPTION_LIST="UseDSN=Yes,User=************,Password=************"

  SRCDEF =

  "

    SELECT

      A.[NumOT] AS NumOT,

      CASE

        WHEN

          count(CASE WHEN B.[NumOT] IS NOT NULL THEN 1 ELSE 0 END) >=1

        THEN

          1

        ELSE

          0

      END AS OT_With_Consumption

    FROM

      exp_operativa.GPA99.T_OTS AS A

      LEFT JOIN exp_operativa.GPA99.T_MOVEMENTS AS B

        ON A.[NumOT] = B.[NumOT]

    WHERE

      [NumOT] IN ('401591205', '401761515', '401761682', '401761698', '401761721', '401762159', '401774167', '401774169', '401774171', '401774179', '401774182', '401774186', '401774193', ..., '501032891');

      AND B.[Enabled] = 1

    GROUP BY

      A.[NumOT]

  ";