Improving performance and reducing costs with Materialised Views on Snowflake
Uli Bethke
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 MoreConverting Duck Creek XML to Snowflake
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 MoreConverting HL7 CDA XML to Snowflake
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 MoreHow to do full text search with Snowflake, Inverted Indexes and Snowpark
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