All Questions
Tagged with snowflake-cloud-data-platform python-3.x
171
questions
0
votes
0
answers
11
views
Snowflake Notebook- How to run notebook parllalley
I am trying to run snowflake notebook paralley using python concurrent process- ThreadPoolExecutor
However the execution failing
from concurrent.futures import ThreadPoolExecutor, as_completed
from ...
0
votes
0
answers
52
views
Snowflake query issue with hung state
I have an engine that runs multiple queries on snowflake (ETL). Sometimes one of the queries get hung and takes so long to run. But when I check at snowflake, the query is already complete.
Can ...
1
vote
0
answers
55
views
Snowflake Python Connector: EOF issue when send queries to run
So i have this type of sql script inside my file "file.sql"
USE SCHEMA "CCM";
-- create table and insert a single row
DECLARE
l_QUERY VARCHAR(8000);
BEGIN
-- Create table ...
- 11
0
votes
1
answer
237
views
Snowflake Python worksheet requests data from url
I'm working with a Python Worksheet and trying to download CSV data from an external URL using the requests library. However, I'm encountering a NameResolutionError that seems to indicate a DNS ...
- 115
0
votes
0
answers
63
views
How can I access snowflake from AWS glue?
In AWS glue, I am doing certain operations for which I need to access data tables in snowflake. I understand that I can use a whl for snowflake python connector. However, that method installs the ...
1
vote
0
answers
105
views
Returning data from a UDF to Snowflake in a Snowflake Native App
I have a python udf that performs a http request and stores the output in a list and returns this output to snowflake. The http request returns a name for every value sent by it. Here is the code ...
- 642
0
votes
1
answer
186
views
Unable to import Snowflake Connector python library after install in Azure Devops YAML Pipeline
Please help me to resolve this issue.
snowflake.connector is unable to import after it is successfully installed in Azure Pipeline.
Error::
Installing collected packages: sortedcontainers, pytz, ...
- 7
0
votes
0
answers
146
views
Pinecone query not bringing up any matches?
Here is what I have done - Converted a Snowflake schema into vectors and uploaded them to a Pinecone vector DB.
However when I try to run a query against the Pinecone DB, it does not bring up any ...
0
votes
0
answers
199
views
Error Connecting to Snowflake after switching to Key-Pair authentication
I have multiple pipelines running on Airflow and these pipelines dump data to Snowflake.
When I used basic authentication(username and password), I didn't get any error. However, when I switched to ...
- 1,238
1
vote
1
answer
41
views
pandas.DataFrame.to_sql intermittently loading data partially to snowflake/database
Intermittently it happens that pandas.DataFrame.to_sql partially loads data into snowflake.
Example: DF has 25000 rows, buy the function loads only 15000 to snowflake.
Has anyone faced this issue and ...
- 11
0
votes
0
answers
134
views
Reusing snowflake connection object in multiple python scripts
I'm using
conn = snowflake.connector.connect(user='user',password=password,account='account',warehouse='warehouse',database='db')
for the snowflake connection in every single python script to execute ...
- 23
1
vote
3
answers
520
views
Error while installing snowflake-connector-python in windows python 3.12.0
I have been trying to install Snowflake connector python with the command
pip install snowflake-connector-python
on Windows OS and getting the following error. Python version 3.12.0
LINK : fatal ...
1
vote
1
answer
3k
views
Use Snowflake Connector on Python 3.12
I have just switched from Python version 3.11.6 to 3.12.0
Previously it was possible for me to run the following script (I installed snowflake-python-connector):
import snowflake
# Connection to ...
- 15
0
votes
1
answer
321
views
rlike not working for a snowpark dataframe
I am trying to fetch records having the string 'o' in a dataframe column but no records are showing up.
Currently in column 'Variant_nm' in dataframe I have
Junk_df1=df.filter(col('Variant_Nm')=='...
- 21
0
votes
1
answer
833
views
Save Snowpark DataFrame as text file in Snowflake Stage
My requirement is to take tabular data in Snowflake and save it as a csv file to Snowflake External Stage, where data has header and footer.
Is this doable using Snowpark(Python)?
Result should look ...
- 131