- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2022 02:58 PM
Hi,
There's a way to make work the Simba ODBC Driver for M1 Macbook Pros?
I find myself able to run on an old intel version of Macbook easily, but now every time I even test the connection with the iODBC Manager fails.
Definitely, the issue is around not being built for ARM, did anyone find a solution or there's going to be shortly a release with ARM support?
Thanks in advance!
- Labels:
-
ARM
-
M1 Macbookpro
-
Simba
-
Simba ODBC Driver
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 09:19 AM
@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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2022 02:19 AM
Hello @Nicolino Oppes Currently we don't have the odbc for M1 chip and our engineering team is working on this. May be end of Q3 we can expect the release.
We apologize for the inconvenience caused.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 09:19 AM
@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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2022 11:49 AM
Hey @Atanu Sarkar
Since we are near the end of Q3, are we expecting a release of ODBC server for M1?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2022 07:48 PM
Hi @Atanu Sarkar , hope you are doing well. May I know if the release of ODBC for M1 chip will be released or not? Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 09:07 AM
Hi Databricks Team and @Atanu Sarkar ,
Could I please kindly have an update on the Driver status? There's a deadline in place?
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 01:15 AM
Wanted to follow up here as well!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 07:24 AM
@MengdanLiu_ I see from internal note customer is using odbc for M1 . so it's supported now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 10:23 PM
I'm ~99% sure that ARM (and Apple Silicon Macs, by extension), are not yet supported. Went down many rabbit holes to attempt configuration of the Databricks ODBC driver and wasn't able to get it up and running.
The evidence suggesting a lack of support:
- The release notes of the Databricks Spark SQL drivers make no mention of it
- Similarly, the release notes indicate a new version hasn't been released since 2022-07-12, which predates the first reply to OP.
- In my Terminal, the command `file /Library/simba/spark/lib/libsparkodbc_sbu.dylib` shows compilation for `i386` and `x86_64`, but not `arm64e`.
- During my rabbit hole exploration to set up ODBC, I stumbled across blogs like this one, indicating the issue still exists and requires a rather massive lift to solve for when using with R & RStudio.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2023 07:01 AM
I have installed to my M1 chip Mac on Friday,.
I will be doing a couple of testing. and share the update.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 01:12 AM
Have good news to report on this end:
- A new version of the ODBC driver was released on 2023-09-08 (I spoke with a Databricks engineer the day prior about this)
- The latest version of the driver is indeed compiled for arm64 and supports Apple Silicon natively
- Still working to get things set up but there was at least progress on this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2023 02:24 PM
Things seem to be mostly working for me now. I've added a bit more detail on my connection steps and process in case it's helpful for anyone on Stack Overflow: https://stackoverflow.com/questions/76407426/connecting-rstudio-desktop-to-databricks-community-edit...