sales@dataedo.com +1 704-387-5078
Bart Gawrych - Dataedo Team

Bart Gawrych

Database developer

Categories
Query Toolbox
Snowflake > Schema statistics: Average number of columns per table in Snowflake
Snowflake > Security and users: List users in Snowflake
2018-12-20
Query Toolbox
Amazon Redshift > Foreign keys: List most referenced tables (by FK) in Redshift
PostgreSQL > Foreign keys: List most referenced tables in PostgreSQL database (by FK)
Amazon Redshift > Foreign keys: List tables with most foreign keys in Redshift
PostgreSQL > Foreign keys: List tables with most foreign keys in PostgreSQL database
Amazon Redshift > Foreign keys: List foreign keys with columns in Redshift
Amazon Redshift > Primary keys: How many tables don't have primary keys (with percentage) in Redshif
Amazon Redshift > Primary keys: Find tables without primary keys (PKs) in Redshift
Amazon Redshift > Primary keys: List all primary keys (PKs) and their columns in Redshift
PostgreSQL > Session: Terminate (kill) specific session in PostgreSQL database
PostgreSQL > Number of rows: Number of tables by the number of rows in PostgreSQL database
PostgreSQL > Number of rows: List tables by the number of rows in PostgreSQL database
Amazon Redshift > Number of rows: Number of tables by the number of rows in Redshift
Amazon Redshift > Number of rows: List tables by the number of rows in Redshift
Amazon Redshift > Number of rows: Find empty tables in Redshift
2018-12-18
Query Toolbox
Amazon Redshift > Default values: Summary of default values in Redshift
PostgreSQL > Schema naming: Find most popular column names in PostgreSQL database
PostgreSQL > Environment: How to check the PostgreSQL version
Oracle database > Number of rows: Number of tables by the number of rows in Oracle database
Oracle database > Number of rows: List tables by the number of rows in Oracle database
Oracle database > Number of rows: Find empty tables in Oracle database
IBM Db2 > Number of rows: Number of tables by the number of rows in Db2 database
IBM Db2 > Number of rows: Find empty tables in Db2 database
IBM Db2 > Schema statistics: Average number of columns per table in Db2 database
IBM Db2 > Foreign keys: List all tables refrencing specific table (by FK) in Db2 database
IBM Db2 > Foreign keys: List all tables refrenced by specific table (by FK) in Db2 database
2018-12-17
Query Toolbox
Amazon Redshift > Security and users: List users in Redshift
Amazon Redshift > Schema naming: List columns by name length in Redshift
Amazon Redshift > Schema naming: Get column name length distribution in Redshift
Amazon Redshift > Schema statistics: Average number of columns per table in Redshift
Amazon Redshift > Schema statistics: List tables with the largest number of columns in Redshift
Amazon Redshift > Schema statistics: Find number of columns in Redshift
Amazon Redshift > Databases and schemas: List user created schemas in Redshift
Amazon Redshift > Databases and schemas: List schemas in Redshift
Snowflake > Session: List sessions / active connections in Snowflake
Snowflake > Constraints: Find required (non nullable) columns in Snowflake
2018-12-14
Query Toolbox
Snowflake > Constraints: Check if is column nullable in Snowflake
Amazon Redshift > Constraints: Find required (non nullable) columns in Redshift
PostgreSQL > Constraints: Find required (non nullable) columns in PostgreSQL database
Amazon Redshift > Constraints: Check if is column nullable in Redshift
PostgreSQL > Default values: Summary of default values in PostgreSQL database
PostgreSQL > Foreign keys: List table columns with their foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: List foreign keys with columns in PostgreSQL database
2018-12-13
Query Toolbox
PostgreSQL > Default values: List table default values in PostgreSQL database
PostgreSQL > Foreign keys: List foreign keys in PostgreSQL database
PostgreSQL > Primary keys: List all primary keys (PKs) and their columns in PostgreSQL database
PostgreSQL > Primary keys: List all primary keys (PKs) in PostgreSQL database
2018-12-12
Query Toolbox
PostgreSQL > Security and users: List users in PostgreSQL database
2018-12-11
Query Toolbox
PostgreSQL > Primary keys: How many tables don't have primary keys (with percentage) in PostgreSQL database
PostgreSQL > Primary keys: Find tables without primary keys (PKs) in PostgreSQL database
PostgreSQL > Primary keys: List tables with their primary keys (PKs) in PostgreSQL database
PostgreSQL > Views: List materialized views in PostgreSQL database
IBM Db2 > Views: List objects used by a view in Db2 database
IBM Db2 > Columns: List all columns in specific table in Db2 database
Amazon Redshift > Databases and schemas: List databases on Redshift instance
2018-12-10
Query Toolbox
Amazon Redshift > Views: List tables used by a view in Redshift
Amazon Redshift > Views: List views columns in Redshift
IBM Db2 > Tables: Find recently created tables in Db2 database
2018-12-07
Query Toolbox
Amazon Redshift > Views: List views in Redshift with their scripts
2018-12-06
Query Toolbox
Amazon Redshift > Columns: List all columns in specific table in Redshift
Amazon Redshift > Columns: List table columns in Redshift
IBM Db2 > Tables: List tables in Db2 database schema
2018-12-05
Query Toolbox
Amazon Redshift > Schema statistics: Find number of tables in Redshift
Amazon Redshift > Tables: List tables in Redshift schema
Amazon Redshift > Tables: List tables in Redshift
Amazon Redshift > Searching schema: Find table that DON'T have a column with specific name in Redshift
Amazon Redshift > Searching schema: Find tables with specific column name in Redshift
2018-12-04