Converting XML to Snowflake, Redshift, BigQuery, Azure Synapse. A comparison

Uli Bethke May 24, 2021

Today, with the rise of the data and cloud-computing applications, the need of storing and analyzing the growing number of semi-structured data is increased. The data originating from a wide range of sources such as sensors, IOT devices, application logs, etc. use semi-structured data formats such as XML, JSON, Avro, etc. because of their flexibility. ...

Read More

The 6 Factors You Need to Get Right to Make Your XML Conversion Project a Success

Uli Bethke February 18, 2021

A successful XML conversion project makes data: Intelligible Readable, and Analysable Achieve that and decisions can be made quickly on accurate and reliable data. Unfortunately, many projects fail because of time, resource, or budget restrictions. This is both frustrating and expensive. Get the following elements right to ensure that you see your project through to ...

Read More

Guide to Geography Dimension on the Snowflake Marketplace

Uli Bethke February 3, 2021

We have published a universal Geography Dimension on the marketplace of the Snowflake Data Cloud. You can easily join the data with your in house data to look up location data. You can also use it for drilling down / rolling up in any type of location analytics. ER DIAGRAM CORE TABLES The core tables ...

Read More

The Secrets to Unlocking XML Data in an Optimised Format for Downstream Users

Uli Bethke January 22, 2021

All the data in the world is not worth much unless you can use it. That means it must be intelligible, readable, and analysable. Organisations spend huge resources on data warehousing projects that attempt to wrestle with the data, in order to get it into a format that makes sense to those who must analyse ...

Read More
1 2 3 4 80