Would like the SQL experts to chime in on what the difference between A and B is? A) two different "SELECT COUNT DISTINCT" queries giving different n...

I have created an SQL model in snowflake that gives a several outputs among those ones, I have two columns that are the next : The first column: call...

How to easily simulate that query runs in a minimum of time and still returns an output? If possible, generating fake data with "cross join" or changi...

COUNTRY STORE_ID ORDER_DATE DE 990003975 2023-01-24 FR 990004963 2023-04-11 FR 990005204 2023-06-15 FR 990005204 2023-06-10 FR 9900052...

When copying data from Azure Data Factory to SnowFlake I get the following error from SnowFlake Status Info Status Failed Error count/Error limit 3/1 ...

I have been trying to run a simple query through Node JS and snowflake. the results are showing when I log it to the console but when trying to call t...

In Snowflake SQL, I am trying to achieve a scenario to create array aggreagate of dates based on certain where conditions, but I am not able to achiev...

Is there a way to select all views in a database/schema in snowflake Snowflake along with their respective sizes so that I can find the largest views?...

I am trying to create a loop inside store procedure in snowflake. I have a table created which has 3 columns(groupqueryids, query, orderid). One group...

The goal is to combine two input arrays to an OBJECT: For: CREATE TABLE tab(keys ARRAY, vals ARRAY) AS SELECT ['key1', 'key2', 'key3'], [1,2,3] UNION ...

I am trying to run the following query on a snowflake table and it works. SELECT distinct "Book Name." from TEST.BIZ.VIEW_BOOK WHERE "Created on" >=...

I am trying to pull one table data from Snowflake and want to expose it through data editor feature of Streamlit in UI. It is working in my local envi...

I had created Streamlit App in snowflake. The dashboard can be viewed by the users who are all having access to snowflake account. is it possible for ...

I am writing an application that is meant to compare data in two files. The files have a defined number of columns, and to track the differences betw...

Snowflake allows to concatenate string across multiple rows by using aggregate/windowed LISTAGG function. Sometimes we just need first few occurrences...

Why do I get SQL compilation error when I tried to use numeric/qmark parameter binding if the numeric/qmark parameters are used right before period (....

ALTER TABLE Table_Name ADD COLUMN IF NOT EXISTS Column_name dataType; The above Statement worked in Snowflake for a while, but now seeing error Progra...

For example, I have following code create table if not exists table_name (lease no. varchar(255)) It shows unexpected 'no'. , Is there a way that I ...

I am trying to create a temporary table in Snowflake using CTE. I will be using this table in the same session for another query. Here is the syntax s...

WOuld like to extract values from event_params attributes, I would like to get values from event_params."key": "link_class":string_value Ex: event_par...

I'd like to convert a list of literal values into columns using Snowflake. I've googled around and there are a lot of answer stating FLATTEN() can ach...

Hello and thank you in advance! I have a SQL query that returns a list of customers for a course ID where the status is 'active'. I noticed the total...

I'm trying to pass a JSON object containing fully qualified tables into a stored procedure so I can loop through it and put the key values into a tabl...

In snowflake I can use SHOW COLUMNS IN TABLE Schema1.Table1; Which will return results that tell me that the kind of column is "COLUMN" or "VIRTUAL" c...

Requirement : To get single_address_object which has unique values in all rows Example as below data , Country and Region is common in all rows i...