Best Gemini prompts for Database Administrators

Analyze the execution plan of a slow-running query on a large dataset in Snowflake, identifying the bottlenecks and providing recommendations for improvement, including index creation, partitioning, and rewriting the query to reduce join operations, and then generate a revised query that incorporates these optimizations and estimate the resulting performance gain.

Develop a comprehensive data quality assessment framework for a regression model, including checks for missing values, outliers, and data distribution skewness, and then apply this framework to a sample dataset, generating a report that highlights data quality issues and provides recommendations for data cleaning and preprocessing, including data transformation and feature engineering techniques.

Design an optimized ETL pipeline for loading data from a relational database into a cloud-based data warehouse, including data extraction, transformation, and loading, and then analyze the pipeline's performance, identifying bottlenecks and areas for improvement, such as data partitioning, parallel processing, and data compression, and generate a revised pipeline design that incorporates these optimizations and estimate the resulting performance gain.

Generate a statistical summary report for a large dataset, including calculations of mean, median, mode, and standard deviation, as well as data visualization using Tableau, and then analyze the report to identify trends and patterns, including correlations and anomalies, and provide recommendations for further analysis and investigation, including predictive modeling and data mining techniques.