Amazon Aurora PostgreSQL support

Supported versions

• Aurora PostgreSQL compatible
• Aurora MySQL compatible - check here

Supported schema elements and metadata

• Tables
  • Columns
    • Data type
    • Nullable
    • Default value
    • Data lineage*
  • Primary keys
    • Columns
  • Foreign keys
    • Columns
  • Triggers
    • When triggered
    • Script
• Views
  • Columns (see tables)
  • Script
• Materialized views
  • Script
• User-defined Functions
  • Script
  • Parameters
  • Returned value

Data Lineage

Dataedo builds Amazon Aurora PostgreSQL lineage using PortgreSQL Parser. Check the capabilities of automatic lineage.

Data profiling

Datedo supports following data profiling in database:

• 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

• using encoding different than UTF-8 (unicode) causes errors
• 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

Following schema elements currently are not supported:

• Check constraints
• Non unique indexes
• Sequences
• User defined types
• Domains
• Extensions
• Event triggers
• Casts

Learn more

Connect to Amazon Aurora