{"repo":"HariSekhon/SQL-scripts","free":true,"listed":false,"github":"https://github.com/HariSekhon/SQL-scripts","clone":"git clone https://github.com/HariSekhon/SQL-scripts.git","description":"100+ SQL Scripts - PostgreSQL, MySQL, Oracle, Google BigQuery, MariaDB, AWS Athena. DBA, Analytics, DevOps, performance engineering. Google BigQuery ML machine learning classification.","language":"Shell","stars":487,"topics":["sql","postgresql","postgres","mysql","mariadb","aws","gcp","athena","aws-athena","bigquery"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQL Scripts git.io/SQL Useful SQL scripts, split from DevOps Bash tools, for which this is now a submodule. Hari Sekhon Cloud & Big Data Contractor, United Kingdom (you're welcome to connect with me on LinkedIn) Inventory DevOps / DBA - aws athena cloudtrail ddl.sql - AWS Athena DDL to setup up integration to query CloudTrail logs from Athena - bigquery .sql - Google BigQuery scripts: - bigquery billing .sql - billing queries for GCP usage eg. highest cost services, most used GCP products, recent charges etc. - bigquery info .sql - information schema queries for datasets, tables, columns, partitioning, clustering etc. - mysql .sql : - MySQL / MariaDB queries for DBA investigating + performance tuning - mysql info.sql - summary overview, useful to debug your mysql.user table auth effects - (shows intended USER() vs actual CURRENT USER() ) - tested on MySQL 5.5, 5.6, 5.7, 8.0 and MariaDB 5.5, 10.x - postgres .sql : - PostgreSQL queries for DBA investigating + performance tuning - postgres info.sql - big summary overview, recommend you start here - tested on PostgreSQL 8.4, 9.x, 10.x, 11.x, 12.x, 13.x - oracle .sql : - Oracle queries for DBA investigating - tested on Oracle 9i, 10g, 11g, 19c Analytics - bigquery .sql - Google BigQuery scripts: - bigquery billing .sql - billing queries for GCP usage eg. highest cost services, most used GCP products, recent charges etc. - bigquery info .sql - information schema queries for datasets, tables, columns, partitioning, clustering etc. -","default_branch":null,"files":null,"tree":[],"storefront":"/r/HariSekhon","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/HariSekhon/SQL-scripts/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}