Supported versions
TBD
Supported schema elements and metadata
- Tables
- Columns
- Data type
- Nullable
- Default value
- Primary keys
- Columns
- Foreign keys
- Columns
- Triggers
- When triggered
- Script
- Columns
- Views
- Columns (see tables)
- Script
- Materialized views
- Script
- User-defined Functions
- Script
- Parameters
- Returned value
Data profiling
Datedo supports following data profiling in Google Cloud SQL for PostgreSQL:
- Tables
- Rows count
- Column distribution
- Distinct values
- Non-distinct values
- Empty
- NULL
- Numeric columns profile
- Minimum value
- Maximum value
- Average of values
- Variance of values
- Standard deviation
- Span as difference between min and max value
- Number of distinct values
- String columns profile
- Min value as first string in alphabetical order
- Max value as last string in alphabetical order
- Number of distinct values
- Date columns profile
- Min value as earliest date
- Max value as latest date
- Span as difference between min and max dates
- Number of distinct dates
- Top N values
- Top 10/100/1000 popular values
- All values if less than 1000 distinct
- 10 Random values
Read more about profiling in a Data Profliling documentation.
Comments
Dataedo reads PostgreSQL comments from following objects:
- Tables
- Columns
- Views
- Columns
- Functions
Dataedo does not write comments back to PostgreSQL at this moment.
Known Issues
- length of data type is not imported
- materialized views use the same icon as standard views
- materialized view columns are not imported
- rules are not imported
- trigger functions are grouped with standard functions
- dependencies are imported only from views
- tables and views with no comments, but containing column level comments are not correctly imported. Add a table level comment to solve the issue
Limitations
Dataedo Postgres connector currently doesn't support connection to servers that force SSL.
Following schema elements are not supported yet:
- Check constraints
- Non unique indexes
- Sequences
- User defined types
- Domains
- Extensions
- Event triggers
- Casts