Prefect-snowflake

Released on January 4th, 2022.

Added

- `private_key_path` and `private_key_passphrase` fields to `SnowflakeConnector` - [59](https://github.com/PrefectHQ/prefect-snowflake/pull/59)

Changed

- Do not start connection upon instantiating `SnowflakeConnector` until its methods are called - [58](https://github.com/PrefectHQ/prefect-snowflake/pull/58)

Deprecated

- `password` in favor of `private_key_passphrase` field in `SnowflakeConnector` - [59](https://github.com/PrefectHQ/prefect-snowflake/pull/59)

Released on December 30th, 2022.

Added

- `fetch_size` and `poll_frequency_s` to `SnowflakeConnector` fields - [53](https://github.com/PrefectHQ/prefect-snowflake/pull/53)
- `reset_cursors`, `fetch_one`, `fetch_many`, `fetch_all`, `execute`, `execute_many`, and `close` methods to `SnowflakeConnector` fields - [53](https://github.com/PrefectHQ/prefect-snowflake/pull/53)

Changed

- Added `get_client` method to `SnowflakeCredentials` to enable more customization of connection creation - [51](https://github.com/PrefectHQ/prefect-snowflake/pull/51)

Released on December 21st, 2022.

Deprecated

- The `okta_endpoint` field in `SnowflakeCredentials`; use `endpoint` instead - [45](https://github.com/PrefectHQ/prefect-snowflake/pull/45).

Fixed

- Fixed misleading validator message in `SnowflakeCredentials` when `authenticator` is `okta_endpoint` - [45](https://github.com/PrefectHQ/prefect-snowflake/pull/45).

Released on October 5th, 2022.

Added
- `snowflake_query_sync` - [34](https://github.com/PrefectHQ/prefect-snowflake/pull/34).

Released on August 22nd, 2022.

Added
- `poll_frequency_seconds` to `snowflake_query` and `snowflake_multiquery` - [29](https://github.com/PrefectHQ/prefect-snowflake/pull/29) - contributed by thesubneo

Released on August 15th, 2022.

Note, with this release, the `database`, `warehouse` and `schema` fields from `SnowflakeCredentials` have been migrated to `SnowflakeConnector`:

from prefect_snowflake.credentials import SnowflakeCredentials
from prefect_snowflake.database import SnowflakeConnector
...
snowflake_credentials = SnowflakeCredentials(
account="account",
user="user",
password="password",
)
snowflake_connector = SnowflakeConnector(
database="database",
warehouse="warehouse",
schema="schema",
credentials=snowflake_credentials
)


Tasks now accept `SnowflakeConnector` instead of `SnowflakeCredentials`:

snowflake_query(..., snowflake_connector)


Added
- `SnowflakeConnector` block - [24](https://github.com/PrefectHQ/prefect-snowflake/pull/24)
- `okta_endpoint` field to `SnowflakeCredentials` - [25](https://github.com/PrefectHQ/prefect-snowflake/pull/25)

Changed
- Moved the keywords, `database`, `warehouse`, and `schema` from `credentials.SnowflakeCredentials` into `database.SnowflakeConnector` - [24](https://github.com/PrefectHQ/prefect-snowflake/pull/24)
- Moved the method `get_connection` from `credentials.SnowflakeCredentials` into `database.SnowflakeConnector` - [24](https://github.com/PrefectHQ/prefect-snowflake/pull/24)
- `authenticator` field in `SnowflakeCredentials` to `Literal` type - [25](https://github.com/PrefectHQ/prefect-snowflake/pull/25)

Removed
- Removed the keywords, `database` and `warehouse`, from `snowflake_query` and `snowflake_multiquery` - [24](https://github.com/PrefectHQ/prefect-snowflake/pull/24)

Security
- Fixed revealing the input password nested under `connect_params` when logging `SnowflakeCredentials` - [24](https://github.com/PrefectHQ/prefect-snowflake/pull/24)