12,225 questions
0
votes
1
answer
27
views
Snowflake - Paginated Reports?
I have used PROC REPORT in SAS in a prior life. I am now using Snowflake. Is there any way to create Excel/PDF reports using Snowflake, comparable to PROC REPORT?
Thanks for any insight.
-2
votes
1
answer
51
views
Using UK Postcode Regex formula in SQL WHERE Statement [closed]
I'm looking to write an SQL rule for UK postcodes that check that Postcode data is legit. I know this is the official UK Postcode regex code, but how do I put this into a WHERE statement.
What I need ...
- 11
0
votes
0
answers
14
views
Snowflake Snowpark: Creating a column using lead and then removing rows results in NULL values
I am adding a columnn to a DataFrame using .with_column() and the .lead() from the snowpark functions library. After that I am conditionally removing rows using the .filter() function. The rows before ...
- 1
0
votes
1
answer
29
views
snowflake ARRAY_AGG, replacing empty [] array by null
I am using this function ARRAY_AGG in snowflake sql.
It is giving me [] empty array many times as I have null values there. It is only giving it when i am using case when inside.
how can i get just a ...
- 380
-2
votes
0
answers
21
views
Stored procedure: loading most recent file from stage
Embarrassed to admit I have spent 8 hours trying to get this to work and I am clear out of ideas. Hoping some discussion could help me see things differently.
I have defined s3 staged location
CREATE ...
- 188
0
votes
1
answer
26
views
SSAS Cube Transition to Snowflake
I'm trying to find a solution for migrating from an Azure environment to Snowflake. We have several SSAS cubes that need to be replicated in Snowflake, but since Snowflake doesn't natively support ...
0
votes
0
answers
25
views
Snowflake - dynamic table recommendation
I have a dynamic table that is created with a CTE like this:
CREATE DYNAMIC TABLE final_tab_v1
TARGET_LAG = '5 minutes'
AS
With tab_1 as (select fields from db.schema.table_1)
,tab_2 as (select fields ...
- 108
0
votes
0
answers
41
views
How to calculate time differences with incremental batch loading in dbt?
I'm working on a dbt model (shared below) that calculates the time difference in days between integration time and the previous wake-up time for each device. This is done by using the LEAD() window ...
- 521
0
votes
1
answer
33
views
How to turn off excessive debug log noise from Snowflake.Data nuget package in my .NET framework?
I use Snowflake.Data nuget package in my .NET 4.7.2 project. All the debug logs in the decompiled Snowflake.Data library (v4.3.0) are appearing in my application log which is too much. My application ...
- 181
1
vote
2
answers
51
views
Snowflake invalid identifier
I try to convert from SQL to SNOWFLAKE:
SET pfd = CAST(CURRENT_TIMESTAMP AS DATETIME);
SET psd = CAST(DATEADD(DAY, -30, CURRENT_TIMESTAMP) AS date);
DECLARE curr_date DATETIME;
BEGIN
...
- 13
0
votes
1
answer
25
views
Snowplow Community AWS quickstart: Snowflake loader shows "azure" in url
I cannot figure out why when using the AWS Quickstart the sp-sf-loader-server points to an incorrect url.
In the CloudWatch logs I see this error occurring every minute.
Caused by: javax.net.ssl....
- 53
-2
votes
0
answers
35
views
I want to create a task which will be calling a procedure and the procedure will be calling a scala file on snowflake [closed]
I want to make a Snowflake task which will call a procedure and the procedure will be calling the Scala file. Please refer the below diagram:
+--------------------+
| Snowflake Task |
|------------...
1
vote
1
answer
30
views
Error when running NEXTVAL on sequence inside stored procedure
I have a snowflake procedure in which I would like to capture the next value from a sequence and do something with it. Here is a simplified example of such a sequence and proc:
use schema TEST_DB....
- 4,767
0
votes
2
answers
39
views
How to convert last_modified output from LIST into a timestamp?
What is the best way to get a timestamp from the output of the LIST command in Snowflake?
Here are some example timestamp outputs from executing LIST on a stage:
Mon, 17 Mar 2025 05:00:46 GMT
Tue, 4 ...
- 15
0
votes
0
answers
34
views
Snowflake Streamlit CI CD
Currently having 2 Streamlit apps created using the integrated Streamlit in Snowflake, the actual script for creating the 2 apps is already done via CI/CD pipeline and it works great. My question ...
- 68