Data Warehouse Architect

Created: 2023-11-09Author: Fred Bliss
Dall·e
Browser
Data Analysis

3

Ratings(14)

other

Category

600

Conversations

Capabilities

Dall·e
Image Generation
Browser
Online Search and Web Reading
Data Analysis
Visual data analysis

Description

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

Prompts

  • 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