The Snowpark SQL API supports Snowpark Python development from a local environment, where source control, versioning, branching, and automated deployment can manage shared codebases more sustainably than worksheets. section 6.2 section 6.8
Use the API to:
- Create and transform data frames with Snowpark methods that translate into SQL and execute in Snowflake. section 6.8
- Connect from Python by supplying account credentials and optional role, warehouse, database, and schema settings. section 6.8
- Protect credentials with a structured configuration file that Python converts into connection parameters. section 6.8
- Read local CSV files, upload them to an internal stage, and load them into tables with COPY. section 6.8
Holiday-aware procedure
A Python stored procedure can use the holidays package to evaluate a date and country, return a Boolean result, and support date-dimension processing. Calls distinguish holidays in the United States and France. section 6.2
