graphbuild/sql-transformer repository overview

⁠SQL Transformer - Release Notes

⁠2.6

⁠2025-01-23

• Improvements to Snowflake connections
• Property Graph performance improvements
• Image optimisations

---

⁠2.5

⁠2024-09-25

• Added support for AWS Athena
• Added a suite of new functions, including: toSnakeCase, toKebabCase, toCamelCase, toPascalCase, ifEqual
• Improved stability and support for LPG transformations

---

⁠2.4

⁠2024-03-27

• Patched all vulnerabilities in the image
• Support for Snowflake and encrypted RSA keys

---

⁠2.3

⁠2023-07-03

• Transformer logs can now be accessed via the logging endpoint
• A SQL query can now handle special characters in the response data

---

⁠2.2

⁠2023-04-27

• Improvements to Property Graph mode, including the enabling of configurable namespace / IRI removal
• Storage optimisations

---

⁠2.1

⁠2023-02-15

This is the first release of the SQL Transformer (formerly the SQL Lens from Data Lens Ltd).

It is a highly configurable service which will transform SQL database content into Semantic RDF data or Property nodes and edges data.

• Supports most popular JDBC driver compatible SQL Databases, including: MySQL, Microsoft SQL Server, Oracle, Postgre SQL, IBM DB2, Denodo, H2, and more
• Capable of iteratively transforming massive amounts of data from any size of SQL Database result-set
• Over 100 built-in data cleansing and transformation functions, as well as the ability to create and add your own bespoke functions
• Able to perform complex SQL queries for source data
• Can be triggered via the Graph Build Studio UI, via a cron schedule, or directly via RESTful endpoint
• Deployable on-premise or in cloud
• Provenance as standard

---