# SNOWFLAKE PANDAS
## Installation
1. Install the package
```bash
pip install snowflake-pandas
```
## Requirements
Currently, the pandas-oriented API methods in the Python connector API work with:
- Snowflake Connector 2.1.2 (or higher) for Python.
- PyArrow library version 3.0.x.
- Pandas 0.25.2 (or higher). Earlier versions might work, but have not been tested.
For more information, see the [Snowflake Connector for Python documentation](https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-install).
## Caution
If you already have any version of the PyArrow library other than the recommended version listed above, please uninstall PyArrow before installing the Snowflake Connector for Python. Do not re-install a different version of PyArrow after installing the Snowflake Connector for Python.
For more information, see the [PyArrow library documentation](https://arrow.apache.org/docs/).
# Snowflake Connector for Python Pandas
This package provides a simple and efficient interface for connecting to Snowflake and interacting with it using Pandas. It supports common operations such as querying data, writing DataFrames to Snowflake, and managing table schemas.
## Benefits of Using This Package
1. **Seamless Integration with Pandas**:
- Effortlessly write and read data using familiar Pandas DataFrames, simplifying data manipulation.
2. **Connection Pooling**:
- Utilizes a connection pool to manage multiple connections efficiently, improving performance for concurrent operations.
3. **Custom Exception Handling**:
- Implements a custom exception class for better error management, allowing for clearer debugging and error reporting.
4. **Automatic Table Creation**:
- Supports automatic creation of tables when writing DataFrames, reducing the need for manual schema management.
5. **Flexible Schema Management**:
- Easily add new columns to existing tables, making schema evolution straightforward.
6. **Comprehensive Query Support**:
- Execute any SQL query and retrieve results as a DataFrame, providing flexibility for various data operations.
7. **Compatibility**:
- Built to work with Snowflake Connector for Python (v2.1.2 or higher) and Pandas (v0.25.2 or higher), ensuring that you have access to the latest features and improvements.
Raw data
{
"_id": null,
"home_page": "https://github.com/hitesh-c/snowflake-pandas",
"name": "snowflake-pandas",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": "Hitesh",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/73/b1/e5cdd56fb6a5523214fb1d47bc316bd6dfe753e108e5d830a2b6861cf039/snowflake_pandas-0.1.2.tar.gz",
"platform": null,
"description": "# SNOWFLAKE PANDAS\r\n\r\n## Installation\r\n\r\n1. Install the package\r\n ```bash\r\n pip install snowflake-pandas\r\n ```\r\n\r\n## Requirements\r\n\r\nCurrently, the pandas-oriented API methods in the Python connector API work with:\r\n- Snowflake Connector 2.1.2 (or higher) for Python.\r\n- PyArrow library version 3.0.x.\r\n- Pandas 0.25.2 (or higher). Earlier versions might work, but have not been tested.\r\n\r\nFor more information, see the [Snowflake Connector for Python documentation](https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-install).\r\n\r\n## Caution\r\n\r\nIf you already have any version of the PyArrow library other than the recommended version listed above, please uninstall PyArrow before installing the Snowflake Connector for Python. Do not re-install a different version of PyArrow after installing the Snowflake Connector for Python.\r\n\r\nFor more information, see the [PyArrow library documentation](https://arrow.apache.org/docs/).\r\n\r\n\r\n# Snowflake Connector for Python Pandas\r\n\r\nThis package provides a simple and efficient interface for connecting to Snowflake and interacting with it using Pandas. It supports common operations such as querying data, writing DataFrames to Snowflake, and managing table schemas.\r\n\r\n## Benefits of Using This Package\r\n\r\n1. **Seamless Integration with Pandas**:\r\n - Effortlessly write and read data using familiar Pandas DataFrames, simplifying data manipulation.\r\n\r\n2. **Connection Pooling**:\r\n - Utilizes a connection pool to manage multiple connections efficiently, improving performance for concurrent operations.\r\n\r\n3. **Custom Exception Handling**:\r\n - Implements a custom exception class for better error management, allowing for clearer debugging and error reporting.\r\n\r\n4. **Automatic Table Creation**:\r\n - Supports automatic creation of tables when writing DataFrames, reducing the need for manual schema management.\r\n\r\n5. **Flexible Schema Management**:\r\n - Easily add new columns to existing tables, making schema evolution straightforward.\r\n\r\n6. **Comprehensive Query Support**:\r\n - Execute any SQL query and retrieve results as a DataFrame, providing flexibility for various data operations.\r\n\r\n7. **Compatibility**:\r\n - Built to work with Snowflake Connector for Python (v2.1.2 or higher) and Pandas (v0.25.2 or higher), ensuring that you have access to the latest features and improvements.\r\n\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Snowflake Connector Package for Python and Pandas by hiteshlabs[dot]com.",
"version": "0.1.2",
"project_urls": {
"Homepage": "https://github.com/hitesh-c/snowflake-pandas"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "93bc02fbfc17aeec63950e33344e9c600915c1115cde39987e0fb1f85e9c6a6a",
"md5": "671a6e3fc7c48bc3264fa9c8bd9b3c71",
"sha256": "e5e5ff2dad9766fef881d8517a474f029b9f59d3e5a4f2913ae3fd4d4e08e17a"
},
"downloads": -1,
"filename": "snowflake_pandas-0.1.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "671a6e3fc7c48bc3264fa9c8bd9b3c71",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 5251,
"upload_time": "2024-09-20T16:39:59",
"upload_time_iso_8601": "2024-09-20T16:39:59.835753Z",
"url": "https://files.pythonhosted.org/packages/93/bc/02fbfc17aeec63950e33344e9c600915c1115cde39987e0fb1f85e9c6a6a/snowflake_pandas-0.1.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "73b1e5cdd56fb6a5523214fb1d47bc316bd6dfe753e108e5d830a2b6861cf039",
"md5": "ae18603f33c7d118537d826329352bf8",
"sha256": "98c0cd321655234f8b8d9219e0461ed4743550ef5871ac7c1435d6e01581e13a"
},
"downloads": -1,
"filename": "snowflake_pandas-0.1.2.tar.gz",
"has_sig": false,
"md5_digest": "ae18603f33c7d118537d826329352bf8",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 4792,
"upload_time": "2024-09-20T16:40:01",
"upload_time_iso_8601": "2024-09-20T16:40:01.530800Z",
"url": "https://files.pythonhosted.org/packages/73/b1/e5cdd56fb6a5523214fb1d47bc316bd6dfe753e108e5d830a2b6861cf039/snowflake_pandas-0.1.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-20 16:40:01",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "hitesh-c",
"github_project": "snowflake-pandas",
"github_not_found": true,
"lcname": "snowflake-pandas"
}
JSON
