The hottest features announced at Snowflake Summit 2022 are set to shape the future of the data cloud. — Snowflake Summit 2022 was a four-day extravaganza of feature unveils, product deep-dives, and use case highlights. The CEO, Frank Slootman, called it “the most consequential conference in terms of announcements in four years.” …

Lift and shift, divide and conquer. An object by object migration guide from SAP to Snowflake — Data warehouse migrations are colossal undertakings, not to be taken lightly. But, if you are reading this article, it means that your organization has weighed its options and decided to abandon legacy on-prem architecture in favor of a future-proof, scalable cloud solution. I commend you. However, years of relying on…

Reaping the rewards of data mesh while avoiding the pitfalls of this trendy new framework. — In a recent webinar, a question was put up for debate: “Are we bundling or unbundling the modern data stack?” Cloud data platforms like Snowflake, AWS, and GCP strive to meet their user’s data needs in a single, convenient, and cost-effective platform. …

Emerging trends to watch for in 2022 in data analytics, BI, AI, and governance. — As unprecedented and unpredictable as 2021 has been, the team at SqlDBM is getting prepared for the year to come by trying to anticipate what’s looming on the horizon. Through conversations with customers and industry leaders, we have compiled a list of twenty predictions that we’ll be tracking throughout 2022…

Map meets territory in the definitive guide to relational and transformational modeling. How to use each and get the most out of both. — I image-googled “modeling” and this is what came up. While it has absolutely nothing to do with databases, it accomplishes two important things: it grabs attention (thanks for clicking) and illustrates that modeling is indeed a broad concept. …

From business process to business warehouse, step by step. — With the advent of cloud data warehousing, the time and monetary costs of working with data have dropped considerably. Platforms like Snowflake’s Data Cloud eliminate the cost barrier for new projects and offer features that allow for rapid prototyping like zero-copy cloning and scalable warehouses. This drop in storage and…

3x performance, new features, and a dozen different product enhancements. — Opening Ceremony In the spirit of the Tokyo Olympics, SqlDBM has decided to go for the gold with its quarterly product update. We are competing in a dozen different events, covering all categories, from performance improvements to enhanced functionality and adding new features. …

Strategies and considerations to ensure a smooth transition to cloud data analytics. — Accelerated by the Covid crisis, the cloud adoption phenomenon has gone from “cloud-presence” to “cloud-first.” Cloud data warehousing offers many compelling advantages like cost optimization, minimizing vendor lock-in, and enabling effortless scaling. …

Whether working faster or working smarter, these hacks lay the foundation for BI efficiency. — Ill habits gather by unseen degrees, as brooks make rivers, rivers run to seas. — Ovid, “Book XV,” Metamorphoses, trans. Sir Samuel Garth, John Dryden, et al. “Unseen degrees” is the poetic way of saying that bad habits have knock-on effects that often go unattributed, though certainly not unnoticed. …