Insights
Blog
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.
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.
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.