Stack Overflow
Stack Overflow

Questions tagged [snowflake-connector]

177 questions
8
votes
1 answer

snowflake.connector SQL compilation error invalid identifier from pandas dataframe

I'm trying to ingest a df I created from a json response into an existing table (the table is currently empty because I can't seem to get this to work) The df looks something like the below…
KristiLuna
  • 1,601
  • 2
  • 18
  • 52
7
votes
2 answers

Reduce size of snowflake-connector-python[pandas] module

I am trying to create a lambda function in AWS which connects to a Snowflake database. For this I need the snowflake-connector-python[pandas] package (https://docs.snowflake.com/en/user-guide/python-connector-pandas.html), which together with all of…
user2974951
  • 9,535
  • 1
  • 17
  • 24
7
votes
1 answer

MWAA Airflow 2.2.2 'DAG' object has no attribute 'update_relative'

So I was upgrading DAGs from airflow version 1.12.15 to 2.2.2 and DOWNGRADING python from 3.8 to 3.7 (since MWAA doesn't support python 3.8). The DAG is working fine on the previous setup but shows this error on the MWAA setup: Broken DAG:…
Salahddin-Warid
  • 105
  • 1
  • 1
  • 5
5
votes
1 answer

Lambda Docker Image Not Running

I've had an absolute terrible time trying to get the Snowflake python connector to install. That is a side frustration in this, but i've finally managed to get it to install by using a full Ubuntu base Docker image. I cannot figure out how to make…
pyFiddler
  • 301
  • 3
  • 11
4
votes
1 answer

net.snowflake.client.jdbc.SnowflakeChunkDownloader : Timeout waiting for the download of #chunk0

Getting timeout waiting for download of chunk error. Snowflake JDBC driver version: 3.13.18 error encountered: *net.snowflake.client.jdbc.SnowflakeSQLException*: JDBC driver internal error: Timeout waiting for the download of #chunk0(Total chunks:…
Haider Millwala
  • 41
  • 1
  • 2
3
votes
3 answers

If exists (select top 1 1 from table) in Snowflake

How to write the T-SQL below in SnowFlake if exists (select top 1 1 from tableName) This returns true or false Update I tried to run the if in the screenshot below in the Snowflake browser, but get the…
Pingpong
  • 7,681
  • 21
  • 83
  • 209
3
votes
1 answer

Snowfalke sql update if exists else insert

I have looked at other question but seems that snowflake doesn't support if/else in sql, at least not the way that other sql servers support it. some suggested to use javascript but i would like to avoid that if I can. I am trying to Insert into a…
The Y.c
  • 113
  • 1
  • 8
3
votes
0 answers

CryptographyDeprecationWarning with snowflake.connector.connect

When I run snowflake.connector.connect(**credentials['MY_DATABASE']), I get the following warning: ~/opt/anaconda3/lib/python3.8/site-packages/cryptography/hazmat/backends/openssl/x509.py:14: CryptographyDeprecationWarning: This version of…
Sahar
  • 741
  • 1
  • 8
  • 14
3
votes
1 answer

Using merge in python snowflake connector with pandas dataframe as a source

I'm retrieving data from an API and converting the data into a pandas dataframe. I'm using python-snowflake connector to send this data into my snowflake schema as a table. I want to use merge instead of sending the duplicate data into my snowflake…
R0bert
  • 507
  • 6
  • 30
3
votes
0 answers

Is it possible to re-use a session between SnowflakeOperator's?

I have a DAG where I want to have multiple separate SnowflakeOperator's use the same snowflake SESSION. The reason being, I want them all to use the same TEMPORARY table's. Unfortunately, even when using the same airflow snowflake connection, usage…
Callum Lamb
  • 31
  • 1
  • 2
3
votes
1 answer

Using data build tool(dbt) and snowflake, how can I check if a column is a date field?

I'm a Junior so apologies if my explanation isn't that great. I've created a macro on dbt to add a default row with defined values or default values based on data type. What I'm trying to achieve is to check if the column is a datatype date field,…
Lewis Brogan
  • 68
  • 5
3
votes
2 answers

Query keeps running on Snowflake even after it has been terminated in SAS app

We have SAS application that connects to snowflake via ODBC 2.23.0. Whenever a user abort query from SAS it keeps on running on Snowflake. We have tried setting ABORT_DETACHED_QUERY= TRUE at user level, but the query is not aborted after 5 mins.…
rohit singh
  • 31
  • 2
3
votes
2 answers

How to connect SQLAlchemy to Snowflake database using OAuth2?

I need to connect to Snowflake using SQLAlchemy but the trick is, I need to authenticate using OAuth2. Snowflake documentation only describes connecting using username and password and this cannot be used in the solution I'm building. I can…
minder
  • 2,059
  • 5
  • 24
  • 39
3
votes
0 answers

Invalid consent request during to get the oauth token from the Snowflake

I created an integration in the Snowflake and got a client id and when I tried to get an oauth token it is giving me an error stated that "Invalid consent request." but my username and password is correct. Please suggest me what can I do?
Dushy
  • 31
  • 1
2
votes
0 answers

How to embed snowflake data visualization in my react page?

I want to display snowflake data in visualization format in my react page. I am able to create a sample data in snowflake and visualize within snowflake but i want to embed this visualization in my react page, how to achieve this? i don't see any…
Stella
  • 1,728
  • 5
  • 41
  • 95
1
2 3
…
11 12