SQL-TILUSING Clause and Column Auto-rename
Just another way to screw up with SELECT *
- Anton Revyako
- SQL
- USING
- Special Behavior
- SQL-TIL
Just another way to screw up with SELECT *
Column aliases in Snowflake
Fun with LIKE operator
Check your data lineage tool :)
IDENTIFIER() function go nuts
The post-Snowflake Horizon era for data startups
A simple way to break your database when using UDFs in VIEW
Snowflake has built-in tools for tracking data lineage. But is it enough?…
For instance, the LIMIT keyword, which is not actually a keyword. Because of this, it can be used as an alias!
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…
We use cookies (or similar technologies) to customize content, analyze traffic, and improve your experience on our website.
By continuing to use the site, you agree to the use of cookies, you consent to our use of cookies
and the sharing of information (including data we collect) about your website usage. For more information about our use of cookies, please see our Cookie Policy.