Airport Codes
Overview Sonra has published a data set for airport codes on the Snowflake marketplace. Airport codes are used to distinguish airports around the world to ensure that there is no confusion between countries and cities. Airport codes appear on passengers’ documents related to their reservations, flight tickets and they are also used by air traffic ...
Read MoreImproving performance and reducing costs with Materialised Views on Snowflake
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 More