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
11,736
questions
0
votes
0
answers
8
views
Snowflake python worksheet with package from stage (Office365-REST-Python-Client)
I know very similar questions have been asked, but all attempts to import this non-Anaconda package into a Snowflake Python worksheet give the error "ModuleNotFoundError: No module named..."....
- 115
0
votes
0
answers
13
views
How to use stream with a source view in DBT
Currently, I have a DBT project for Snowflake which uses streams, views, tasks and procedures, every time the project runs my views are re-created and the streams that use those views stop working, ...
0
votes
0
answers
19
views
Snowflake Invalid Grant
I am getting below response when I try to get Access Token with Grant Type Client Credentials
{
"data" : null,
"error" : "invalid_grant",
"code" : null,
&...
- 1,610
0
votes
0
answers
21
views
Snowflake Managed Iceberg Tables - Single External Volume or Multiple [closed]
My employer is currently interested in the functionality of Snowflake Managed Iceberg tables.
The question that I have in regard to this is the following example:
3 data sources from 3 different ...
-1
votes
0
answers
24
views
Import stage packages in Streamlit in snowflake
I'm working in snowflake and trying the Streamlit App to built a website.
For my requirement, I need to use the polyline which is available in Googlemaps Library. Figured that I'll need to add the ...
- 31
0
votes
2
answers
43
views
Conditional Lead(), to retrieve the next row only when a condition is met?
I am looking to retrieve the first "Sales_Date" for each "Account_ID", however in my dataset there are entries where the first sales are actually not sales as the product ...
- 41
0
votes
2
answers
33
views
Insert row of default values into table
I need to insert just 1 row of default values into a Snowflake table. I know the following command works on other types of databases:
INSERT INTO my_table DEFAULT VALUES
Is there an equivalent in ...
- 5,927
0
votes
0
answers
11
views
Power BI Desktop figures not equal in published in Workspace
I am working on a visual that reflects the following in Power BI desktop.
However, when I uploaded it in the workspace (no saved bookmarks and no applied filters), the below reflects:
Value is a ...
- 11
2
votes
2
answers
57
views
SQL filter rows by range overlap
I have a snowflake table that roughly resembles the below. I want to filter out all rows that have the same name, provider and an overlapping voltage range.
Before:
NAME
Provider
Min_Volt
Max_Volt
...
0
votes
1
answer
48
views
Snowpark- How to read a from a stage file using snowpark sesssion?
I have multiple file in stage and want to read the contents from it.
For example, i have below file in the stage- single file for this case
from snowfake.snowpark.context import get_active_session
...
- 13
0
votes
1
answer
41
views
S3 Intelligent - Tiering with snowflake managed iceberg tables
Trying to save on huge rarely used data storage costs, with snowflake managed iceberg tables.
Would you apply the economical s3 intelligent-Tiering storage,
to the iceberg’s external volume on s3,
...
- 13
0
votes
0
answers
18
views
How to configure and make an API call to workday from Snowflake
I have a use case to generate a JWT and use that to make an API call to workday from snowflake. Any suggestions?
I am able to achieve this using Azure data factory, but exploring the possibilities to ...
- 11
0
votes
0
answers
23
views
Chunk produces "Failed to create SQL chunk directory", then runs the 2nd time
I have a notebook that queries our Snowflake instance. Oddly, the first time I run the SQL chunk it fails with an error, "Failed to create SQL chunk directory". If I immediately run the ...
-3
votes
0
answers
29
views
DBT tool active users list [closed]
I want to fetch a list of active or non active users in all models .Is it possible?
I tried to list models, but unable to get user info like username,project,
and last activity or last logged in.
0
votes
1
answer
38
views
How to call a variable inside dynamic SQL Query in Snowflake stored procedure
Need help to call variable inside snowflake stored procedure. It throws a "Missing column specification" - how to access variable allcols inside dynamic SQL in snowflake?
CREATE OR REPLACE ...
- 33