Niivii commented on issue #2843: URL: https://github.com/apache/arrow-adbc/issues/2843#issuecomment-3570548122
For future reference from Snowflake support: Parquet files store timestamps without timezone offsets (some libraries, eg, Pandas/Polars etc, may store this information for their own use, but it's not accessed by Snowflake). The logical type specifies whether the field is adjusted to UTC, but it doesn't provide information about the timezone offset at which the data was originally created. When we read the parquet file, Snowflake displays it according to the parameter named TIMEZONE. For example, if you want to review the underlying logical_type, you should be able to analyze Parquet files if writing dataframes to Parquet via pathlib, for example, and then inspect logical_type with [parquet-tools](https://pypi.org/project/parquet-tools/).: `parquet-tools inspect <file>.parquet` For timestamp fields, you might observe the parameter isAdjustedToUTC=true or false, but not the actual timezone e.g: `logical_type: Timestamp(isAdjustedToUTC=true, timeUnit=nanoseconds, is_from_converted_type=false, force_set_converted_type=false)` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
