Blog

Sat Nov 25 2023

All at onceStartup Killers

The post-Snowflake Horizon era for data startups

• Anton Revyako

• Snowflake
• Horizon
• Startups

Mon Nov 13 2023

Snowflake Special Behavior SeriesScalar functions name resolution special behavior

A simple way to break your database when using UDFs in VIEW

• Anton Revyako

• Snowflake
• SQL
• UDF
• Special Behavior

Thu Sep 07 2023

Snowflake Core FeaturesThe gaps in Snowflake internal lineage

Snowflake has built-in tools for tracking data lineage. But is it enough?…

• Anton Revyako

• Snowflake
• SQL
• Core Features

Mon Jun 26 2023

Snowflake Special Behavior SeriesLIMIT keyword and function parameters

For instance, the LIMIT keyword, which is not actually a keyword. Because of this, it can be used as an alias!

• Anton Revyako

• Snowflake
• SQL
• LIMIT
• Special Behavior

Tue Jun 06 2023

Snowflake Special Behavior SeriesVirtual (computed/calculated/derived/generated) columns

In the documentation, virtual columns are mentioned only in the context of EXTERNAL TABLEs and STREAMs. These are METADATA$… columns that contain record metadata. But you can also create virtual columns in regular tables…

• Anton Revyako

• Snowflake
• SQL
• Virtual Columns
• Special Behavior