When people hear Materialised Views they think performance boost for aggregate queries. 🤔 While true, Materialised Views can be used for a whole range of use cases other than aggregate navigation.
sonra.io/flowhigh/materialis…
#sql #dataengineering #data
I need my network's help. We are currently working on a product feature to generate DDL from SQL (it is a by-product of some bigger app). This feature will let you generate DDL from inline views or CTEs, e.g. in the screenshot you would get 5 table DDLs. 1/2
1
1
Find out how you can benefit from using geospatial data, the data marketplace and location analytics on the Snowflake data platform.
sonra.io/2020/10/15/location…
Snowflake Cloud Data Platform web user experience enhanced with new app: Snowflake Snowsight. We walk you through 7 refreshing #Snowsight UI features + tips & tricks
sonra.io/2020/07/16/snowflak…
4
MedVault Analytics: primary healthcare practice solution on Snowflake Cloud Data Platform(separation of data workloads, E2E encryption, utility billing). Less clinical staff admin.+increased reimbursements=thousands € savings per practice
sonra.io/2020/06/29/medvault…
3
In this blog post we pair up Snowflake with Qlik Replicate for streaming and real time analytics
sonra.io/2020/06/12/snowflak…
3
Point and click ETL tools have failed data prfoessionals again and again. In this blog post we look at the history of ETL, the limitations of ETL tools and the unstoppable rise of data warehouse automation
sonra.io/2020/05/22/to-hell-…
Converting XML and KML documents from OpenStreetMap Ireland and Irish geodata. Integrating Irish census data with the geodata. Analysing the census and geodata from Ireland.
sonra.io/2020/04/14/geo-and-…
2
Automatically generate a relational database schema from XML, XSD, or JSON.
sonra.io/2020/04/07/generati…
1
How optimisation algorithms can simplify the structure of your target schema when converting XML/JSON to a relational format.
sonra.io/2020/03/31/optimisa…
1
This hands on blog post walks you through some scenarios and examples of using the Snowflake data platform for data preparation and ETL.
sonra.io/2020/05/28/the-snow…
Checklist for a successful data lake implementation
sonra.io/2018/05/22/checklis…
good post on indexes in columnar storage using parquet as reference but relevant in general lnkd.in/dM-wEY5
We use Flexter to convert 3GPP Configuration Management XML (3G, UMTS, 5G) to Snowflake. Configuration data is very complex, recursive, and comes in very large files. A perfect fit for Flexter.
sonra.io/2019/08/23/converti…
1

