Insights
Blog & Cases
Tutorials, certifications, opinions and customer cases from our consultants.
New job, new cert, new exam version: my SnowPro Core C03 experience
Data engineer Joline prepared for and passed the newly updated SnowPro Core C03 exam within her first two months. How she studied, and what changed since C02.
Headless 360 could change how we think about CRM
Salesforce and Anthropic announced Claudeforce this week, bringing Claude much deeper into the Salesforce ecosystem. Claude will be able to work with Salesforce data and actions, while Salesforce is also making Claude available within Agentforce and other parts of its AI stack.
Explain Snowflake EXPLAIN: Catching Join Explosions Before They Cost You
Stop reacting to massive Snowflake bills after a query has already failed or stalled. Digital Hive shares how implementing the EXPLAIN command during code review shifts your data engineering from reactive debugging to proactive cost prevention. Reach out to Digital Hive to find out how our data team can optimize your pipelines and eliminate expensive cloud waste.
The Dashboard Migration Button Won't Save Your Snowflake Credits
Is your Snowflake dashboard migration just moving the "compute burn" to a new format? Digital Hive explains why Snowflake’s native conversion button is only phase one of a sustainable migration strategy. See our guide on reducing credits with Streamlit and reach out to Digital Hive to see how we can optimize your entire data stack.
Managing Snowflake Infrastructure-as-Code
Discover how to eliminate environment drift by transitioning from imperative SQL to Snowflake Declarative Configuration Management (DCM). Digital Hive demonstrates how to provision a robust Medallion Architecture using native, version-controlled code. Read the guide and reach out to Digital Hive to explore our full suite of bespoke data engineering solutions.
From NiagaraFiles to Snowflake OpenFlow
Digital Hive examines the strategic integration of Apache NiFi into the Snowflake ecosystem as OpenFlow, bridging the gap between legacy reliability and modern AI-ready architecture. Read the complete technical breakdown and reach out to us today to see how our expert services and solutions can scale your data operations.
How I Fast-Tracked My Snowflake SnowPro Certification using Generative AI
Here is how I combined structured learning with a personalized AI tutor to bridge the gap and pass the Snowflake SnowPro Core certification exam on my first try.
Pipeline visibility from Airflow to dbt
Pipeline visibility from Airflow to dbt: Tired of using current_timestamp() capturing the wrong time for data lineage? Learn the exact Airflow-dbt method to stamp every data row with the correct logical DAG run timestamp, ensuring traceability.
SnowPro Associate: Platform Certification
Recently I passed the Snowflake Platform certification exam. Here I want to quickly go over my Snowflake journey, what led me to take the exam and some tips regarding preparation for the exam.
Getting Databricks certified leaning on my Snowflake experience
In this blog, I want to have a look at my experience getting DataBricks certified. My newest certificate: Databricks Data Engineer Associate. I’ll cover why I pursued the certificate, how I prepared, and my thoughts on the resources and the exam itself.
My first year at Digital Hive: Growing as a CRM consultant
In February, I began my journey at Digital Hive as a Junior CRM Consultant. Over the past seven months, I’ve been immersed in the world of consultancy, gaining valuable experience and learning key lessons along the way. Read about my first year so far as a junior CRM Consultant at Digital Hive.
DBT Certificate reflections and lessons learned
After my first year of working with dbt at Digital Hive I was encouraged as part of my growth path to take the dbt Analytics Engineering Certification Exam dbt Analytics engineer certification exam | dbt Labs and passed. As with most exams, things are never as they seem. With this blog I want to provide future exam participants with some pointers that could help them improve their preparation process for the exam.
The Future of AI with Salesforce Agentforce
Salesforce Agentforce is a revolutionary new layer on the Salesforce Platform that empowers organizations to build and deploy these autonomous AI agents. Industry leaders like OpenTable, Saks, and Wiley are already using Agentforce to enhance their teams, scale operations, and elevate customer experiences.
Processing both medical and commercial sales data from multiple countries
Our team was tasked with processing both medical and commercial sales data from multiple countries to generate actionable recommendations for sales representatives. This initiative was designed to enable targeted outreach and improve overall sales effectiveness. This project presented several complex challenges that required innovative solutions and seamless collaboration across teams.
Orchestrating Snowflake queries in Airflow
Discover how to orchestrate Snowflake SQL queries using Apache Airflow efficiently.
Can I still automate ingestion if my source data is inconsistent ? - A solution using Snowflake's infer schema
In this blog post we dive into how you can safely handle source data inconsistencies using the Snowflake tool stack. Originally intended to infer schemas from semi-structured or structured files during prototyping, Snowflakes INFER_SCHEMA can easily be implemented in production settings.
dbt build selector: A Practical Guide
In this post, we’ll break down how to use the --select and --exclude options with dbt build and how combining them can supercharge your workflow.
Snowflake external stage limit exceeded
When querying an external stage you should be aware of the following limitations. You may encounter an error 001057, which relates to exceeding file descriptor limits.
From Synapse to Fabric: How Glowi Modernized Its Data Architecture
Glowi explored migrating from Microsoft Synapse to Microsoft Fabric, the new data platform by Microsoft. This should be able to replace their older synapse system. Together with Glowi, we created the basis of their Fabric infrastructure, ensuring that they are future-proof and ready to get started with this new platform. We used our expertise to make sure the setup and infrastructure fits the needs and expectations of Glowi.
Accelerating Clinical Studies with AI
To stay ahead, pharmaceutical companies are turning to AI to streamline clinical study development.
Transforming Digital Performance with Martech Optimization for Solar Assitance
By implementing a strategic Martech optimization plan, Solar Assistance successfully transformed its digital performance.
Marketing Consultancy for Glowi
Glowi sought to enhance its marketing efforts across various brands, requiring versatile and hands-on support to manage numerous tasks.
The road to POC app building with Streamlit
A Python-based tool like Streamlit can be invaluable for quickly building, deploying, and sharing a POC.
The Path to SnowPro Core Certification
After getting certified for SnowPro Core, we want to share the journey one of our data consultants took to pass this certification and help others learn Snowflake.
The Tipping Point for Life Sciences: Embracing the Digital Revolution
The life sciences industry is ahead of a groundbreaking transformation where technology, data, and connectivity come together to enhance patient outcomes, streamline care delivery, and empower healthcare professionals (HCPs). This paradigm shift was one of the focus points in the Veeva Commercial Summit 2024, where life sciences industry leaders explored how recent innovations are going to be revolutionizing the industry. Embracing the digital revolution.
The path to the dbt Developer Certification
Getting certified with dbt will test your knowledge of the framework. Read this blog for some tips and guidance to make sure you are ready.
A Salesforce Health Cloud implementation for CAR-T Treatment
A global leader in healthcare and pharmaceuticals encountered challenges in managing the logistics associated with CAR-T Treatment.
Digital Hive CRM | Transforming Sales Processes in a Multilingual Environment with Microsoft Dynamics 365 at M
We assisted Milexia in making strategic CRM decisions that aligned with their long-term growth and operational goals.
Leverage DBT audit to ensure accurate model generation
Transitioning from legacy ETL tools to DBT? Our blog walks you through using the DBT audit_helper library to ensure data transformation accuracy. Learn how to compare row counts, columns, and more between old and new models. This process provides confidence that your DBT models work as intended, ensuring a smooth, reliable migration.
Empty files not showing up in Snowflake external stage?
Why don’t my empty files show up in my snowflake stage when they do show up in S3 ? Currently there is a bug in snowflake with zero-byte (0b) and one-byte (1b) files. This blog gives you the details and, more importantly, how to fix it.
The Reality Check: How Effective is AI in CRM?
Is AI in CRM really living up to its promise, or are we still far from the dream of truly intelligent systems that work seamlessly with our businesses?
A comparison of Spark pools in Synapse and Fabric
This comparison of Spark pools in Microsoft Synapse and Microsoft Fabric helps you choose the right platform for your compute needs. Synapse offers a cost-effective, flexible solution, while Fabric delivers advanced AI and analytics for a future-ready approach. By breaking down key features and pricing, this guide empowers you to make smart, strategic decisions that align with your project's goals and budget.
How AgentForce Revolutionizes Business with AI
In this post, we’ll dive deep into how AgentForce works, dissect the key components like the Atlas Reasoning Engine, AgentBuilder, and the AgentForce Partner Network, and explore real-world use cases and efficiency gains in areas such as sales, service, and marketing.
Tosca CRM implementation
Leveraging Microsoft Dynamics CRM for Unified Sales and Customer Service at Tosca.
Embracing the Future with Salesforce’s Latest AI Innovations
As a leading CRM consultancy, we are excited to share insights on the newest Salesforce capabilities that are set to revolutionize the way businesses operate. In this blog post, we will explore the integration of generative AI in CRM, the groundbreaking Salesforce Prompt Builder, the innovative Salesforce Co-Pilot, and provide best practices for implementation. Let’s dive in!
Salesforce & IQVIA: Partnership to transform Life Science Engagement
In a groundbreaking move, Salesforce and IQVIA have announced a significant expansion of their global partnership, aimed at accelerating the development of Life Sciences Cloud. This collaboration marks a pivotal moment in the evolution of customer engagement within the life sciences industry.
Migrating multiple legacy systems into a cloud data warehouse at Essent
At Essent NL, the goal to migrate multiple legacy systems into a cloud data warehouse is driven by the organization's strategic move towards cloud technology adoption, compounded by end-of-life considerations for aging technologies. We worked together with Essent to tackle their challenges with a focus on improving the Snowflake platform and standardizing the data transformation practices.
ITZU
Enhance brand communication and create engaging materials for internal and external audiences.
BestBuro
Design and branding, content creation and distribution, and advertising for BestBuro.
BooSt
Created a user-friendly website and seamless webshop, integrating diverse features for optimal user experience for BooSt Body & Skin Lummen.
Embocraft CRM & Stock Management
Embocraft: Enhancing Sales Operations and Stock Management with Salesforce.
Abbvie
A Salesforce Health Cloud implementation within Immunology and Neuroscience at AbbVie.
Belgisch Centrum voor Geleidehonden VZW
Salesforce configuration, low code, and custom development to enable Vets to follow up on the whole breeding cycle for BCG.