---
title: "Analyze Live Data | AWS-Azure DW | via Custom GPT & LLM Apps"
slug: analyze-data-aws-azure-custom-gpt
date_published: 2024-07-27T10:00:00.000Z
original_url: https://www.tigzig.com/post/analyze-data-aws-azure-custom-gpt
source: migrated
processed_at: 2025-01-12T10:00:00.000Z
---

# Analyze Live Data | AWS-Azure DW | via Custom GPT & LLM Apps

Query. Transform. Analyze. Chart. File Ops. Build ML Models.

All in the Natural Language of your choice.

From within Custom GPT (ChatGPT Plus) as well as via externally deployed LLM apps on your intranet or public website.

## Background

Earlier this year, I published a video demonstrating how to build a machine learning model with ChatGPT Plus using natural language. That required an offline data upload.

LinkedIn Post here: [Build ML Model with ChatGPT](https://lnkd.in/gNX9h-_A)

What if we could build ML models and perform analyses by directly connecting to live data warehouses in AWS and Azure?

And not just the final analysis and model building, but also data transformations, modeling dataset creation, table level operations, record insertions, modifications, charts, and cross tabs. Pretty much anything you can do with Python/SQL, but with a simple UI and natural language.

I had to do something similar for a client recently.

## This Series

In this series, I'll show you how to do just that. I'll be working with a prototype data warehouse I set up in AWS (RDS-MySQL) and Azure (MySQL), with tables ranging from just a few records to millions (the largest table has 10 Million records).

This is the kick-off video and a light-hearted introduction to connecting and working with AWS and Azure data warehouses via Custom GPT.

Hope you have as much fun watching this video as I had making it.

[Edit: Video available at my old blog](https://amarharolikar.wixsite.com/tigzig/post/analyze-data-aws-azure-custom-gpt)

---

## Upcoming Episodes

### GPT-LLM Capability Demonstration Videos

* Voice Mode Interaction
* Data Transformations
* Data Analysis
* Table Operations
* Inter-Warehouse Operations: Across AWS & Azure
* Build ML Models
* Limitations, Caveats & Constraints

### How-To Guides

With Codes / Schemas / Github Repos

With special focus on how to use GPTs to get all this done quickly and efficiently:

* FastAPI Server and Endpoints
* Custom GPT: Custom Actions / JSON schemas
* External LLM Apps: Build with Flowise AI. Rapid deploy to internet/intranet
* External LLM Apps: LLM options. Cost-Performance trade-offs
* External LLM Apps: Low-cost custom deployment of Open Source LLMs
* External LLM Apps: API Connections with Flowise Custom Tool and JavaScript functions
* Basic Security: LLM Injection / API Keys / IP Rules / Allowed Domains
* Access Controls and selective access
* Setting up MySQL Server on AWS & Azure, Installing phpMyAdmin for rapid prototyping

<!-- blog-sidebar-related -->
## Related

Tools: [ChatGPT to Any Database](https://www.tigzig.com/rex2-gpt), [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer), [ChatGPT via n8n](https://www.tigzig.com/n8n-automation)

Explore: [Custom GPTs hub](https://www.tigzig.com/gpts-landing), [Database AI Apps](https://www.tigzig.com/database-landing), [APIs and MCP](https://www.tigzig.com/apis)

More posts: [GenAI App | LLM Analytics Assistant: Simplifying Data Transformation & Insights. AWS & Azure MySQL DW Example](https://www.tigzig.com/post/genai-llm-app-analytics-assistant-aws-azure-mysql), [VOICE MODE - Querying & Analyzing Data with Custom GPT AWS - Azure Data Warehouse](https://www.tigzig.com/post/voice-mode-query-analyze-database-aws-azure-custom-gpt), [How to connect Custom GPT to live data warehouses. Implementation Guide](https://www.tigzig.com/post/connect-custom-gpt-to-live-data-warehouses-implementation-guide), [Flowise is my goto platform for GenAI and LLM apps](https://www.tigzig.com/post/flowise-is-my-goto-platform-for-genai-llm-app-development)

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/post/analyze-data-aws-azure-custom-gpt
Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar.
License: https://www.tigzig.com/terms