Grimoire.
Tutorials
Step-by-step guide to connecting Mage Pro SQL blocks with Databricks

The guide provides a step-by-step tutorial for integrating Mage Pro SQL blocks with Databricks to create automated data pipelines. It walks through configuring Databricks credentials in Mage Pro, creating a pipeline, adding a data loader block to fetch API data (using golf rankings as an example), securely storing API keys, creating SQL blocks to transfer data to Databricks, and finally verifying the data through queries in Databricks. The integration aims to streamline data workflows by eliminating manual processes and creating a seamless connection between data sources and Databricks for analysis.
Mar 11, 2025
Azure Blob Storage file transfer using Mage Pro’s dynamic blocks

Companies are always looking for better ways to manage and process their data. In this blog post, we’ll explore a proof of concept developed for a leading beauty brand, demonstrating how Mage Pro can turn complicated data tasks into smooth operations. Whether you’re a data engineer, analyst, or simply interested in data management, this article will offer valuable insights into building effective data pipelines using Mage Pro, Azure Blob Storage, and Snowflake.
Oct 31, 2024
Boost your data pipeline automation with Mage sensor blocks

Sensors continuously evaluate specific conditions, ensuring that downstream blocks execute only when prerequisites are met or within a defined timeframe. By integrating sensor blocks, data workflows become more reliable and resource-efficient, minimizing unnecessary computations and maintaining data consistency. The article covers the fundamentals of sensor blocks, their configuration, practical examples across various platforms, and the benefits they bring to data pipeline management.
Sep 26, 2024
Master data transformation with Mage SQL Blocks

Mage offers a powerful feature, SQL Blocks, a feature that revolutionize SQL-based data operations. SQL Blocks have an intuitive interface for creating transforming and exporting target data, flexible write policies, seamless integration with upstream data sources, and the ability to use raw SQL for complex operations. This tool empowers data engineers to streamline workflows, boost productivity, and tackle complex data transformation challenges, making it suitable for both SQL novices and experienced users.
Sep 25, 2024
Developing business intelligence datasets with Mage part 2: Data transformation and modeling techniques

Prepping data for dimensional models is essential for successful Business Intelligence (BI). From transforming raw data and implementing techniques like Slowly Changing Dimensions (SCD) and snapshots, to ensuring data quality through validation and testing, these steps lay the groundwork for reliable and insightful analytics. Get these steps right, and your dimensional model will be set up to deliver precise, business-focused insights.
Aug 15, 2024
Developing business intelligence datasets with Mage part 1: Mastering medallion architecture

This article explains how to implement medallion architecture using Mage, a data pipeline tool. Medallion architecture organizes data into three layers: Bronze (raw), Silver (cleaned), and Gold (analytics-ready). The tutorial guides readers through setting up Mage, generating sample medical data, and building each layer using SQL transformations, demonstrating how to progress from raw data ingestion to creating analytics-ready datasets.
Jul 31, 2024
Tutorials
Your AI data engineer
© 2025 Mage Technologies, Inc.
Your AI data engineer
© 2025 Mage Technologies, Inc.