I was able to blob test connection and it's successful, but when I attempt to look for the storage path it shows this error. screenshot Full error: Failed to load Blob operation failed for: Blob Storage on container '' and…
in the example data set above, I want to assign a Primary_Store for each buyer_id based on the following criteria if one store has more visit counts than any other store for that buyer, assign as primary if no, then…
I have a table like sales(product_number, assortment, date) Here 1 assortment contains multiple products. For example 1 assortment i.e. chocolates contains product_number cadbury, 5 star, kitkat etc. Each and every product has date. I'm trying to check that all products…
Below is the example. BEGIN set tablenameA = 'tablenamelala'; SELECT * FROM table($tablenameA); END I am expecting it will return me the result from the select statement.
I have the following table: CREATE TABLE table_one( person varchar(55), date_value date, proj varchar(2), value int, time varchar(2 ); INSERT INTO table_one VALUES ('A1',2020-10-01'W',10,'T1') ('A1',2020-10-01'A',5,'T2') ('A1',2020-10-01'P',6,'T3') ('A1',2020-10-01'A',9,'T4') ('A1',2020-10-01'P',11,'T5') ('A1',2020-10-01'A',4,'T6') ('A1',2020-10-01'P',2,'T7') ('A1',2020-10-01'A',1,'T8') ('A1',2020-10-01'P',10,'T9') ('A1',2020-10-01'A',8,'T10') I want an SQL query which creates…
I do have one table with 2 columns and another with 2 columns employee(id, transaction_date), employee_1(id, transaction_date) Below is the query i tried, but it's returning an error SELECT COUNT(DISTINCT id) / COUNT(DISTINCT id) FROM employee, employee_1 Error is SQL…
I have a raw table from firebase in snowflake. All the information that I need is in the field "Data" (JSON). Because of that, I created a view to extract all the data in deferents columns. I use json_extract_path_text(data, 'createdAt')…
TABLE1 mach_id optout time 16543 NULL 2022-09-27 16543 YES 2022-09-26 16543 NO 2022-09-25 14444 YES 2022-09-27 15676 NO 2022-09-27 15676 YES 2022-09-26 11111 NULL 2022-09-27 11111 NULL 2022-09-26 Required table mach_id optout 16543 YES 14444 YES 15676 NO 11111 NULL…
Question: SQL query to best get the desired result below. Input: Identifier Date 1234 2022-01-01 1234 2022-08-11 7890 2022-08-11 4444 2022-08-13 Output: Identifier Date 7890 2022-08-11 4444 2022-08-13 Note: Want only new entries that was not in the past. Tried…
I'm writing a script to create 5 tables, but cannot seem to get the SQL DDL part of the statement to work. I get a syntax error " unexpected 'table' ", and I've tried the SQL statement with execute immediate…