Snowflake SQL parsing

In this document, you'll learn how Dataedo uses an SQL parser with the Snowflake SQL dialect and explore its capabilities.

Supported SQL engines

The following SQL engines use this dialect:

• Snowflake

Automatic column-level lineage from SELECT||CREATE VIEW statements

Dataedo will create column-level data lineage for views and SQL queries based on the script. Just leave the Automatic lineage option selected during import.

If you deactivate this feature during import, you can still create column-level lineage automatically using the Parse Script to Lineage functionality in the Script tab.

This function also applies to manually added views created with a script, as well as SQL query objects.

Supported syntax overview

Supported SQL Syntax

Dataedo supports automatic lineage creation for the following Snowflake syntax:

• SELECT and CREATE VIEW statements
• CASEs and other logic-related expressions
• UNIONs
• JOINs
• Aliases
• Functions and operators
• Subqueries and nested queries
• Non-recursive Common Table Expressions (CTEs)

Unsupported SQL Syntax

Dataedo does not support automatic lineage creation for the following Snowflake syntax:

• Statements that access nested data such as JSON, XML, or objects as columns
• PIVOT and UNPIVOT relational operators
• Recursive Common Table Expressions (Recursive CTE)
• Dynamic queries
• Window functions
• Referencing to alias on the same level (for example SELECT 1+1 AS "reference", "reference")
• Renaming columns from asterisk (e.g. SELECT table_a.* RENAME column_in_table_a AS col_alias_a FROM table_a)
• Excluding columns from asterisk (e.g. SELECT table_a.* EXCLUDE column_in_table_a FROM table_a)

Online SQL Parser

Check out Dataedo's online SQL parsing and analysis tool to test SQL parsing capabilities in real time.