LineageEyes Wide Shut Data Lineage #1
Data Lineage is a Lie
- Anton Revyako
- SQL
- Lineage
Blog
IN-QUERYSnowlfake ASOF JOIN in dwh.dev in-query lineage
New improvements in dwh.dev in-query lineage
- Anton Revyako
- SQL
- IN-QUERY
- ASOF JOIN
SQL-TILUSING Clause and explicit columns rename
Just another way to screw up with SELECT *. Again
- Anton Revyako
- SQL
- USING
- Special Behavior
- SQL-TIL
Dwh.dev FeaturesWe need to go deeper, Snowflake
Inquery data lineage in Snowflake
- Anton Revyako
- SQL
- Lineage
- Inquery
- Features
SQL-TILSnowflake functions overloading
Create functions with the same name but different arguments
- Anton Revyako
- SQL
- Functions
- Special Behavior
- SQL-TIL
SQL-TILSnowflake's hidden gem - CTE macros
A very cool Snowflake functionality that is not mentioned in the documentation
- Anton Revyako
- SQL
- CTE
- Special Behavior
- SQL-TIL
SQL-TILUSING Clause and Column Auto-rename
Just another way to screw up with SELECT *
- Anton Revyako
- SQL
- USING
- Special Behavior
- SQL-TIL
Data Lineage ChallengeSpecial Behavior: Reusing Column Aliases
Column aliases in Snowflake
- Anton Revyako
- SQL
- String
- Special Behavior
- Data Lineage Challenge
SQL-TILSpecial Character Escaping Behavior
Fun with LIKE operator
- Anton Revyako
- SQL
- String
- Special Behavior
- SQL-TIL
Data Lineage ChallengeData Lineage Challenge
Check your data lineage tool :)
- Anton Revyako
- Snowflake
- SQL
- Data Lineage Challenge
Snowflake Special Behavior SeriesSpecial Behavior of identifiers
IDENTIFIER() function go nuts
- Anton Revyako
- Snowflake
- SQL
- Identifier
- Special Behavior
All at onceStartup Killers
The post-Snowflake Horizon era for data startups
- Anton Revyako
- Snowflake
- Horizon
- Startups
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
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
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
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