snowflakedb / snowflakedb/snowpark-python

SNOW-850962: Add CBRT function to API

Open
#922 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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

Description

What is the current behavior?

In the current state, Snowpark does not have native support for the CBRT function that is currently available as a built-in function in Snowflake.

What is the desired behavior?

Use cbrt as a native function in the Snowpark API.

How would this improve snowflake-snowpark-python?

More closely maps existing SQL functionality to that of availability in Snowflake.

References, Other Background

I believe this is the last "Exponent and Root" function as part of the numeric functions needing to be mapped.

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.

Research direction

No file or test path is named in the issue. Start by locating existing exponent and root function mappings and their tests, then compare how the Snowpark API exposes them. Done means cbrt is available as a native Snowpark function and its behavior is covered consistently with the existing mappings.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
api, data-engineering
Issue type
Feature
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.