{ "info": { "author": "Chaerim Yeo", "author_email": "yeochaerim@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# redshift-unloader\nUnloads the result of a query on Amazon Redshift to local storage.\n\n## Prerequisites\n- Python 3.6+\n- boto3 1.7.84\n- psycopg2 2.7.5\n- psycopg2-binary 2.7.5\n\n## Installation\nThe package is available on PyPI:\n\n```bash\npip install redshift-unloader\n```\n\n### Usage\nUnloaded data is supposed to be gzipped.\n\n```py\nfrom redshift_unloader import RedshiftUnloader\n\nru = RedshiftUnloader(host='',\n port=,\n user='',\n password='',\n database='',\n s3_bucket='',\n access_key_id='',\n secret_access_key='',\n region='',\n verbose=False)\n\nru.unload(\"SELECT * FROM my_table WHERE log_time >= 'yyyyMMdd'\",\n \"/path/to/result.csv.gz\",\n delimiter=',',\n add_quotes=True,\n escape=True,\n null_string='',\n with_header=True)\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/cryeo/redshift-unloader", "keywords": "", "license": "MIT License", "maintainer": "", "maintainer_email": "", "name": "redshift-unloader", "package_url": "https://pypi.org/project/redshift-unloader/", "platform": "", "project_url": "https://pypi.org/project/redshift-unloader/", "project_urls": { "Homepage": "https://github.com/cryeo/redshift-unloader" }, "release_url": "https://pypi.org/project/redshift-unloader/0.1.4/", "requires_dist": [ "boto3 (==1.7.84)", "psycopg2 (==2.7.5)", "psycopg2-binary (==2.7.5)" ], "requires_python": ">=3.6", "summary": "Unload utility for Amazon Redshift", "version": "0.1.4" }, "last_serial": 5482254, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "613f9e578239e55cfc94f802592ebd96", "sha256": "8075e9d27c4f12fc4907adfb0f5351904e8cf936508a6393b0c9d3e0b59978d5" }, "downloads": -1, "filename": "redshift_unloader-0.1.0-py36-none-any.whl", "has_sig": false, "md5_digest": "613f9e578239e55cfc94f802592ebd96", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 5993, "upload_time": "2018-09-07T14:59:29", "url": "https://files.pythonhosted.org/packages/fa/55/895bf063fd65951897be7bd45b7e31591a8c281dc6490756e86c4f4af23f/redshift_unloader-0.1.0-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3c20b3302c947e600b7379015d86757f", "sha256": "3969c74bf89426cede0ec7a6c7c92a7ebbc80d8e4f64eb3e76a5758f697dc182" }, "downloads": -1, "filename": "redshift-unloader-0.1.0.tar.gz", "has_sig": false, "md5_digest": "3c20b3302c947e600b7379015d86757f", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5347, "upload_time": "2018-09-07T14:59:30", "url": "https://files.pythonhosted.org/packages/12/ec/4070bfbdec6a8d56134bad94973730b22b7880bdbcabe4fbf7908342cd1e/redshift-unloader-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "00f1225366cbf68fc8ef79d015671eda", "sha256": "c77dc4454b7de24f791794c78c2338d3dee7006a3c174c262aa7ba9c9a68e72c" }, "downloads": -1, "filename": "redshift_unloader-0.1.1-py36-none-any.whl", "has_sig": false, "md5_digest": "00f1225366cbf68fc8ef79d015671eda", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 6041, "upload_time": "2018-09-07T15:24:12", "url": "https://files.pythonhosted.org/packages/34/f6/1de28c320fa2a7b2fe98cafac0da2d4c0886626dc61894d038b377902cc4/redshift_unloader-0.1.1-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c3151aff1e829876d3afb22ea0a96775", "sha256": "d23ec006e3950614cdc67c1be9cd93b3a337a7b3d21604054b1b68713396143b" }, "downloads": -1, "filename": "redshift-unloader-0.1.1.tar.gz", "has_sig": false, "md5_digest": "c3151aff1e829876d3afb22ea0a96775", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5387, "upload_time": "2018-09-07T15:24:15", "url": "https://files.pythonhosted.org/packages/42/42/943e8cb4a96d4dc62a7414819c0c0e86e8df3ae4bacd65b448f2eef9a168/redshift-unloader-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "990d27179f4d3488a3034ae6441a736b", "sha256": "0082c767d12de0bc3cee94c5c4a3e1e772ab6a5e8f6bd7accd16dd3f90622ffe" }, "downloads": -1, "filename": "redshift_unloader-0.1.2-py36-none-any.whl", "has_sig": false, "md5_digest": "990d27179f4d3488a3034ae6441a736b", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 6058, "upload_time": "2018-09-07T15:43:10", "url": "https://files.pythonhosted.org/packages/8b/14/f06682604055fd6860d5a4c9a6393bab9b729abd18d40894749694f61b17/redshift_unloader-0.1.2-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a4a26e292096987dfdd30e650b41c4d2", "sha256": "306f3f6b1f7b8a04148f1ebfb097da73b71697f16b6d1ab5f9c308a9bb6c20bd" }, "downloads": -1, "filename": "redshift-unloader-0.1.2.tar.gz", "has_sig": false, "md5_digest": "a4a26e292096987dfdd30e650b41c4d2", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5399, "upload_time": "2018-09-07T15:43:13", "url": "https://files.pythonhosted.org/packages/89/9c/2afb9036c3f232bd8ddde3bca8da86057f8481f822b24dafb888e209444a/redshift-unloader-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "60e935f10959cc787a03afee2903a97a", "sha256": "e849a675054ac58d19b5a142c50d9d5c152b7075c75d5c8a371faaa762e36b1f" }, "downloads": -1, "filename": "redshift_unloader-0.1.3-py36-none-any.whl", "has_sig": false, "md5_digest": "60e935f10959cc787a03afee2903a97a", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 6062, "upload_time": "2018-09-07T16:04:07", "url": "https://files.pythonhosted.org/packages/8b/1c/f92af9deff618499e8018dac900e7768beea62e106965b9cd16cea4cef08/redshift_unloader-0.1.3-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9c9772d34387f0ac0c0a5cd94ac4b2cc", "sha256": "03114507a0cc46bb4ca9d5530cbfc32eb6b0188d5995e34b8dd4a9c02f933250" }, "downloads": -1, "filename": "redshift-unloader-0.1.3.tar.gz", "has_sig": false, "md5_digest": "9c9772d34387f0ac0c0a5cd94ac4b2cc", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5409, "upload_time": "2018-09-07T16:04:10", "url": "https://files.pythonhosted.org/packages/8c/34/d45a3ac0e7d403bf44e1f4f7c9aeab002a29088003929c8d0534b5361713/redshift-unloader-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "bbc63f554f62111318a78993592db918", "sha256": "ac5e3ec240c8502f2dd709348344434ee43ee1c6476b19c42b6007045118b3aa" }, "downloads": -1, "filename": "redshift_unloader-0.1.4-py36-none-any.whl", "has_sig": false, "md5_digest": "bbc63f554f62111318a78993592db918", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 6164, "upload_time": "2019-07-03T15:18:02", "url": "https://files.pythonhosted.org/packages/22/28/86b90668143127857e0c4b9e6b75373159f0fef382ecd5545cff88145731/redshift_unloader-0.1.4-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dfb6fe8b50454102b50a4175d7dd6366", "sha256": "c3fd65dc68cd219111f942620e38000ca0d3deda848a45038227fbcd198959b2" }, "downloads": -1, "filename": "redshift-unloader-0.1.4.tar.gz", "has_sig": false, "md5_digest": "dfb6fe8b50454102b50a4175d7dd6366", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5425, "upload_time": "2019-07-03T15:18:03", "url": "https://files.pythonhosted.org/packages/09/82/c0a4c84ee30416c9fd905f1a6e83b42f24adc6890fec55a60ffe40190649/redshift-unloader-0.1.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "bbc63f554f62111318a78993592db918", "sha256": "ac5e3ec240c8502f2dd709348344434ee43ee1c6476b19c42b6007045118b3aa" }, "downloads": -1, "filename": "redshift_unloader-0.1.4-py36-none-any.whl", "has_sig": false, "md5_digest": "bbc63f554f62111318a78993592db918", "packagetype": "bdist_wheel", "python_version": "py36", "requires_python": ">=3.6", "size": 6164, "upload_time": "2019-07-03T15:18:02", "url": "https://files.pythonhosted.org/packages/22/28/86b90668143127857e0c4b9e6b75373159f0fef382ecd5545cff88145731/redshift_unloader-0.1.4-py36-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dfb6fe8b50454102b50a4175d7dd6366", "sha256": "c3fd65dc68cd219111f942620e38000ca0d3deda848a45038227fbcd198959b2" }, "downloads": -1, "filename": "redshift-unloader-0.1.4.tar.gz", "has_sig": false, "md5_digest": "dfb6fe8b50454102b50a4175d7dd6366", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 5425, "upload_time": "2019-07-03T15:18:03", "url": "https://files.pythonhosted.org/packages/09/82/c0a4c84ee30416c9fd905f1a6e83b42f24adc6890fec55a60ffe40190649/redshift-unloader-0.1.4.tar.gz" } ] }