sales@dataedo.com +1 609-849-3393 My account
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
DataGrip > Schema comments: How to view and edit trigger comment
Database & Data Modeling Tools 2019-09-17
DataGrip > Exploring schema: How to view stored routine code with JetBrains DataGrip
Database & Data Modeling Tools 2019-09-17
DataGrip > Schema comments: How to view and edit table and column comments with JetBrains DataGrip
Database & Data Modeling Tools 2019-09-17
DataGrip > Exploring schema: How to find table in a database with JetBrains DataGrip
Database & Data Modeling Tools 2019-09-17
DataGrip > Exploring schema: How to view table foreign keys (FK) in JetBrains DataGrip
Database & Data Modeling Tools 2019-09-17
DataGrip > Database diagrams: How to create ER diagram for existing database with DataGrip
Database & Data Modeling Tools 2019-09-17
Toad for IBM DB2 > Schema comments: How to view and edit trigger comment with Toad for Db2
Database & Data Modeling Tools 2019-09-17
Toad for IBM DB2 > Modifying schema: How to create Foreign Key with Toad for IBM DB2
Database & Data Modeling Tools 2019-09-17