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,257
questions
1
vote
1
answer
7k
views
Snowflake not recognizing a CAST or to TO_VARCHAR function over a join key
I am trying to perform a join across three tables.
This is the initial code, that works but returns all NULL for product description. I figured it is because in the first 2 tables that I am joining ...
0
votes
1
answer
138
views
alter external table TABLENAME refresh error
Error message - SQL execution internal error: Processing aborted due to error 300002:1263389222; incident 9679362.
Trying to refresh external table on S3. It has worked previously.
create or ...
3
votes
2
answers
5k
views
Snowflake - Operation in VALUES clause - Invalid expression
How can we get a rational number in a VALUES clause in Snowflake ?
SELECT * FROM (
VALUES (1/3.0), (2)
) AS t ;
returns :
SQL compilation error: Invalid expression [1 / 3] in VALUES clause
0
votes
1
answer
846
views
I need to re-enable MFA after reinstalling the DUO app
I have accidentally removed the DUO app from my mobile. After installing it, I need to re-scan the code, but I cannot remove the current MFA enabled phone number from the settings
Multi-factor ...
0
votes
1
answer
5k
views
Snowflake invalid identifier when performin a join
I have been trying to do an outer join across two different tables in two different schemas. I am trying to filter out before from the table variants the character that are smaller than 4 and bigger ...
5
votes
5
answers
4k
views
Snowflake - return different (not similar) values between two arrays
After looking Snowflake documentation, I found function called array_intersection(array_1, array_2) which will return common values between two array, but I need to display array with values which is ...
0
votes
1
answer
3k
views
How to get the data in snowflake for past 24 months in snowflake
I have the data for the current month in Snowflake which I am extracting with the below mentioned query
select distinct HPOLICY
, ANNUALPREMIUMAMOUNT
, year(dateadd(year, ...
2
votes
1
answer
3k
views
Visio Stencil for Snowflake?
I want to design architectures that include Snowflake. My tool of preference is Visio; so I'm looking for Snowflake Visio stencils.
My google searches have come up empty, and unfortunately Snowflake ...
4
votes
1
answer
18k
views
How download more than 100MB data into csv from snowflake's database table
Is there a way to download more than 100MB of data from Snowflake into excel or csv?
I'm able to download up to 100MB through the UI, clicking the 'download or view results button'
3
votes
4
answers
9k
views
How to debug a Snowflake stored procedure?
I am using the Snowflake Cloud Database, please help me with a tool to debugging the procedures or functions.
0
votes
1
answer
3k
views
Snowflake Grant Select on single schema
db: my_db
schemas: my_schema_1, my_schema_2
tables:
my_schema_1: table_a, table_b
my_schema_2: table_c, table_d
I would like to grant select to all tables in my_schema_2.
use role securityadmin;
...
0
votes
1
answer
6k
views
Query time out issue in snowflake
I am getting a query time out problem when the query fails to execute within 45 seconds. I need some advice on how to set query time out for snowflake. FYI, I have tried using query_Timeout parameter ...
1
vote
2
answers
2k
views
Easter / Good Friday for Sowflake Date Dim
Further Evolved : The code below satisfies what was wanted in earlier comments [if you follow history] :), my new question right below is stumping me.
Question: I want to have 'Week_Of_Year' Adjust ...
0
votes
2
answers
296
views
Decrypt in Snowflake using Unix command
I am facing an issue where I have to decrypt a db column in Snowflake.The transformation to decrypt the column is a unix command.How do I achieve this decryption in Snowflake.