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

Bart Gawrych

Database developer

Categories
Query Toolbox
Amazon Redshift > Searching schema: Find tables with digits in names in Redshift
Amazon Redshift > Searching schema: Find tables with names with specific suffix in Redshift
Amazon Redshift > Searching schema: Find tables with names with specific prefix in Redshift
Amazon Redshift > Searching schema: Find a table by the name in Redshift
2018-12-03
Query Toolbox
PostgreSQL > Views: List tables used by a view in PostgreSQL database
Snowflake > Default values: Summary of default values in Snowflake
Snowflake > Primary keys: List tables with their primary keys (PKs) in Snowflake
Snowflake > Primary keys: List all primary keys (PKs) in Snowflake
2018-11-30
Query Toolbox
Snowflake > Environment: How to check the Snowflake version
Snowflake > Unique keys: List unique keys and indexes in Snowflake
Snowflake > Primary keys: How many tables don't have primary keys (with percentage) in Snowflake
Snowflake > Primary keys: Find tables without primary keys (PKs) in Snowflake
Snowflake > Columns: List all columns in specific table in Snowflake
2018-11-28
Query Toolbox
Snowflake > Databases and schemas: List user created schemas in Snowflake
Snowflake > Tables: List tables in Snowflake schema
2018-11-27
Query Toolbox
Snowflake > Views: List views columns in Snowflake
2018-11-23
Query Toolbox
Snowflake > Tables: Find recently created tables in Snowflake
2018-11-22
Query Toolbox
Snowflake > Databases and schemas: List schemas in Snowflake
2018-11-20
Query Toolbox
PostgreSQL > Tables: List tables in PostgreSQL database schema
2018-11-14
Query Toolbox
PostgreSQL > Constraints: Check if is column nullable in PostgreSQL database
PostgreSQL > Schema naming: Get column name length distribution in PostgreSQL database
PostgreSQL > Columns: List all columns in specific table in PostgreSQL database
2018-11-13
Query Toolbox
PostgreSQL > Views: List views columns in PostgreSQL
PostgreSQL > Views: List views in PostgreSQL database with their scripts
PostgreSQL > Views: List views in PostgreSQL database
PostgreSQL > Databases and schemas: List user created schemas in PostgreSQL database
2018-11-08
Query Toolbox
PostgreSQL > Columns: List table columns in PostgreSQL database
PostgreSQL > Databases and schemas: List schemas in PostgreSQL database
PostgreSQL > Databases and schemas: List databases on PostgreSQL instance
2018-11-07
Query Toolbox
PostgreSQL > Number of rows: Find empty tables in PostgreSQL database
PostgreSQL > Data size: List tables by their size in PostgreSQL database
PostgreSQL > Data size: List tables by the size of data and indexes in PostgreSQL database
PostgreSQL > Data size: List 10 largest tables in PostgreSQL database
PostgreSQL > Tables: List tables in PostgreSQL database
PostgreSQL > Schema naming: List columns by name length in PostgreSQL database
PostgreSQL > Schema statistics: Average number of columns per table in PostgreSQL database
PostgreSQL > Schema statistics: List tables with the largest number of columns in PostgreSQL database
PostgreSQL > Schema statistics: Find number of columns in PostgreSQL database
PostgreSQL > Schema statistics: Find number of tables in PostgreSQL database
PostgreSQL > Searching schema: Find table that DON'T have a column with specific name in PostgreSQL database
PostgreSQL > Searching schema: Find tables with specific column name in PostgreSQL database
PostgreSQL > Searching schema: Find tables with digits in names in PostgreSQL database
PostgreSQL > Searching schema: Find tables with specific word in name in PostgreSQL database
PostgreSQL > Searching schema: Find tables with names with specific suffix in PostgreSQL database
PostgreSQL > Searching schema: Find tables with names with specific prefix in PostgreSQL database
PostgreSQL > Searching schema: Find a table by the name in PostgreSQL database
2018-11-05