All Questions
Tagged with snowflake-stage or snowflake-cloud-data-platform
12,795 questions
1
vote
0
answers
37
views
Snowflake SPCS Multi Model Training - 403 Errors After some time
I am attempting to run a long running training job leveraging snowflakes distributed multi model training functionality. Using a sample of my training data (~100k rows) this process completes with no ...
- 167
0
votes
1
answer
28
views
Dbt throws error but table is created in snowflake
Something odd is happening in dbt. I'm following along to this video
https://youtu.be/OLXkGB7krGo?si=7NEL-hQaxslZQGd1
I'm sure I've configured the connection to snowflake correctly because the views ...
- 187
1
vote
1
answer
57
views
Find history access of intermediate views in Snowflake
I'm using the access_history view to find out what tables and views in snowflake where last touched.
problem is that if there is a view calling a view calling a table the middle vies would not appear ...
- 3,761
1
vote
1
answer
54
views
Using snowflakes externalbrowser authentification using VS Code remote tunnels
Executing this code while developing using a remote tunnel (Azure VM), the URL (token) seems not to redirect the token back to the snowflake client
Session.builder.configs(
{
"...
- 27.3k
1
vote
1
answer
153
views
SQL Query Resulting in Multiple Rows
The database I'm working in is Snowflake. I also have to work through an interface and can't edit the SQL query directly. I'm trying to add a JOIN to a FROM clause that is connecting two schemas with ...
- 31
-1
votes
0
answers
93
views
Calling stored procedure through task results in empty table if procedure contains cross-database join
I have a stored procedure in Snowflake that joins data from two different databases, in the following form:
CREATE OR REPLACE PROCEDURE database_1.schema_1.sp_test()
RETURNS varchar
AS
BEGIN
...
- 344
2
votes
4
answers
133
views
Grouping by and making flag based on patterns
I have a table p that looks like this:
ID
Col1
AAA
kddd
AAA
13bd
AAA
14cd
AAA
15cd
BBB
15cd
BBB
23fd
BBB
4rre
BBB
tr3e
CCC
kddd
CCC
12ed
DDD
rrr4
DDD
rtt4
DDD
rrt4
I have three lists of patterns that ...
- 2,379
0
votes
2
answers
89
views
How to capture delta records in Snowflake when a table is dropped and re-created every day?
I have a pipeline that drops and re-creates several Snowflake tables every day (effectively a full refresh using CREATE OR REPLACE TABLE). I want to capture daily deltas (inserts/updates/deletes) for ...
- 1
0
votes
1
answer
99
views
Snowflake Iceberg Immutable data getting rewritten (which violates snapshot level isolation guarantee)
There appears to be a bug in Snowflakes implementation Iceberg Tables which is evident if you try to capture change data. This seems to be a result of a more fundamental problem where a single parquet ...
0
votes
1
answer
122
views
How to give Snowflake NativeApp Permission to use SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY?
I am trying to build a snowflake nativeapp, and this is my first time trying to build one and my main objective is to get Query ID's Profile and Query/SQL Text of a Query ID that my app will get as an ...
user31671571
1
vote
1
answer
88
views
dbt post_hook executes before materialization if done in macro
If DDL stated directly in the post_hook it executes after the materialization as expected, but if it is moved to a macro it executes before the materialization.
This can be illustrated by this example:...
- 699
0
votes
1
answer
108
views
Connection state pristine
I am using node 18.11 and snowflake-sdk nodejs driver v 1.15.0. Getting the below error:
Snowflake Error SF: Error [ClientError]: Unable to perform operation because a connection was never ...
- 726
0
votes
0
answers
75
views
Can we get access history for an Inference Service in Snowflake?
I’m currently exploring Inference Services in Snowflake and wanted to check if there’s an equivalent to the Event History column in Databricks.
So far, the closest I’ve found in Snowflake are service ...
- 1
0
votes
1
answer
139
views
Snowflake - Python Connector - MFA - MacBook Finger Scan
I have a personal Snowflake account on my MacBook Air (Tahoe 26 M4). Snowflake is requiring MFA. I added a passkey with a "nickname", which I'm not entirely sure what that means. When I ...
0
votes
0
answers
39
views
Handling Schema Drift in Salesforce → Snowflake with Dynamic Mapping & CDC
We are ingesting data from Salesforce into Snowflake using Informatica. One of the challenges we’re facing is handling schema drift when Salesforce objects add or remove fields.
Our Requirements:
Need ...
5
votes
2
answers
108
views
Measure prescription adherence (date picking up a prescription <> date starting the prescription)
I have data that looks like this (in snowflake/SQL) (we will call the table RX):
Person ID
Rx Filled Date
Days Supply
1
January 1, 2025
10
1
January 8, 2025
10
1
January 15, 2025
10
1
January 30, 2025
...
-1
votes
2
answers
248
views
PowerApps-Snowflake Connector - Bad Gateway
Good day!
I am trying to create a PowerApp-Snowflake connector.
I followed the officials steps provided by Snowflake:
https://docs.snowflake.com/en/connectors/microsoft/powerapps/configure-oauth
...
- 13
0
votes
0
answers
59
views
How to change the name of the default app name in navigation in snowflake Streamlit?
When I created the streamlit app in snowflake, the default file is named streamlit_app.py. I am unable to change it. Because of it, when I tried creating a navigation link, the name is defaulted to &...
0
votes
0
answers
39
views
How to use snowflake cli in Jenkins CI pipeline?
I am trying to setup a CI pipeline to push my java application docker image to Snowflake image registry.
Since I have to use key-pair auth therefore I tried using Snowflake-cli.
I tried creating an ...
- 153
0
votes
0
answers
48
views
How can I extract email attachments in Matillion and store them in a Snowflake stage?
My goal is to:
Extract email attachments (for example: images, PDF, or CSV files).
Store those attachments into a Snowflake internal stage so that they can be processed later.
I was able to set up the ...
- 11
0
votes
1
answer
62
views
Is it possible to load csv file from local windows machine into TABLE STAGE in Snowflake?
Is it possible to load csv file from local windows machine into TABLE STAGE in Snowflake Snowsight ?
As I have done for Internal Named Stage and Unable to do it for TABLE STAGE ( @%) in UI/Snowsight
- 135
0
votes
1
answer
364
views
Python snowpark print()/.show() is not working
I tried to create snowpark program in snowsight.
There's already some code example showing when I add a sheet as following:
import snowflake.snowpark as snowpark
from snowflake.snowpark.functions ...
- 623
3
votes
1
answer
173
views
Unexpected behavior of FIRST_VALUE … IGNORE NULLS with different window frames on Snowflake
While experimenting with window functions in Snowflake, I stumbled upon a rather puzzling behavior of FIRST_VALUE in combination with IGNORE NULLS when using different window frame definitions.
...
- 457
2
votes
1
answer
118
views
SHOW PARAMETERS All level in single query
We can check parameters of SESSION/ACCOUNT/DATABASE level individually using SHOW command in Snowflake:
SHOW PARAMETERS IN ACCOUNT; —- shows parameters defined at the user level
SHOW PARAMETERS IN ...
- 135
0
votes
1
answer
114
views
Use bind variable directly in snowflake SQL worksheet
I wanted to try this SQL to use bind variables as input (not in a stored procedure or anonymous block), but it's throwing an error.
LET VARIABLE VARCHAR := 'RPT';
SELECT * FROM TABLE_NAME WHERE TYPE= :...
- 135