My account
Book a demo
Search
Product
Key Features
Data Catalog
Catalog all your data, reports, and collaborate with your data community.
Data Lineage
Create a map of your data flow with automated lineage on object and column level.
Data Quality & Profiling
Improve data quality and increase trust in your data with data profiling, lineage & more.
Dataedo AI
Create auto object descriptions and get help from AI chat in finding tables & writing queries.
Business Glossary
Build and share a universal glossary of business terms, policies and rules.
Data Classification
Find and tag sensitive data in your databases to comply with data protection regulation.
See all features →
More Features
Data Community
Domains
Reference Data Management
StewardHub
Schema Change Tracking
Workflows
Technologies
Connectors
SQL Server
Snowflake
Power Bi
Tableau
Qlik Sense
soon
Databricks
Microsoft Fabric
Azure
AWS
Oracle
All Connectors →
Learn More
Metadata Scanning
Solutions
By Use Case
Data Governance
Data Quality
Selft-Service Analytics
Data Protection
Business Intelligence
Data Warehousing
Metadata Management
All Use Cases →
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
Retail
Energy & Utilities
All Industries →
Pricing
Resources
Learn About Dataedo
Documentation
Roadmap
Tutorial Videos
Dataedo Bootcamp
Downloads
Learn About Data
Blog
Webinars
Tutorials
Knowledge Base
Data Events
After Hours
Data Cartoons
Cartoon Ebooks
About us
About us
Why Dataedo
Our Customers
Our Partners
Careers
Contact Us
Book a demo
Try Dataedo
Database Data Dictionary Query Toolbox
Amazon Redshift Data Dictionary Query Toolbox
Databases and schemas
List databases on Redshift instance
List schemas in Redshift
List user created schemas in Redshift
Tables
List tables in Redshift
List tables in Redshift schema
Columns
List table columns in Redshift
List all columns in specific table in Redshift
Views
List views in Redshift with their scripts
List views columns in Redshift
List tables used by a view in Redshift
Primary keys
List all primary keys (PKs) and their columns in Redshift
Find tables without primary keys (PKs) in Redshift
How many tables don't have primary keys (with percentage) in Redshif
Foreign keys
List foreign keys with columns in Redshift
List all tables refrenced by specific table (by FK) in Redshift
List all tables refrencing specific table (by FK) in Redshift
List tables with most foreign keys in Redshift
List most referenced tables (by FK) in Redshift
List tables with most relationships in Redshift
Find tables without foreign keys in Redshift
Find tables that are not referenced by the foreign keys in Redshift
Find tables without relationships - Loner Tables - in Redshift
Loner Ratio - how many tables have no relationships in Redshift
Default values
List table default values in Redshift
Summary of default values in Redshift
Constraints
Find required (non nullable) columns in Redshift
Check if is column nullable in Redshift
Data types
Find most used data type in Redshift
Find all numeric columns in Redshift
Find all date and time columns in Redshift
Searching schema
Find a table by the name in Redshift
Find tables with names with specific prefix in Redshift
Find tables with names with specific suffix in Redshift
Find tables with specific word in name in Redshift
Find tables with digits in names in Redshift
Find tables with specific column name in Redshift
Find table that DON'T have a column with specific name in Redshift
Schema statistics
Find number of tables in Redshift
Find number of columns in Redshift
List tables with the largest number of columns in Redshift
Average number of columns per table in Redshift
Schema naming
Find most popular column names in Redshift
Get column name length distribution in Redshift
List columns by name length in Redshift
Security and users
List users in Redshift
List admins in Redshift
Session
Find last query executed by specific user in Redshift
Find queries executed in specific time range in Redshift
List sessions / active connections in Redshift
Find last query executed by specific session in Redshift
Terminate (kill) specific session on a server
Environment
How to check the Redshift version
How to find operating system (OS) that server runs on
Number of rows
List tables by the number of rows in Redshift
Find empty tables in Redshift
Number of tables by the number of rows in Redshift
Data size
List tables by their size in Redshift
Schema compare
Compare tables and columns in two schemas in Redshift