Questions about snowflake-cloud-data-platform
Read more about snowflake-cloud-data-platform
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Alter Stage to convert it into external stage (Read from S3) Snowflake
I have created stage with json format to copy data from desktop to snowflake. Now I want to load data from s3 bucket instead of desktop.
alter stage investor_stage set url='s3://em_pi'
IF I need to c...
Xi12
Votes: 0
Answers: 1
Remove certain characters in a column Snowflake
I am having data in a column like 'EARTH PLANET-ABC', 'MARS PLANET - ABC', 'JUPITER -ABC', 'VENUS- ABC' etc. I need to return the values 'EARTH PLANET', 'MARS', 'JUPITER', VENUS etc whenver the column...
Jude92
Votes: 0
Answers: 2
Duplicate data when using Snowflake SQL left join
I'm having trouble understanding LEFT JOIN results in Snowflake.
select * from
(select 1 as AccountIdA) s
LEFT OUTER JOIN (Select 1 as AccountIdB, 'Val1' as Col1 union select 1, 'Val2' as Col1) t1 on ...
Eric Bowden
Votes: 0
Answers: 1
How to clear last run query (Cache) in snowflake
I want to test query performance . Example:
select * from vw_testrole.
vw_testrole- has lot of joins. Since the data is cached, it is returning in less time. I want to see the query plan and How to...
Xi12
Votes: 0
Answers: 2