All Questions
Tagged with snowflake-cloud-data-platform database
231
questions
0
votes
0
answers
41
views
Converting basic update logic from a table to a view in Snowflake
I'm working on converting something that's currently in a table in snowflake into a view. One of the big issues I've run into is that the code I was provided to build the table uses the SQL UPDATE ...
0
votes
1
answer
39
views
how to test if row values in source when taken as columns in target
I have a source table like below,
ID
Column
value
1
apple
10
1
apple
8
1
banana
9
1
banana
12
I have a target table like below,
ID
apple
banana
1
10
9
1
8
12
How do I test/verify this using ...
0
votes
1
answer
89
views
Snowflake error : Numeric value '(501.00)' is not recognized
I have a large dataset, about 600 columns. There is a lot of casting happening to get things formatted properly. I am currently getting an error like this:
Numeric value '(501.00)' is not recognized.
...
0
votes
0
answers
35
views
How Do I get Only latest data processed in my sql table
Scenario:
The table contains data inserted over a 7-day window where data from the 11th to the 17th of each month is inserted daily. Sometimes, overlapping data is inserted, and the challenge is to ...
0
votes
1
answer
61
views
Select a combination of distinct column in Snowflake/SQL
I have a table like this:
Col1
Col2
Col3
col4
1
a
e
x
2
b
e
x
3
c
f
y
4
d
f
y
col3 and col4 have duplicates. So I need to select col1, col2 and distinct col3, col4 from the table. All 4 columns ...
0
votes
1
answer
163
views
Snowflake `Table`s vs Snowflake `DataFrame`s in Snowpark
Two things I've come across while trying to learn Snowflake Snowpark is that they mention both Tables and DataFrames.
The docs say that you can load an existing table from Snowflake database after ...
0
votes
1
answer
257
views
Loading table from snowflake dwh into postgreSQL db directly
I'm trying to write a few python scripts that will take tables I have in snowflake and transfer them to a postgreSQL db. I have to convert each row in my snowflake tables into json strings so in ...
0
votes
1
answer
144
views
Title: Snowflake DBT: "Numeric value not recognized" error in join
I'm encountering a pesky error in Snowflake regarding "numeric value not recognized" within a dbt model:
with cte as (
select
field1,
field2,
agg_function()
...
0
votes
2
answers
211
views
Separation of Storage & Compute in Snowflake [closed]
One of the key features in Snowflake is the separation of storage and compute.
While I do understand what it means, I realized that I actually don't really grasp what is so special about this. More ...
0
votes
1
answer
180
views
How to get COUNT result from the snowflake stored procedure?
Here is my stored procedure:
CREATE OR REPLACE PROCEDURE TCT_WEBAPP.DBO.COUNT_FILTERED_PROVIDERS(
"TIER" VARCHAR(20),
"CITY" VARCHAR(20),
"TYPE" VARCHAR(20),...
0
votes
1
answer
65
views
Snowflake SQL apply function once per partition
In Snowflake, we can perform a window function like this:
array_agg(a) over (partition by b) as c
Since my partitions are large (big data), and my f is expensive, I need to make f(c) evaluate only ...
0
votes
0
answers
66
views
Upload Geotiff or Shapefile to Snowflake through streamlit
I am uploading a geotiff file from my streamlit app using st.file_uploader. How to upload this file to snowflake DB. Is it possible to do so? for now its geotiff but file type can be shape file also.
...
0
votes
2
answers
939
views
Snowflake Bulk Inserts vs. Single Row Inserts
I'm a bit confused about the definition of single-row inserts vs. bulk inserts in Snowflake.
I want to understand what is happening under the hood when executing insert statements in Snowflake, ...
0
votes
2
answers
58
views
select 70 records for each unique value in specific column in snowflake table
I am trying to select 70 records (rows) from a table for each unique value in another column. If I have 30 unique values in column SPORT then I would get 30 * 70 = 2100 records in the resultant table.
...
1
vote
1
answer
220
views
How to manually refresh a Snowflake Marketplace listing?
I have a data listing in the Snowflake Marketplace being Auto-Fulfilled to other regions. Currently, my listing is set to refresh on a weekly basis. But sometimes I need to do a refresh in the middle ...