My account Book a demo
Bart Gawrych - Dataedo Team

Bart Gawrych

Database developer

Categories
Query Toolbox
Snowflake > Schema compare: Compare tables and columns in two schemas in Snowflake
Snowflake > Schema compare: Compare tables and columns in two databases in Snowflake
Snowflake > Data size: List 10 largest tables in Snowflake
Snowflake > Data size: List tables by their size in Snowflake
Snowflake > Constraints: List all table constraints (PK, FK, Unique, Default) in Snowflake
Snowflake > Default values: Compare default values of different columns with the same name in Snowflake database
2023-01-05
Query Toolbox
Vertica > Primary keys: Find tables without primary keys (PKs) in Vertica database
Vertica > Primary keys: How many tables don't have primary keys (with percentage) in Vertica database
Vertica > Foreign keys: Find tables that are not referenced by the foreign keys in Vertica database
Vertica > Foreign keys: Find tables without relationships - Loner Tables - in Vertica database
Vertica > Default values: Compare default values of different columns with the same name in Vertica database
Vertica > Constraints: Check if is column nullable in Vertica database
Vertica > Data types: Find all numeric columns in Vertica database
Vertica > Data types: Find all string (character) columns in Vertica database
Vertica > Data types: Find all date and time columns in Vertica database
Vertica > Searching schema: Find a table by the name in Vertica database
Vertica > Searching schema: Find tables with names with specific prefix in Vertica database
Vertica > Searching schema: Find tables with names with specific suffix in Vertica database
Vertica > Searching schema: Find tables with specific word in name in Vertica database
Vertica > Searching schema: Find tables with digits in names in Vertica database
Vertica > Searching schema: Find tables with specific column name in Vertica database
Vertica > Searching schema: Find table that DON'T have a column with specific name in Vertica database
Vertica > Schema statistics: Find number of tables in Vertica database
Vertica > Schema statistics: Find number of columns in Vertica database
Vertica > Schema naming: Get column name length distribution in Vertica database
Vertica > Security and users: List admins in Vertica
Vertica > Session: Find last query executed by specific session in Vertica database
Vertica > Session: Terminate (kill) specific session in Vertica database
Vertica > Session: Find last query executed by specific user in Vertica
Vertica > Session: Find queries executed in specific time range in MariaDB database
Vertica > Data size: List 10 largest tables in Vertica database
Vertica > Data usage: Find the time when table was last accessed in Vertica database
Vertica > Schema compare: Compare tables and columns in two schemas in Vertica database
Vertica > Data usage: Find tables not accessed for past n months in Vertica database
Vertica > Primary keys: List all primary keys (PKs) and their columns in Vertica database
Vertica > Foreign keys: List all tables refrenced by specific table (by FK) in Vertica database
Vertica > Foreign keys: List all tables refrencing specific table (by FK) in Vertica database
Vertica > Session: List sessions / active connections in Vertica database
Vertica > Foreign keys: List most referenced tables in Vertica database (by FK)
Vertica > Schema naming: List columns by name length in Vertica database
Vertica > Foreign keys: List foreign keys with columns in Vertica database
Vertica > Data size: List tables by their size in Vertica database
Vertica > Schema statistics: List tables with the largest number of columns in Vertica database
Vertica > Tables: List projections in Vertica database
Vertica > Default values: List table default values in Vertica database
Vertica > Foreign keys: List table columns with their foreign keys in Vertica database
Vertica > Views: List views in Vertica database
Vertica > Views: List views in Vertica database with their scripts
Vertica > Views: List views columns in Vertica
Vertica > Foreign keys: List tables with most relationships in Vertica database
Vertica > Foreign keys: Find tables without foreign keys in Vertica database
Vertica > Foreign keys: Loner Ratio - how many tables have no relationships in Vertica database
Vertica > Foreign keys: List tables with most foreign keys in Vertica database
Vertica > Unique keys: List unique keys and their columns in Vertica database
Vertica > Default values: Summary of default values in Vertica database
Vertica > Data types: Find most used data type in Vertica database
Vertica > Functions and stored procedures: List user defined functions (UDFs) in Vertica database
Vertica > Schema naming: Find most popular column names in Vertica database
Vertica > Security and users: List users in Vertica database
Vertica > Number of rows: Number of tables by the number of rows in Vertica database
Teradata > Primary keys: List tables with their primary keys (PKs) in Teradata database
Teradata > Foreign keys: List foreign keys in Teradata database
Teradata > Foreign keys: List foreign keys with columns in Teradata database
Teradata > Foreign keys: List table columns with their foreign keys in Teradata database
Teradata > Foreign keys: List all tables refrenced by specific table (by FK) in Teradata database
Teradata > Foreign keys: List all tables refrencing specific table (by FK) in Teradata database
Teradata > Foreign keys: List tables with most foreign keys in Teradata database
Teradata > Unique keys: List unique keys and indexes in Teradata database
Teradata > Check constraints: List table check constraints in Teradata database
Teradata > Default values: List table default values in Teradata database
Teradata > Default values: Summary of default values in Teradata database
Teradata > Constraints: List all table constraints (PK, UK, FK, Check & Default) in Teradata database
Teradata > Indexes: List table indexes in Teradata database
Teradata > Data types: Find most used data type in Teradata database
Teradata > Triggers: List triggers in Teradata database
Teradata > Triggers: List triggers by table name in Teradata database
Teradata > Functions and stored procedures: List user defined functions (UDFs) in Teradata database
Teradata > Schema statistics: List tables with the largest number of columns in Teradata database
Teradata > Schema naming: List columns by name length in Teradata database
Teradata > Session: List sessions / active connections in Teradata database
Teradata > Session: Find last query executed by specific user in Teradata database
Teradata > Tables: List temporal tables in Teradata database
Teradata > Foreign keys: List most referenced tables (by FK) in Teradata
Teradata > Foreign keys: List tables with most relationships in Teradata
Teradata > Foreign keys: Find tables without foreign keys in Teradata database
Teradata > Foreign keys: Find tables without relationships - Loner Tables - in Teradata database
Teradata > Foreign keys: Loner Ratio - how many tables have no relationships in Teradata database
Teradata > Functions and stored procedures: List stored procedures in Teradata database
Teradata > Functions and stored procedures: List stored procedure parameters in Teradata database
Teradata > Security and users: List users in Teradata database
Teradata > Number of rows: List tables by the number of rows in Teradata database
Teradata > Data size: List tables by their size in Teradata database
Teradata > Data size: List idexes by their size in Teradata database
Teradata > Number of rows: Number of tables by the number of rows in Teradata database
Teradata > Columns: List all table columns with details (PKs, UKs, FKs, Default, Checks, Computed, etc.) in Teradata database
Teradata > Schema compare: Compare tables and columns in two databases in Teradata database
Teradata > Data types: Find all semi-structured data columns in Teradata database
Teradata > Primary keys: List all primary keys (PKs) and their columns in Teradata database
Teradata > Primary keys: Find tables without primary keys (PKs) in Teradata database
Teradata > Primary keys: How many tables don't have primary keys (with percentage) in Teradata database
Teradata > Constraints: Find required (non nullable) columns in Teradata database
Teradata > Data types: Find large object (LOB) data type columns in Teradata database
Teradata > Data types: Find tables with large object (LOB) data type columns in Teradata database
Teradata > Searching schema: Find table that DON'T have a column with specific name in Teradata database
Teradata > Schema statistics: Find number of columns in Teradata database
Teradata > Session: Find last query executed by specific session in Teradata database
Teradata > Session: Terminate (kill) specific session on a server
Teradata > Tables: Find recently modified tables in Teradata database
Teradata > Foreign keys: Find tables that are not referenced by the foreign keys in Teradata database
Teradata > Default values: Compare default values of different columns with the same name in Teradata database
Teradata > Data types: Find all numeric columns in Teradata database
Teradata > Data types: Find all string (character) columns in Teradata database
Teradata > Data types: Find all date and time columns in Teradata database
Teradata > Data types: Find all XML data columns in Teradata database
Teradata > Data types: Find all JSON data columns in Teradata database
Teradata > Session: Find queries executed in specific time range in Teradata database
Teradata > Data usage: Find the time when table was last accessed in Teradata database
Teradata > Data usage: Find tables not accessed for past n months in Teradata database
Teradata > Number of rows: Find empty tables in Teradata database
Teradata > Schema naming: Get column name length distribution in Teradata database
Teradata > Constraints: Check if is column nullable in Teradata database
2019-10-31
Query Toolbox
MySQL > Schema compare: Compare tables and columns in two schemas in MariaDB database
MySQL > Columns: List all table columns with details (PKs, UKs, FKs, Default, Computed, etc.) in MySQL database
2019-09-23
Query Toolbox
Vertica > Databases and schemas: List schemas in Vertica database
Vertica > Databases and schemas: List user created schemas in Vertica database
Vertica > Number of rows: Find empty tables in Vertica database
Vertica > Number of rows: List tables by the number of rows in Vertica
Vertica > Columns: List all columns in specific table in Vertica database
Vertica > Columns: List table columns in Vertica database
Vertica > Tables: Find recently created tables in Vertica database
Vertica > Tables: List tables in Vertica database schema
Vertica > Tables: List tables in Vertica database
2019-09-17
Query Toolbox
IBM Db2 > Functions and stored procedures: List stored procedure parameters in Db2 database
IBM Db2 > Dependencies: Find objects used by specific stored procedure in Db2 database
IBM Db2 > Dependencies: Find objects used by specific function in Db2 database
IBM Db2 > Dependencies: Find tables and views used by specific view in Db2 database
Snowflake > Foreign keys: Loner Ratio - how many tables have no relationships in Snowflake
Snowflake > Foreign keys: List foreign keys in Snowflake
Snowflake > Foreign keys: Find tables without relationships - Loner Tables - in Snowflake
Snowflake > Foreign keys: Find tables that are not referenced by the foreign keys in Snowflake
Snowflake > Foreign keys: Find tables without foreign keys in Snowflake
Snowflake > Foreign keys: List tables with most foreign keys in Snowflake
Snowflake > Foreign keys: List tables with most relationships in Snowflake
Snowflake > Foreign keys: List most referenced tables (by FK) in Snowflake
Snowflake > Foreign keys: List all tables referencing a specific table (by FK) in Snowflake
Snowflake > Foreign keys: List all tables refrenced by specific table (by FK) in Snowflake
Oracle database > Dependencies: List tables used by Materialized Views (MV dependencies) in Oracle database
Oracle database > Dependencies: Find tables that are not used by any other object
Oracle database > Dependencies: Find where specific stored procedure is used in Oracle database
Oracle database > Dependencies: Find where specific function is used in Oracle database
Oracle database > Dependencies: Find where specific table or view is used in Oracle database
Oracle database > Dependencies: List objects that use specific object in Oracle database
Oracle database > Jobs/events: List scheduled jobs in Oracle database
Oracle database > Indexes: List unique indexes in Oracle database
Oracle database > Indexes: List indexes on the table in Oracle database
Oracle database > Environment: How to find operating system (OS) that Oracle database runs on
2019-06-10
Query Toolbox
Oracle database > Dependencies: Find objects used by specific stored procedure in Oracle database
Oracle database > Dependencies: Find objects used by specific function in Oracle database
Oracle database > Dependencies: Find tables and views used by specific view in Oracle database
Oracle database > Functions and stored procedures: List stored procedure arguments in Oracle database
Oracle database > Functions and stored procedures: List user defined functions (UDFs) in Oracle database
Oracle database > Functions and stored procedures: List stored procedures in Oracle database
Oracle database > Columns: List all computed columns in Oracle database
Oracle database > Data types: Find all JSON data columns in Oracle database
Oracle database > Data types: Find all XML data columns in Oracle database
Oracle database > Data types: Find all spatial data columns in Oracle database
Oracle database > Data types: Find all date and time columns in Oracle database
Oracle database > Data types: Find all character (string) columns in Oracle database
Oracle database > Data types: Find all numeric columns in Oracle database
2019-06-04
Query Toolbox
Oracle database > Schema compare: Compare tables and columns in two schemas in Oracle database
IBM Db2 > Schema compare: Compare tables and columns in two schemas in Db2 database
PostgreSQL > Schema compare: Compare tables and columns in two schemas in PostgreSQL database
Amazon Redshift > Schema compare: Compare tables and columns in two schemas in Redshift
Amazon Redshift > Data size: List tables by their size in Redshift
Amazon Redshift > Environment: How to find operating system (OS) that server runs on
Amazon Redshift > Environment: How to check the Redshift version
Amazon Redshift > Session: Find last query executed by specific user in Redshift
Amazon Redshift > Session: Find queries executed in specific time range in Redshift
Amazon Redshift > Session: Terminate (kill) specific session on a server
Amazon Redshift > Session: Find last query executed by specific session in Redshift
Amazon Redshift > Security and users: List admins in Redshift
PostgreSQL > Data types: Find most used data type in PostgreSQL database
Amazon Redshift > Data types: Find most used data type in Redshift
PostgreSQL > Data size: List tables that take up 50% of space in PostgreSQL database
PostgreSQL > Functions and stored procedures: List stored procedure parameters in PostgreSQL database
PostgreSQL > Functions and stored procedures: List stored procedures in PostgreSQL database
PostgreSQL > Functions and stored procedures: List user defined functions (UDFs) in PostgreSQL database
PostgreSQL > Check constraints: List table check constraints in PostgreSQL database
PostgreSQL > Check constraints: List all check constraints in PostgreSQL database
Amazon Redshift > Data types: Find all date and time columns in Redshift
Amazon Redshift > Data types: Find all numeric columns in Redshift
Amazon Redshift > Foreign keys: Loner Ratio - how many tables have no relationships in Redshift
Amazon Redshift > Foreign keys: Find tables without relationships - Loner Tables - in Redshift
Amazon Redshift > Foreign keys: Find tables that are not referenced by the foreign keys in Redshift
Amazon Redshift > Foreign keys: Find tables without foreign keys in Redshift
Amazon Redshift > Foreign keys: List all tables refrencing specific table (by FK) in Redshift
Amazon Redshift > Foreign keys: List all tables refrenced by specific table (by FK) in Redshift
PostgreSQL > Foreign keys: Loner Ratio - how many tables have no relationships in PostgreSQL database
PostgreSQL > Foreign keys: Find tables without relationships - Loner Tables - in PostgreSQL database
PostgreSQL > Foreign keys: Find tables that are not referenced by the foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: Find tables without foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: List all tables refrencing specific table (by FK) in PostgreSQL database
PostgreSQL > Foreign keys: List all tables refrenced by specific table (by FK) in PostgreSQL database
PostgreSQL > Environment: How to find operating system (OS) that PostgreSQL server runs on
PostgreSQL > Triggers: List table triggers in PostgreSQL database
PostgreSQL > Data types: Find all enum columns in PostgreSQL database
PostgreSQL > Data types: Find all semi-structured data columns in PostgreSQL
PostgreSQL > Data types: Find all JSON data columns in PostgreSQL database
PostgreSQL > Data types: Find all XML data columns in PostgreSQL database
PostgreSQL > Data types: Find all geometric data columns in PostgreSQL database
PostgreSQL > Data types: Find all date and time columns in PostgreSQL database
PostgreSQL > Data types: Find all string (character) columns in PostgreSQL database
2019-06-03
Query Toolbox
PostgreSQL > Data types: Find all numeric columns in PostgreSQL database
Snowflake > Data types: Find all semi-structured data columns in Snowflake
Snowflake > Data types: Find all string (character) columns in Snowflake database
Snowflake > Data usage: Find tables not accessed for past n months in Snowflake
IBM Db2 > Functions and stored procedures: List stored procedures in Db2 database
IBM Db2 > Functions and stored procedures: List user defined routines in Db2 database
2019-04-30
Query Toolbox
Snowflake > Data types: Find all date and time columns in Snowflake
Oracle database > Tables: Find recently modified tables in Oracle database
Snowflake > Tables: Find recently modified tables in Snowflake
2019-04-23
Query Toolbox
PostgreSQL > Foreign keys: List tables with most relationships in PostgreSQL database
Amazon Redshift > Foreign keys: List tables with most relationships in Redshift
2019-04-09
Query Toolbox
IBM Db2 > Indexes: List all indexes in the Db2 database
IBM Db2 > Unique keys: List unique keys and indexes in DB2 database
IBM Db2 > Columns: List all computed columns in Db2 database
IBM Db2 > Tables: Find recently modified tables in Db2 database
SQL Server > Data usage: Find tables not accessed for past n months in SQL Server database
SQL Server > Data usage: Find the time when table was last accessed in SQL Server database
Azure SQL Database > Schema compare: Compare tables and columns in two schemas in Azure SQL schemas
SQL Server > Schema compare: Compare tables and columns in two schemas in SQL Server schemas
Azure SQL Database > Functions and stored procedures: List stored procedures in Azure SQL database
SQL Server > Functions and stored procedures: List stored procedures in SQL Server database
Azure SQL Database > Data size: List tables by the size of their indexes in Azure SQL
SQL Server > Data size: List tables by the size of their indexes in SQL Server
Azure SQL Database > Data size: List idexes by their size in Azure SQL
SQL Server > Data size: List idexes by their size in SQL Server
Azure SQL Database > Security and users: List users in Azure SQL database
SQL Server > Security and users: List users in SQL Server database
SQL Server > Security and users: List logins on SQL Server instance
SQL Server > Security and users: List admins on SQL Server
Azure SQL Database > Dependencies: List tables used by Indexed (Materialized) Views
SQL Server > Dependencies: List tables used by Indexed (Materialized) Views
Azure SQL Database > Dependencies: Find where specific stored procedure is used in Azure SQL database
Azure SQL Database > Dependencies: Find where specific function is used in Azure SQL database
Azure SQL Database > Dependencies: Find where specific table or view is used in Azure SQL Database
Azure SQL Database > Dependencies: List objects that use specific object in Azure SQL database
Azure SQL Database > Data types: Find all XML data columns in Azure SQL database
Azure SQL Database > Constraints: Check if is column nullable in Azure SQL database
Azure SQL Database > Default values: Summary of default constraints in Azure SQL database
Azure SQL Database > Views: List indexed (materialized) views in Azure SQL database
Azure SQL Database > Views: List tables used by a view in Azure SQL database
2019-04-01
Query Toolbox
Snowflake > Data types: Find all numeric columns in Snowflake
SQL Server > Dependencies: Find where specific stored procedure is used in SQL Server database
SQL Server > Dependencies: Find where specific function is used in SQL Server database
SQL Server > Dependencies: Find where specific table or view is used in SQL Server database
SQL Server > Dependencies: List objects that use specific object in SQL Server database
2019-03-14