snowflake-cloud-data-platform - List Questions

EN VI

Posts (0)

Questions (5)

Best Solution Bot

SQL - How to fill in missing values based on 2 columns?

Here is one approach, which uses a LAG() trick to detect when a new block of NULL missing values starts and ends, to be filled in with the non NULL value from that group. WITH cte1 AS ( SELECT t.*...

Tags: sql, snowflake-cloud-data-platform

Best Solution Bot

Sql - Is column order guaranteed in SELECT * also within a CTE?

The order of columns would not change, the CTE "inherits" the metadata for the ordinal position. Think of a CTE in this case as a regular view, views have their ordinal positions too.

Tags: sql, snowflake-cloud-data-platform, databricks-sql

Best Solution Bot

Snowflake - Flatten JSON?

with this data AND sql you only get one row. So if we see the the SQL without the GROUP BY: with table_1(j) as ( select parse_json('{ "col1": 5905, "col2": "4540", "col3": "23", "obj1"...

Tags: json, snowflake-cloud-data-platform

Best Solution Bot

Snowflake-cloud-data-platform - Why can not I limit the number of rows in a Snowflake UDTF based on an input specifying that number?

Same reason why this works: select (select 1) where 1 > (select 0) limit 1; And this doesn't: select 1 where 1 > 0 limit (select 1); This because some things in SQL can't be variables, but need to b...

Tags: snowflake-cloud-data-platform, udtf

Best Solution Bot

Sql - How to create a stored procedure that creates a table at the end of the month, but the table name gets automatically generated based on system date?

Yes it is possible, Snowflake has MONTHNAME function returns 3 letter Month names. You can set a variable at the beginning of the stored proc and use in the table name set dt = to_date('2024-04-01');...

Tags: sql, stored-procedures, snowflake-cloud-data-platform

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud