All Questions
Tagged with snowflake-cloud-data-platform odbc
109
questions
0
votes
0
answers
34
views
Snowflake ODBC SSIS SSL CHECK
I am currently working with the Snowflake ODBC driver, to connect Snowflake and SSIS and I need to bypass SSL verification for testing purposes. Is there a way to configure the driver to disable SSL ...
1
vote
0
answers
70
views
Snowflake ODBC xdg-open Missing X server or $DISPLAY
I've asked this question from Posit Community but did not get any answer so far:
https://forum.posit.co/t/snowflake-odbc-connection-xdg-open-missing-x-server-or-display/184074
I'm following up this ...
- 309
1
vote
0
answers
319
views
Connect SSIS To Snowflake via ODBC
Our organization is making the migration from SQL Server to Snowflake, and we are now charged with identifying whether or not we should continue with SSIS for our automated processes OR if we should ...
0
votes
0
answers
54
views
PHP Version for latest Snowflake ODBC version (3.2.0)
Currently, I am using Snowflake ODBC version 2.23.0, and as of February 1, 2024, the latest minimum supported version is 2.24.5. I intend to upgrade, but before doing so, I would like to know the PHP ...
- 674
0
votes
0
answers
53
views
R: Error when attempting to upload a data frame into SnowFlake table
I have a data frame DF in R whose rows I want to append and insert into an existing table in a SnowFlake database. I've established the connection through ODBC:
con <- dbConnect(odbc::odbc(), &...
- 668
1
vote
1
answer
262
views
Snowflake ODBC driver installation Alpine Linux
I have written the following Dockerfile which installs and configures ODBC drivers as described by the Snowflake docs: https://docs.snowflake.com/en/developer-guide/odbc/odbc-linux
FROM ruby:3.1.4-...
- 1,117
0
votes
0
answers
202
views
Connect External Data into Snowflake with ODBC Driver
I and my coworkers have recently started moving into Snowflake and have lots of datasources that connect through ODBC. We have gone through the documentation for Snowflake's ODBC driver, however we ...
- 153
0
votes
1
answer
29
views
Update Snowflake View using MS Access DB
Is it possible to update a Snowflake view using MS Access DB?
- 35
1
vote
0
answers
128
views
Connecting to Snowflake ODBC via Linked SQL Server
We're currently running SQL Server 2014. We need to ingest data from Snowflake.
Our goal is to fetch data/run queries using a linked server.
Here's the kicker - It needs to authenticate using Browser ...
- 317
0
votes
1
answer
233
views
Snowflake ODBC connectivity setup for SSAS tabular
I am trying to use the ODBC driver supplied by Snowflake to create a connection within SSAS (Microsoft SQL Server Analysis Services) Tabular. The ODBC connection checks out ok, even processing a ...
- 1
1
vote
2
answers
724
views
Getting a SQL compilation error "Compilation memory exhausted." when trying to push an R data frame to Snowflake
I'm using dbWriteTable to create a database table in Snowflake from R. This works nicely when I push a data frame of 350,000 rows, but fails with SQL compilation error: Compilation memory exhausted. ...
- 11
0
votes
1
answer
313
views
SSIS Import/Export Wizard ODBC/Snowflake timeout
We are using SQL Server 2014 (running the 12.6444 latest Service Pack/CU), and trying to import data using the SSIS import/export wizard from Snowflake, using an ODBC connection, using the latest ODBC ...
- 317
0
votes
0
answers
236
views
Data fetching from snowflake using laravel +ODBC connection showing error
I am connecting the snowflake database using Laravel. But while fetching data from table showing the below error. I am storing json content in the table using the datatype VARIANT
SQLSTATE[SL009]: <...
- 1,666
0
votes
1
answer
75
views
Prevent SSRS from opening multple authentication windows
Setup SSRS 2017
32bit ODBC driver for Snowflake
I am able to connect and retrieve my data but, the drive must be set to Authenticator: externalbrowser. This is annoying because it pops up a window for ...
- 1,701
0
votes
1
answer
406
views
Azure Data Factory Snowflake ODDBC connection - Cannot create pipeline to run script
I'm trying to run a script on Snowflake from Azure Data Factory.
This is so we can use elevated rights to run these script and we can use the scheduling capabilities of ADF to run it on weekly basis. ...
- 317