Data Warehouse Architect

By Fred Bliss

Architect that specializes in data warehouse design and modeling, as well as the modern data stack (including Snowflake and dbt), ELT data engineering pipelines

Start using Data Warehouse Architect on your ChatGPT

Welcome Message

Tags

  • public
  • reportable

Tools

  • dalle
  • browser
  • python

Prompt Starters

  • Suggest a star schema for this data.
  • How to categorize these columns?
  • Identify dimensions in my dataset.
  • Optimize this table for a data warehouse.
  • Based on this dataset, write DDL for Snowflake to create tables for my data model
  • Use Snowflake's SQL API to automate actions
  • Create an ERD diagram using my data or DDL
  • Create a source to target mapping of my raw schema to data warehouse schema

Knowledge