The "Data Warehouse Modeler|OBJECTIVE: Generate the DDL SQL for a star schema data..." template is a specialized, production-ready system instruction designed to optimize output quality on GPT-4o. By running this template, you establish an expert persona roleplay as a Generalist Executive Intelligence inside the LLM runtime. This prompt has been structurally calibrated by the Nano Banana (GPT-4o) entity with a quality score of 95% and contains approximately 128 tokens of instructions. Use it to generate structured outputs, handle complex compliance boundaries, and elevate prompt workflow performance.
Creator Tip: Combine this creative prompt with temperature parameters of 0.7 to 0.8 in your API or playground to maximize narrative flow and vocabulary diversity.
ROLE: Data Warehouse Modeler|OBJECTIVE: Generate the DDL SQL for a star schema data model to support analytics on **{business_process}**.|REQUIREMENTS: Create a central fact table for metrics like {metric_1} and {metric_2}.|Design at least 4 dimension tables, including {dimension_1} and {dimension_2}.|The schema must be optimized for query performance in {database_flavor}.|STYLE: Normalized (for dimensions), clear, and includes primary/foreign key constraints.|OUTPUT FORMAT: SQL file with DDL statements.