kychanbp

Any possibilities I got this error?

I tried to inspect the log file of alchemy. The sql statement is ``` CREATE TABLE x_ap_account_transactions ( "ID" BIGINT, "OBJECT_PK" BIGINT, "OBJECT_REF" TEXT, "TRANSACTION_DESC" TEXT, "TRANSACTION_TYPE" TEXT, "TRANSACTION_DATE" TIMESTAMP,...

Or should I set the timestamp mapping specify in this link: https://docs.snowflake.com/en/sql-reference/parameters.html#timestamp-type-mapping?

I think I solve it by ``` conn.execute("ALTER SESSION SET TIMESTAMP_TYPE_MAPPING = 'TIMESTAMP_TZ';") conn.execute("ALTER SESSION SET TIMEZONE = 'UTC';") ``` setting the timestamp type mapping and timezone.

@lightupyiqian But it seem snowflake supports Timestamp with timezone? I expect [pd_writer](https://docs.snowflake.com/en/user-guide/python-connector-api.html#pd_writer) can handle that?

Problem still existed. But the data is persisted in "log_entry" field.