Improving performance and reducing costs with Materialised Views on Snowflake

Uli Bethke November 18, 2022

What are Materialised Views? Materialised Views are similar to Views. A View is a logical or virtual table representing the result of a query. Each time the View is queried the underlying SQL is executed and the result returned to the client. Views have the advantage of being reusable. Frequently used logic can be put ...

Read More

Converting Duck Creek XML to Snowflake

Uli Bethke October 18, 2022

Overview In this blog post we will automate the conversion process of Duck Creek XML to a relational database format with Flexter . In this example we convert to Snowflake but Flexter supports any relational database or data warehouse platform. What is Flexter? Flexter converts any XML/JSON to a readable format in seconds. Any type. ...

Read More

Converting HL7 CDA XML to Snowflake

Uli Bethke October 18, 2022

Overview In this blog post we will automate the conversion process of CDA XML to a relational database format with Flexter . What is Flexter? Flexter converts any XML/JSON to a readable format in seconds. Any type. Any size. Any volume. Any target Projects that can take weeks or months, or never get finished, can ...

Read More

How to do full text search with Snowflake, Inverted Indexes and Snowpark

Uli Bethke September 19, 2022

Inverted Index An Inverted Index is a data structure used to support full text search over a set of documents. An inverted index is very similar to an index at the end of a book. In the book index you get an alphabetically sorted list of the core keywords with a list of pages where ...

Read More
1 2 3 26