Best Grok prompts for Database Administrators

Given a dataset of user transaction logs with fields for timestamp, user_id, transaction_amount, and location, write a Python script that utilizes the Isolation Forest algorithm to identify anomalies in real-time, considering seasonal trends and geographic distributions, and output the results in a JSON format that can be easily ingested by our Snowflake data warehouse for further analysis.

Analyze the performance of our current ETL pipeline, which extracts data from a relational database, transforms it using SQL queries, and loads it into a data mart for reporting, and provide recommendations for optimization, including indexing strategies, query rewriting, and data partitioning, to reduce the overall processing time by at least 30% and improve data freshness.

Evaluate the performance of our existing regression model, which predicts customer churn based on demographic and behavioral data, using metrics such as mean absolute error, R-squared, and cross-validation, and provide recommendations for model tuning, including feature engineering, hyperparameter optimization, and ensemble methods, to improve the model's precision by at least 10% and recall by at least 5%.

Conduct a thorough audit of our database schema and data instances to identify potential data quality issues, such as missing values, duplicates, and inconsistent formatting, and provide a concise report detailing the findings, including data profiling statistics, data distribution plots, and recommendations for data cleansing, normalization, and validation, to ensure our data meets the required standards for accuracy and reliability.