Snowflake-cloud-data-platform Questions

I need to make a copy of the database to check my code before release in snowflake. currently, we use clone method for creating copy of

I am trying to do this that strips "['" or "']" in the string. for example, if we have ['customer name'] it should be

Do you know why the following function call wont work using wildcards inside the parameter? create or replace function

I have an interesting issue where i need to create a unique identifier based on match groups for a set of data. this is is based on multiple

select id,index,purchase_list, nvl(case when index = 2 then purchase_list end,0) as qty, sum(nvl(case when index = 2

I have written a stored procedure which will be called from python. the stored procedure needs to insert the variant data into my table if the id

I have a table with id's, dates, and values. i'd like to retrieve each unique id (date and value) the first time the value moves specifically from

I have the below query: select a.* from id_stats a join id_list b on a.id = b.id and a.start_date not between b.start_date::date

I try to get snowflake running on my m1 macbook pro, but whatever i do i get the same error message. i have found different questions related to

I have few files in the s3 bucket and i have created a stage for it. when i query the stage, i get the filenames.

Previously, i was parsing json like this (date and time separately) select json_data:"required_time"::time as

I am trying to use snowflake python connector through sqlalchemy, while i am running pip install

Suppose i have a table called monthly metrics. sample row in table below:

I am writing a sql stored procedure in snowflake (language sql not javascript). i am trying to save a count from a select statement into a

I am new to snowflake and i am trying to run an sql query that splits values with delimiters(semi-column) and create columns for each

Suppose you have the following data: +-------+--------+------------+ | name | rating | date |

I'm trying to set up snowpipe with terraform on azure using

I am trying to create a stored procedure to copy from the external stage (s3 bucket) and use a pattern for the file name. the pattern is based on

I have a table "table1" like below date src_counrty src_state dst_country dst_state value

I am new to snowflake and i am trying to run an sql query that would extract the maximum datetime for each id. below is a sample of my data

My table in snowflake has a column with string values. the string has comma and slash. i need to list only the values before first comma

Trying to work with an exchange rate table and a transactions table, and how the transactions are joined to the exchange table depends on when the

I am able to find the customers who have not ordered in the last year by doing this: select o.custid, max(o.orderdate) as lastorder

I am using the sample code provided by snowflake for connecting with node.js driver, but keep getting following errors:

In the "classic console" worksheet, at the bottom right you could see the query history, which was great for jumping around results set,

When i run this: select name from t1 where _load_datetime::date = '2022-01-31' i see 62 rows but when i

I am trying to convert data type for a column from varchar to number but i was not successful. tried below functions: try_to_number cast

I have the following table: id height persona 182 persona 182 persona 182 persona 192 persona 172 personb 175 personb

Is there a way to use "pd.read_sql_query" w/ snowflake? i am trying to read my snowflake query in a pandas dataframe, however i

I have a snowflake procedure that creates a table using the parameters passed to a snowflake procedure as below: create or replace

I have a table that has two different columns for amounts. first_amount & second_amount. i need to find the balance of the difference of the

I am new to snowflake and have successfully created a view from a table using sql, but i am having issues creating a view that transforms the

I am trying to create a

Use agdwhdev.edw_weather; -- my database and schema create or replace function edw_weather.find_nearest_radar() returns table (latitude

I am surprise that i can insert a row that results in a virtual column going bad. how then do i detect the bad virtual columns and handle it

Greeting :) it might be a simple snowflake problem but i'm struggling with this.. i want to gather different values in the same

I want to test query performance . example: select * from vw_testrole. vw_testrole- has lot of joins. since the data is cached, it

I would like to use last_value() or any similar function in a group by query instead of as a window function. it it

Is it possible to use a sequence inside a view?? i am using the following query: create view < view_name > (id, value1,

I have a table that has the following data start_date

I'm trying to convert the snowflake timestamp that is compatible with

I'm using snowflake's

Is there a simple way to return the last day of the most recent quarter in snowflake? we use financial quarters with last days being: jan.

I have a sql table with multiple fields including (but not limited to the following): member_id, visit_date (in datetime format eg: 2016-01-01),

I am writing user defined functions in snowflake and doing some select in the functions. i need to return 0 if select returns null. in the

We have a continuous insert, update, and delete in a table that is in snowflake db, can this slow down the performance of a table in snowflake

Below is the oracle sql query that i got to convert to snowflake. in here, i am blocked in creating dbms_random.value() in snowflake

I am trying to "copy into" command to load data from s3 to the snowflake below are the steps i followed to create the stage and

I am building a pipeline template in jupyter notebook using

Function date_trunc in snowflake (docs

I have written down a procedure by following the snowflake documentation to generate a list of 'set' statement and execute them in snowflake. i'm

I am trying to run a sql query in my python notebook, code in cell looks like sql = "select date, count(distinct id)

I have a bunch of .csv file and i was looking for the easiest way to load them into snowpark? i am not sure which are the apis

I have price-table with timestamps and price spanning over 3 years. i would like group these with maximum price per day but also show which time

Is there any way to analyze in snowflake, which roles has not been used for any query in snowflake in last one year? the roles view in

I am looking for a query to get name of all employees under a particular manager recursively. emp_table

I used case function to bucket aggregate counts of an item and want to divide the sum total of all counts into the value for each bucket (looking

In snowflake, i have a data structure like: organization table ------------------ org:variant ------------------ {