Atanu
Databricks Employee
Databricks Employee

@Nicolino Oppes​ @Yatindra Athivarapu​ @Mengdan Liu​ 

ODBC doesn’t officially support ARM (M1) architecture. So that’s probably the root cause.However unofficially M1 rosetta emulation is capable of emulating ODBC Intel instruction on M1 and we have many scenarios that ODBC on M1 worked out of the box (Tableau with ODBC on M1 works through rosetta, etc).for short term workarounds:

  • either you can try using anything other than M1 if you have other VMs, machines.
  • the other option is you should play with rosetta emulation on M1 to see if there is a way to make this work (check here) this is unknown territory.
  • it seems this error is coming from excel not ODBC. so maybe you can search if for excel on mac there is any way to disable that additional validation which is failing

long term simba will officially add support for M1 to ODBC (that’s in their backlog, probably will be ready sometime in Q4 or so).

View solution in original post