AUTHOR

Pranay Vatsal

Founder & CEO, CelestInfo

Pranay founded CelestInfo in 2023 after more than 11 years as a lead data architect, building enterprise data platforms for financial services, healthcare, IoT and retail companies, including large Snowflake, Azure and AWS deployments. Pranay is a certified Snowflake SnowPro Advanced Architect and still reviews the architecture of every CelestInfo project.

Most of the articles below are about Snowflake and applied AI, with others on data engineering practice, cloud platforms and Talend migration.

Articles by Pranay Vatsal

CLOUD

Microsoft Fabric vs Snowflake: How to Choose in 2026
SNOWFLAKE

Teradata to Snowflake Migration: What Converts Cleanly and What Needs Rework
DATA ENGINEERING

India's DPDP Rules: What They Actually Require From Your Data Platform
DATA ENGINEERING

parquet-java 1.18.0 Can Silently Corrupt Reads: How to Tell If You Are Exposed
SNOWFLAKE

Snowflake Bundle 2026_06: What Changes, and How to Test It Before It Flips
DATA ENGINEERING

Airflow vs Snowflake Tasks: Match the Orchestrator to Blast Radius
AI & ML

Why Your RAG Retrieval Is Bad: Hybrid Search, RRF and Reranking
AI & ML

The EU AI Act Was Not Delayed: Data Engineering Rules for 2026
DATA ENGINEERING

Which Iceberg Catalog Should You Use: Polaris, Unity or Glue?
AI & ML

Token Math at Warehouse Scale: What an LLM Job Actually Costs
AI & ML

The Benchmark Says 96 Percent. Your Repo Gets 47.
AI & ML

LLM Data Residency and Sovereignty: A Provider by Region Matrix
AI & ML

Your Model Is Being Retired or Silently Upgraded. Here's the Runbook.
AI & ML

MCP Stateless Spec Migration: What 2026-07-28 Breaks
AI & ML

What Open-Weight Model Licenses Actually Let You Do in 2026
AI & ML

Porting a Production Workload Between OpenAI and Claude
AI & ML

When Self-Hosting an Open-Weight Model Is Actually Cheaper Than an API
SNOWFLAKE

Snowflake Adaptive Compute vs Sized Warehouses: When to Switch
SNOWFLAKE

Snowflake AI Credits Cost: Not Warehouse Credits, and How to Cap It
AI & ML

Picking the Right Model in Snowflake Cortex: A Cost per Task Table
SNOWFLAKE

Snowflake DCM Projects Just Went GA: Do You Still Need Terraform?
SNOWFLAKE

Snowflake MCP Server Permissions: The Least-Privilege Setup
SNOWFLAKE

Snowflake Semantic Views vs dbt Semantic Layer: Where Metrics Live
CLOUD

SQL Server CDC to Snowflake: Openflow vs ADF vs a Paid Connector
TALEND

Talend 7.3 Is Out of Support: Four Exit Paths, Costed Honestly
AI & ML

Building a Data Platform from Scratch: A Step-by-Step Guide for 2026
CLOUD

Data Lakehouse Architecture: Building for 2026 and Beyond
SNOWFLAKE

Snowflake Cortex AI: Complete Guide to Built-In Intelligence
SNOWFLAKE

Snowflake Dynamic Tables: When to Use Them vs Streams/Tasks
SNOWFLAKE

Snowpipe vs Snowpipe Streaming: Real-Time Ingestion
GOVERNANCE

Snowflake Cost Optimization: 12 Things That Actually Move the Needle
DATA ENGINEERING

Monitoring Data Pipelines: What to Track
SNOWFLAKE

Snowflake External Tables: Query Your Data Lake
SNOWFLAKE

Working with JSON, Parquet & Avro in Snowflake
SNOWFLAKE

CDC in Snowflake Using Streams and Tasks
SNOWFLAKE

Snowflake Zero-Copy Cloning: How It Works
SNOWFLAKE

Snowflake Time Travel and Fail-safe Explained
SNOWFLAKE

Snowflake Warehouse Sizing: Pick the Right Size
SNOWFLAKE

Star Schema in Snowflake: Why It Still Works
SNOWFLAKE

Snowflake Data Sharing Across Cloud Providers (AWS to Azure) Using Listings
SNOWFLAKE

Snowflake AI SQL
SNOWFLAKE

Exploring Snowflake Cortex
SNOWFLAKE

Loading Semi-Structured Data from AWS S3

Ready? Let's Talk!

Get expert insights and answers tailored to your business requirements and transformation.