Changelog
v1.5.3
- Date:
May 5, 2024
This is a security release to upgrade some dependencies to latest version as we receive vulnerability alerts. We strongly recommend that all sqllineage installations be upgraded to this version immediately.
This release also includes an improvement regarding metadata provider.
Enhancement
set target table column name from MetaDataProvider (#528)
v1.5.2
- Date:
April 7, 2024
Enhancement
Bugfix
v1.5.1
- Date:
February 4, 2024
This is a bugfix release mostly driven by community contributors. Thanks everyone for making SQLLineage better.
Enhancement
Bugfix
Not fully processed top-level subquery in DML (#564)
Missing target table with tsql parsing into statements with union (#562)
The second and subsequent case when subqueries in the select_clause are not correctly recognized (#559)
SQLLineageConfig boolean value returns True for all non-empty strings (#551)
Column lineage does not traverse through CTE containing uppercase letters (#531)
v1.5.0
- Date:
January 7, 2024
Great thanks to liznzn for contributing on MetaData-awareness lineage. Now we’re able to generate more accurate column lineage result for select * or select unqualified columns in case of table join through a unified MetaDataProvider interface.
Also a breaking change is made to make ansi the default dialect in v1.5.x release as we target ultimately deprecating non-validating dialect in v1.6.x release.
Breaking Change
Make ansi the Default Dialect (#518)
Feature
Metadata Provider to Assist Column Lineage Analysis (#477)
Enhancement
Bugfix
v1.4.9
- Date:
December 10, 2023
This is a bugfix release where we closed a bunch of issues concerning CTE and UNION
Bugfix
Not Using Column Name Specified in Query For CTE within Query (#486)
CTE (Common Table Expressions) within CTE (#484)
lineage inaccurate when CTE used in subquery (#476)
UNION ALL Queries resolves column lineage incorrectly (#475)
Missing table when parsing sql with UNION ALL (#466)
No target tables in UPDATE statement using CTE (#453)
v1.4.8
- Date:
October 16, 2023
Enhancement
Bugfix
v1.4.7
- Date:
August 27, 2023
Enhancement
Bugfix
v1.4.6
- Date:
July 31, 2023
In this release, we finally reach the milestone to make all sqlparse only test cases passed with sqlfluff implementation. That’s a big step in ultimately deprecating sqlparse. Also by upgrading to latest version of sqlfluff (with our PR merged), we enjoy the benefits of improved sqlfluff performance when parsing some SQLs with nested query pattern.
Enhancement
Bugfix
v1.4.5
- Date:
July 2, 2023
Enhancement
Bugfix
v1.4.4
- Date:
June 11, 2023
Enhancement
Bugfix
v1.4.3
- Date:
May 13, 2023
Enhancement
Support postgres style type casts “keyword::TIMESTAMP” (#364)
Bugfix
v1.4.2
- Date:
April 22, 2023
Bugfix
sqlparse v0.4.4 breaks non-validating dialect (#361)
v1.4.1
- Date:
April 2, 2023
Bugfix
frontend app unable to load dialect when launched for the first time
v1.4.0
- Date:
March 31, 2023
Great thanks to Nahuel, Mayur and Pere from OpenMetadata community for contributing on feature Dialect-awareness lineage. Leveraging sqlfluff underneath, we’re now able to give more correct lineage result with user input on SQL dialect.
Feature
Enhancement
Bugfix
v1.3.7
- Date:
Oct 22, 2022
Enhancement
Bugfix
v1.3.6
- Date:
Aug 28, 2022
Enhancement
Bugfix
v1.3.5
- Date:
May 10, 2022
Enhancement
Bugfix
v1.3.4
- Date:
March 6, 2022
Enhancement
update black to stable version (#222)
Bugfix
v1.3.3
- Date:
December 26, 2021
Enhancement
smarter column-to-table resolution using query context (#203)
Bugfix
v1.3.2
- Date:
December 12, 2021
Enhancement
v1.3.1
- Date:
December 5, 2021
Enhancement
test against Python 3.10 (#186)
Bugfix
v1.3.0
- Date:
November 13, 2021
Feature
Column-Level Lineage (#103)
Bugfix
SHOW CREATE TABLE parsed as target table (#167)
v1.2.4
- Date:
June 14, 2021
Enhancement
v1.2.3
- Date:
May 15, 2021
Enhancement
lineage API response exception handling (#148)
v1.2.2
- Date:
May 5, 2021
Bugfix
resize dragger remain on the UI when drawer is closed (#145)
v1.2.1
- Date:
May 3, 2021
Enhancement
v1.2.0
- Date:
April 18, 2021
Feature
Enhancement
v1.1.4
- Date:
March 9, 2021
Bugfix
trim function with from in arguments (#127)
v1.1.3
- Date:
February 1, 2021
Bugfix
UNCACHE TABLE statement parsed with target table (#123)
v1.1.2
- Date:
January 26, 2021
Bugfix
Bring back draw method of LineageRunner to avoid backward incompatible change (#120)
v1.1.1
- Date:
January 24, 2021
Bugfix
SQLLineageException for Multiple CTE Subclauses (#115)
v1.1.0
- Date:
January 17, 2021
Feature
A new JavaScript-based approach for visualization, drop dependency for graphviz (#94)
Enhancement
Test against Mac OS and Windows (#87)
Bugfix
v1.0.2
- Date:
November 17, 2020
Enhancement
Bugfix
cartesian product exception with ANSI-89 syntax (#89)
v1.0.1
- Date:
October 17, 2020
Enhancement
remove upper bound for dependencies (#85)
v1.0.0
- Date:
September 27, 2020
New Features
a detailed documentation hosted by readthedocs (#81)
Enhancement
drop support for Python 3.5 (#79)
v0.4.0
- Date:
August 29, 2020
New Features
DAG based lineage representation with visualization functionality (#55)
Enhancement
v0.3.0
- Date:
July 19, 2020
New Features
Enhancement
Bugfix
v0.2.0
- Date:
April 11, 2020
Enhancement
test against Python 3.8 (#39)
Bugfix
comment in line raise AssertionError (#37)
white space in left join (#36)
temp table checking (#35)
enable case-sensitive parsing (#34)
support for create table like statement (#29)
special treatment for DDL (#28)
empty statement return (#25)
drop table parsed as target table (#21)
multi-line sql causes AssertionError (#18)
subquery mistake alias as table name (#16)
v0.1.0
- Date:
July 26, 2019
New Features
stable command line interface (#2)
Enhancement
v0.0.1
- Date:
June 16, 2019
New Features
initial public release