PostgreSQL support

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

Supported versions

Versions: 9.x, 10.x, 11.x, 12.x, 13.x, 14.x, 15.x, 16.x

Specification

Imported metadata

Imported Editable
Tables
  Columns
   Data types
   Nullability
   Default value
   Column comments
   Data lineage
  Table comments
  Foreign keys
  Primary keys
  Unique keys
  Triggers
   When triggered
   Script
Views, Materialized views
  Script
  Columns
   Data types
   Nullability
   Default value
   Column comments
  View comments
Stored procedures
  Script
  Procedures comments
User-defined Functions
  Script
  Input arguments
  Output results
  Function comments
Shared metadata
  Dependencies
  Created time
  Last updated time

Supported features

Feature Imported
Import comments
Write comments back
Data profiling
Reference data (import lookups)
Importing from DDL
Generating DDL
FK relationship tester

Comments

Dataedo reads and writes PostgreSQL comments from/to following objects:

Object Read Write back
Table comments
  Column comments
View comments
  Columns
Function comments
Stored procedures

Data profiling

Datedo supports following data profiling in PostgreSQL:

Profile Support
Table row count
Table sample data
Column distribution (unique, non-unique, null, empty values)
Min, max values
Average
Variance
Standard deviation
Min-max span
Number of distinct values
Top 10/100/1000 values
10 random values

Read more about profiling in a Data Profliling documentation.

Data Lineage

Source Method Version
Views - object level From dependencies
Views - object level From SQL parsing ✅)
Views - column level From SQL parsing
dbt dbt connector

Data lineage is retived using Dataedo SQL parser. Read more about capabilities of PostgreSQL SQL parser

See also: dbt

Known Issues

  • rules are not imported
  • trigger functions are grouped with standard functions
  • dependencies are imported only from views

Limitations

Following schema elements currently are not supported:

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

Supported cloud databases

Dataedo should work with all cloud instances of PostgreSQL database. We have tested it with the following services:

Learn more

Connect to PostgreSQL

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.