search

GoogleCloudPlatform / professional-services-data-validator

Utility to compare data between homogeneous or heterogeneous environments to ensure source and target tables match
Apache License 2.0
385 stars 108 forks source link

Support Spanner PostgreSQL dialect #1073

Open nehanene15 opened 6 months ago

nehanene15 commented 6 months ago

Currently, DVT only supports Spanner GoogleSQL. DVT should be expanded to support PostgreSQL for all types of validation.

nehanene15 commented 6 months ago

Spangres does not support TO_HEX() or ENCODE(). We need those functions to convert the byte string value returned from sha256() into a string. Due to this, hash validation cannot be supported.