CODEWITHSUNDEEP
odbcsnowflake-cloud-data-platformtableau-desktop
cs0815
cs0815

Reputation: 17418

connect to snowflake via odbc driver on mac m1

According to this, if I read this correctly, Tableau desktop on a Mac M1 cannot use the snowflake ODBC driver. Is this still true? Generally, my ODBC driver for snowflake works.

enter image description here

PS:

@aek I still get:

enter image description here

in Tableau. I installed:

2.25.3 snowflake_odbc_mac-2.25.3.dmg mac64

and configured odbc.ini files and everything appears to work fine in:

enter image description here

If I run (as suggested here):

"/Library/Application Support/iODBC/bin/iodbctest"

I get:

1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib, 0x0006): tried: '/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib' (fat file, but missing compatible architecture (have 'i386,x86_64', need 'arm64')) (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003

Is there anything I can/have to do that Tableau recognised the driver?

Upvotes: 0

Views: 1648

Answers (1)

Alexander Klimenko
Alexander Klimenko

Reputation: 1695

Yes, this is still true (for v. 2022.3). According to the spec, Tableau Desktop still works in emulation mode. The application and driver must have the same architecture. So for Tableau Desktop, you need to use the Mac64 version of the driver, as the article suggests.

Edit: How to make it working. The native Snowflake connector in Tableau will try to use the "OS architecture appropriate" driver. Which is not the case for an x64 app running on ARM. Therefore, when configuring the connection, instead of choosing Snowflake from the list, you should use Other Databases (ODBC) and select the Snowflake DSN configured with the Mac64 version of the driver accordingly to the doc.

Upvotes: 2

Related Questions