Questions tagged [snowflake-cloud-data-platform]
Snowflake Cloud Data Platform has a multi-cluster, shared architecture that provides a single location for structured and semi-structured data that can be queried using ANSI SQL. Snowflake is a cloud-agnostic platform with very large scale that supports many different workloads: data warehousing and analytics, data lake, data engineering, secure data sharing, data applications, and data science.
snowflake-cloud-data-platform
12,255
questions
0
votes
1
answer
33
views
Python logger in a Snowpark Stored Procedure?
I'm trying to add a Python logger to my Snowpark Python stored procedure.
The documentation says that I must create an Event Table, and that Event Tables must be associated with an account, and that ...
0
votes
1
answer
84
views
250001: Could not connect to Snowflake backend after 2 attempt(s).Aborting
I am trying to connect to snowflake using sql database and snowflake url but I am getting "Could not connect error".
This is the code that I am using:
from langchain import OpenAI, ...
0
votes
0
answers
33
views
GitHub Actions-Snowflake connection now working
I am running below workflow in GitHub Actions:
name: ohfa
# Triggers the action based on branch and path.
on:
push:
branches:
- main
paths:
- 'dbscripts/**'
...
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 ...
-1
votes
0
answers
16
views
Load data into snowflake using informatica power center
Is it possible to load data from oracle database to snowflake using informatica on premise powercenter
ETL tool?
I tried using Informatica cloud but wanted to try using informatica power center ,can ...
0
votes
2
answers
51
views
DBT Duplicate row detected during DML action - Snowflake
Creating an incremental model using the MERGE strategy with a unique key. The unique key to merge on is a surrogate key of columns from the table.
When I run this incremental model I get the error: ...
0
votes
0
answers
19
views
Snowpark Procedure Async SQL Execution
I am trying to run a stored procedure in Snowflake written in Snowpark.
Wherein based on a list of tables I am running some SQL for each table.
I am trying to use the async feature to make the sql's ...
0
votes
1
answer
17
views
How to fetch and view query profile from query_id in Snowflake?
Hi Snowflake Experts/Developers/Data Engineers, I want to view the query profile of a query_id.
Is it possible to view query profile from query_id?
If so how?
If its not possible:
is it possible to ...
0
votes
0
answers
33
views
Kafka Connect to Snowflake connection via JDBC error
I've been trying to send data from Kafka to Snowflake using the JDBC driver with Kafka Connect.
Some details about the environment:
Kafka is running in a Cloudera private cluster (Base 7.1.9).
The ...
0
votes
1
answer
61
views
Connect to Snowflake using Azure Data Factory
I am trying to move data from ADLS Gen2 into Snowflake using ADF.
The linked service connection is getting timed out with the below error-
I have entered the warehouse, database , username, password ...
0
votes
0
answers
35
views
Snowflake Notebook- how to achieve parallelism?
As i know that when executing snowflake notebook through its scheduler, it execute each cell one by one as sequential model.
however i want to paralyze the process where all cell - suppose i have 3 ...
0
votes
1
answer
29
views
Sharing data across virtual environments in Python
I am trying to consolidate data from several different sources into a Tableau .hyper file using Pantab. One of my sources is Snowflake. The problem is that Pantab and Snowflake require non-...
1
vote
1
answer
31
views
Snowflake Native app with container service, grant imported privilege on Snowflake DB
How can a snowflake native application built with container services request or grant imported privilege on Snowflake DB?
According to Snowflake Documentation, the grant can only be added through SQL ...
1
vote
1
answer
25
views
SELECT doing different operations on multiple columns with structured data
I’m working with a Snowflake table where each row contains structured data in two columns. Here’s an example of the table with 3 rows:
| id | data_1 | data_2 |
|----------------...
0
votes
0
answers
39
views
Session.sql() missing 1 required positional argument: 'query' : Snowflake
I have an error with this code:
# The Snowpark package is required for Python Worksheets.
# You can add more packages by selecting them using the Packages control and then importing them.
import ...