From Newsgroup: rec.sport.rowing

<div>If you are already using the ODBC driver and need to download an updated version, check the version that you are using, andreview the changes between your version and the updated version in the ODBC Driver release notes</div><div></div><div></div><div>To find the version of the driver that you are using, call the CURRENT_CLIENT SQL function froman application using the driver. You can also verify the driver version byexamining queries executed by the driver in the QUERY_HISTORY view.</div><div></div><div></div><div></div><div></div><div></div><div>how to download snowflake odbc driver</div><div></div><div>DOWNLOAD: https://t.co/I207sWIa7H </div><div></div><div></div><div>My Snowflake driver is installed to /opt/snowflake/snowflakeodbc, so that is correct -- I'm suspicious that this is specifically an M1 problem. I'm using the 2.24.1 version of the driver available from the download mirror here, and the path to the driver in /etc/odbcinst.ini is /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib (which exists and seems, from all my research, that it should be right).</div><div></div><div></div><div>You need to point the Snowflake driver towards the iODBC dylib (as per a sideswiping statement in the docs) -- the driver is originally configured to look for the ODBC dylib (not iODBC) in a folder that's on the path.</div><div></div><div></div><div>When you install the iODBC driver, verify that it is installed to /usr/local/iODBC (this was where my Silicon Mac installed it to) -- and that /usr/local/iODBC/lib has libiodbc.dylib in it. If so, navigate to your installed snowflake driver directory (should be /etc/snowflake) and alter the simba.snowflake.ini file (/etc/snowflake/snowflake/snowflakeodbc/universal/simba.snowflake.ini). You want to uncomment & alter the last line to be both uncommented & point with a full path towards the iODBC dylib (instead of the default, which is the ODBC dylib).</div><div></div><div></div><div>It seems like the core of the issue is that the odbc code is looking for arm64 architecture drivers but Snowflake is providing it in x86_64 architecture. By installing an x86_64 versions of odbc we are able to have it successfully talk to the driver.</div><div></div><div></div><div>Has anyone gotten this to work? I use excel w odbc to refresh snowflake files and have tried multiple ways to move the drivers etc and followed snowflake instructions but never works. I did get parallels to work running windows arm but would prefer to just do this in Mac OS</div><div></div><div></div><div>I also have a M1 (version Monterey 12.0) and I ran into similar issues when I tested the driver. Nevertheless, when I tried the "real connection" it worked like a charm. So, maybe it would be good for you to go and test the "real connection" to avoid a wasting of time using such testing. Hope you find this useful.</div><div></div><div></div><div>A big query might execute in less than a minute in Snowflake but then take hours to actually send over to our server, and I suspect that the limitation lies within the official ODBC driver itself. Our server itself has a gigabit fiber connection, and I've confirmed with my IT team that there is no speed throttling being applied at the firewall level.</div><div></div><div></div><div>I've looked around to see if there's some fetch size variable I can alter for the Snowflake ODBC driver to no avail. Doesn't seem like there is one. Has anyone here run into something like this before and found a solution? I'd be extremely grateful for any insight on this issue.</div><div></div><div></div><div></div><div></div><div></div><div></div><div>Recently I received a request to integrate a connection with an existing Rails application. After some research I came to the conclusion that one of the only ways to query the Snowflake views was through an ODBC connection using a combination of -odbc and</div><div></div><div></div><div>With this file updated with your Snowflake information you can now test the connection using the following command that is included with iODBC:</div><div></div><div>/Library/Application Support/iODBC/bin/iodbctest</div><div></div><div>This will allow you to enter an iODBC connection string for any of the DSNs listed using the ? command. This connection string should not be enclosed in quotes and should be in the following format:</div><div></div><div></div><div>Now, that was a lot of setup just to get to a prompt where you are able to query Snowflake. Now that you have all of that working you would expect to be able to install the ruby-odbc gem and start working in your Rails environment. When you go to install the ruby-odbc gem you will run into an error:</div><div></div><div></div><div>Our ODBC driver is a standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.</div><div></div><div></div><div>With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual Snowflake databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.</div><div></div><div></div><div>The CData ODBC drivers include powerful fully-integrated remote access capabilities that makes Snowflake data accessible from virtually anywhere. The drivers include the CData SQL Gateway, which can the optional ability to accept incoming SQL and MySQL client connections and service standard database requests.</div><div></div><div></div><div>With the CData SQL Gateway, users can interact with Snowflake data from any client that supports SQL Server or MySQL: from Web & mobile applications, to CRM and CMS systems, BI tools like SQL Server Analysis Services, and even through popular management applications like MySQL Workbench.Access Snowflake data from virtually any application that can access external data. Applications that can access SQL Server or MySQL data can now connect to Snowflake with this driver.</div><div></div><div></div><div>One quick follow up question - if I want to publish a rmd or shiny app from the server to Connect which utilizes Snowflake data - do I need to do the same set up(download drivers, unixODBC, configure files) that I did on the Rstudio Server Pro on the Rstudio Connect Server? Or is there a different set up for Connect than for Server Pro?</div><div></div><div></div><div>I know there are user specific analogues for odbc.ini (/.odbc.ini, maybe?), and there may be similar for odbcinst.ini (which points at driver .so files). It may be worth taking a look at those to see if they resolve your issue!!</div><div></div><div></div><div>This connector requires a driver to talk to the database. You might already have the required driver installed on your computer. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download(Link opens in a new window) page where you can find driver links and installation instructions.</div><div></div><div></div><div>Here is the result... Notice the size difference... DBMAX_TEXT= didn't help. It only works on BLOBs. I think this is a problem and am going to try to do something about it. Some ODBC drivers will let you limit the length of text strings. Unfortunately, the Snowflake ODBC driver doesn't appear to be one of these. I will ask them about it.</div><div></div><div></div><div>Next, open the configuration file (e.g. /opt/snowflake/snowflakeodbc/lib/simba.snowflake.ini) in the folder where you installed the Snowflake driver. You may need administrator privileges to edit the file.</div><div></div><div></div><div>Then add ODBCInstLib=/opt/homebrew/lib/libodbcinst.dylib to the end of the configuration file. (This path will vary depending on where you have installed homebrew, so please check the path of homebrew installed on your Mac.)</div><div></div><div></div><div>Locate DriverManagerEncoding at the top of the same configuration file (e.g. /opt/snowflake/snowflakeodbc/lib/simba.snowflake.ini). The default may be UTF-32, in which case change it to UTF-16 and save it as follows.</div><div></div><div></div><div>If the path /opt/snowflake/snowflakeodbc/lib/universal/cacert.pem is specified for the CABundle in your environment and this file path does not exist, specify an appropriate file path (for example, remove the universal part, If the path universal/cacert.pem is specified in the CABundle and this file path does not exist, you will need to specify the appropriate file path (for example, remove the universal part).</div><div></div><div></div><div>HVR requires that the Snowflake ODBC driver is installed on the machine from which HVR connects to Snowflake. For more information on downloading and installing Snowflake ODBC driver, see Snowflake Documentation.</div><div></div><div></div><div>After installing the Snowflake ODBC driver, configure the LogLevel configuration parameter as specified in ODBC Configuration and Connection Parameters of the Snowflake Documentation.</div><div></div><div></div><div>For a default installation, these files are available at /etc and do not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc.</div><div></div><div></div><div>HVR uses the Snowflake ODBC driver to write data to Snowflake during continuous Integrate and row-wise Refresh. However, the preferred methods for writing data to Snowflake are Integrate with /Burst and Bulk Refresh using staging as they provide better performance (see section 'Burst Integrate and Bulk Refresh' below).</div><div></div><div></div><div>As a pre-requirement, the Snowflake connector requires users to install the Snowflake ODBC driver in their machines, matching the architecture of the Power BI Desktop installation (i.e. 32-bit vs. 64-bit). The Snowflake ODBC driver can be downloaded from this location: =823762</div><div></div><div></div><div>When first searching for a way to connect to Snowflake from R I found a coupleof posts where it looked fairly easy to do exactly that.One was from Martin Stingl on his rstats-tips blog(highly recommended). And I also found a post on community.snowflake.comtitled How To Connect Snowflake with R/RStudio using ODBC driver on Windows/MacOS/Linux.This too easy how to article consisted of 2 steps:</div><div></div><div></div><div>Currently there are 4 open issues in the r-dbi/odbc repository dealing with what I assumeis the same issue. Just 2 days ago Sharon Wang has created a PR that addresses this as well (thanks a lot ?).</div><div></div><div> 9738318194</div>
--- Synchronet 3.21a-Linux NewsLink 1.2