Amazon RDS for PostgreSQL support

Applies to: Dataedo 23.x (current) versions, Article available also for: 10.x

Supported versions

Versions: 9.3, 9.4, 9.5, 9.6, 10

Supported schema elements and metadata

  • Tables
    • Columns
      • Data type
      • Nullable
      • Default value
    • 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

Comments

Dataedo reads PostgreSQL comments from following objects:

  • Tables
    • Columns
  • Views
    • Columns
  • Functions

Dataedo does not write comments back to PostgreSQL at this moment.

Data profiling

Datedo supports following data profiling in Postgres:

  • 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.

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
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.