Snowflake: Did not recognize type 'DATE' of column 'date'

[popcornylu]

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

1. Setup environment Setup snowflake backend. Have a table with DATE column
2. Execute command

    piperider run
   

3. See error

/private/tmp/piperider-test/venv/lib/python3.9/site-packages/snowflake/sqlalchemy/snowdialect.py:539: SAWarning: Did not recognize type 'DATE' of column 'date'
  sa_util.warn(
Error: 'NullType' object is not callable

Expected behavior No error

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. macOS]
• Python Version [e.g. 3.9]
• Version [e.g. v0.4.1]

Additional context Add any other context about the problem here.

[popcornylu]

This is a known issue in snowflake-sqlalchemy 1.4.0. https://github.com/snowflakedb/snowflake-sqlalchemy/issues/324

Current workaround piperider v0.4.2 is set the version as snowflake-sqlalchemy<1.4.0

[popcornylu]

Fixed in snowflake-sqlalchemy 1.4.1 https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.4.1

[popcornylu]

Fixed in v0.8.0