Airport Codes

Uli Bethke December 22, 2022

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 More

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
1 2 3 96