GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Snowflake test fails with latest dependency version

Open
#1,592 0 comments 0 reactions 0 assignees View on GitHub
type: bug
Dominant language
Python
Stars
524
Forks
171
Avg merge
5d 15h
Merged PRs (30d)
4

Description

**Describe the bug**
With dependency `snowflake-sqlalchemy==1.7.7` integration test `test_schema_validation_specific_types` fails with exception:

```
E snowflake.connector.errors.ProgrammingError: 001003 (42000): SQL compilation error:
E syntax error line 1 at position 0 unexpected '"TEST_SPECIFIC_DATA_TYPES"'.
```

**What version of DVT are you using?**
8.1.1

**What type of connections are you using for source and target?**
Snowflake

**Steps to reproduce the behavior**
```
pip install --upgrade snowflake-sqlalchemy
```

For the time being I've pinned the version so that tests will pass. When this is fixed we should remove the pinned package version from `noxfile.py`

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.