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.
https://t.co/In11LElUVE
#sql#dataengineering#data
4 DDLs for the three inline views and the final output and one for the physical table OrderLines.
Now here my question: what use cases do you see for this feature?
One use case I see is partial materialisation during #ETL#SQL 2/2
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
Find out how you can benefit from using geospatial data, the data marketplace and location analytics on the Snowflake data platform.
https://t.co/VjRzSX34Yt
Snowflake Cloud Data Platform web user experience enhanced with new app: Snowflake Snowsight. We walk you through 7 refreshing #Snowsight UI features + tips & tricks
https://t.co/VJJOW8XGOY
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
https://t.co/6DYUGDz8kN
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
https://t.co/zfpMSJVgrI
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.
https://t.co/YkexhQJGvS
This hands on blog post walks you through some scenarios and examples of using the Snowflake data platform for data preparation and ETL.
https://t.co/k2h3zdGb5e
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.
https://t.co/U3by5GX5rV