snowflakedb / snowflakedb/snowpark-python

SNOW-2380579: TimestampType(s) should support precision argument

Open
#3,823 1 comment 0 reactions 2 assignees View on GitHub

@sfc-gh-jrose is already working on this.

Since Oct 4, 2025.

feature status-triage_done
Dominant language
Python
Stars
341
Forks
155
Avg merge
4d 16h
Merged PRs (30d)
27

Description

What is the current behavior?

TimestampType only take timezone argument, not the precision argument that is available on the underlying snowflake type. https://docs.snowflake.com/en/sql-reference/data-types-datetime

What is the desired behavior?

They should take both, e.g. TimestampType(precision=6) to get a microsecond rather than nanosecond precision time.

How would this improve snowflake-snowpark-python?

Better mapping onto the full set of snowflake types. Additionally, with iceberg v2 only supporting microsecond precision, it is easy to accidentally lose precision when writing to iceberg table. This helps make that more explicit.

References, Other Background

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.