Hi Team,
In 19.1 we can connect to the Snowflake database using the ODBC query component connection string. But in the latest version, we couldn’t find the snowflake driver listed in the drivers. (I have a snowflake driver installed on my machine).
@SushmaM16948715 To clarify, do you have Studio 19.1 and Studio 22.1 installed on the same machine? ODBC drivers are typically installed per machine, so I want to make sure you have the same drivers installed. Ideally, I would have 19 and 22 on the same machine for testing.
@SushmaM16948715 The issue might be the bit-ness of the driver. If you are running the 32-bit drivers, you will likely need to use the 64-bit version. I believe 22.1 runs with the operating system bit-ness whereas 19.1 would run 32-bit unless otherwise specified.
@ThomasSasnett I only have Studio 22.1 on my machine, I have uninstalled 19.1.
@SushmaM16948715 Do you have a 64-bit version of the driver to install?
@ThomasSasnett Yes, I have tested with 64-bit and it is working fine.