SQLdep

Snowflake SQL dialect added. Try it.

22 September, 2017 10:04:22 AM · Martin

We are happy to announce a support for Snowflake SQL dialect. All SQLdep features like automated documentation of ETL processes and capturing end-to-end data lineage are available now for Snowflake dialect.

Snowflake itself is a highly optimised database for Data Warehousing and it runs in cloud. The company was founded in 2012 and by early 2017 they have completed D round and raised $100M. 

From technical standpoint Snowflake runs on Amazon Web Services and the very interesting feature is separation of storage and computing power. You can scale the compute power up when workload increases and down when not needed.  

Database engine was written from scratch and is optimised for handling a very large datasets. As one of the Snowflake’s customers says: “month-end report that took 20-22 hours now takes 4 minutes”.

During implementation of Snowflake SQL dialect we have seen a very clean syntax. Any developer or data analyst will have no trouble adjusting to this SQL dialect. Analytic extensions from SQL-2003 (Window functions) are available.

Try our data lineage capabilities by uploading your Snowflake SQL statements. A free trial account is the best way to start.

 

Read a case study

SQLdep saved GE Money twelve months of work. GE Money was searching for ways to make the development and administration of its 20TB data warehouse faster and more efficient.

Download