WhereScape RED has been helping data teams automate warehouse development for more than two decades. We launched RED in 2003, three years after WhereScape was founded in Auckland way back in the year 2000, with a goal that still feels familiar today: remove repetitive...
Uncategorized
AI Can Write SQL But It Still Can’t Run Your Data Estate
AI can generate SQL remarkably well. Give a modern AI model a schema, explain the desired output and within a few seconds it can produce joins, transformations, window functions, stored procedures and increasingly sophisticated data pipelines. For data engineers who...
Data Validation for AI: How to Build Trust Before Your Models Use the Data
Data validation for AI verifies that data meets defined quality requirements before AI systems rely on it. That sounds straightforward but the problem becomes more complicated once AI moves beyond a contained experiment. Enterprise models and agents may consume...
Data Governance in Practice: How to Build Lineage, Documentation and Trust Into Data Delivery
Before we begin, it’s important to set things straight: by ‘data governance’, we mean the set of policies, processes, responsibilities and technical controls that determine how an organization understands, manages and trusts its data. For a data team, you will find...
Medallion Architecture for AI Readiness: 7 Lessons From Four Data Architects
Our take: medallion architecture is a shared vocabulary, not a specification. It helps a data team, a governance team, and an executive board hold the same picture in their heads; which is genuinely valuable. But the things that decide whether an AI agent gives...
AI Readiness in Financial Services: How to Build a Governed Foundation for Explainable AI
We believe AI readiness in financial services must begin with governed data. Banks and insurers may experiment with new models quickly but the data beneath them must remain accurate, traceable and understandable for years. When an AI system produces an answer about...
AI Readiness for K-12 Data Teams: Seven Lessons From Monterey Peninsula Unified School District
Our take: AI readiness for K-12 data teams needs to start with trusted data. It doesn’t start with selecting an LLM, it doesn’t start with deploying a chatbot and it certainly doesn’t start by giving an AI agent unrestricted access to every table in a student...
Data Modeling for AI Readiness: A Practical Guide – From Source Discovery to Deployment
Data modeling is where AI readiness becomes concrete. AI systems need trusted context, not simply more data. They need clear definitions, understood relationships, known quality constraints and traceable transformations. Without those foundations, an AI agent may...
How-to: Migrate a Data Warehouse to the Cloud – A 10-Step Guide
To migrate data warehouse workloads successfully, start with discovery and dependency mapping. Then design the target, move in waves, validate parity and finally optimize continuously. Sounds simple on the surface, right? But the difficulty lies in everything...








