{ "info": { "author": "Samyak Ratna Tamrakar", "author_email": "samyak.r.tamrakar@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Database :: Database Engines/Servers" ], "description": "# S3ToRedshift\nConnector to upload csv/csv gzip files from S3 bucket into Redshift table.\n\n\n## Requirements\n\n* Python 3+ (Tested in 3.7)\n* pandas>=0.25.0\n* GiantPandas>=0.1.6\n* S3Connector>=0.1.5\n\n\n## Install with pip\n```bash\n$ pip install S3ToRedshift\n```\n\n## Usage\n1. Import the library.\n ```python\n from S3ToRedshift import S3ToRedshift\n ```\n\n2. Create an instance by defining aws access credentials, redshift credentials and region name. These parameters might not be needed, depending on the machine's access rights.\n ```python\n s3_to_redshift = S3ToRedshift(\n aws_access_key_id='##########',\n aws_secret_access_key='##########',\n region_name='##########',\n host='##########',\n user='##########',\n password='##########',\n dbname='##########',\n port='##########',\n iam_role='##########'\n )\n ```\n\n3. The imported module has several functions. Please refer to respective help for more information.\n 1. ```s3_to_redshift.upload_csv(schema_name, table_name, bucket_name, object_name, file_type, if_exists, csv_sep, csv_null_identifier)```\n \n**© [Samyak Ratna Tamrakar](https://www.linkedin.com/in/srtamrakar/)**, 2019.", "description_content_type": "text/markdown", "docs_url": null, "download_url": "https://github.com/srtamrakar/python-s3-to-redshift/archive/v_0.1.13.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/srtamrakar/python-s3-to-redshift", "keywords": "aws,s3,redshift,csv", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "S3ToRedshift", "package_url": "https://pypi.org/project/S3ToRedshift/", "platform": "", "project_url": "https://pypi.org/project/S3ToRedshift/", "project_urls": { "Download": "https://github.com/srtamrakar/python-s3-to-redshift/archive/v_0.1.13.tar.gz", "Homepage": "https://github.com/srtamrakar/python-s3-to-redshift" }, "release_url": "https://pypi.org/project/S3ToRedshift/0.1.13/", "requires_dist": null, "requires_python": "", "summary": "Connector to upload csv/csv gzip files from S3 bucket into Redshift table.", "version": "0.1.13" }, "last_serial": 5943028, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "29a6ecc874a9b439fb745ede08cdb148", "sha256": "9464d6207e7ac7e2c43a2e746b08424f31cbf2a0ae7f961d4b757cdddbc91aff" }, "downloads": -1, "filename": "S3ToRedshift-0.1.0.tar.gz", "has_sig": false, "md5_digest": "29a6ecc874a9b439fb745ede08cdb148", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3529, "upload_time": "2019-08-26T12:27:56", "url": "https://files.pythonhosted.org/packages/a2/90/e2129c3ca90141f60b610901a034ed1b347b642e34d3cb65a9a5a31ee2ec/S3ToRedshift-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "80d2e1c19edbb6607f35bd1d642cc1c7", "sha256": "ded2d3e37d75849c61410132bf279882c5e62841a78e9097e33d45ba809558c0" }, "downloads": -1, "filename": "S3ToRedshift-0.1.1.tar.gz", "has_sig": false, "md5_digest": "80d2e1c19edbb6607f35bd1d642cc1c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3522, "upload_time": "2019-08-26T13:12:43", "url": "https://files.pythonhosted.org/packages/9f/75/f4632f04d711f42d84502e8e864db7ebc42c8441107f5f6bd0993e460274/S3ToRedshift-0.1.1.tar.gz" } ], "0.1.10": [ { "comment_text": "", "digests": { "md5": "2fe3e3be74a55ac5b4db41dc65d412ec", "sha256": "b4ca63ef9c75fb78132755fade69fdaaa598a693c122cf86f3f27b83add2dce3" }, "downloads": -1, "filename": "S3ToRedshift-0.1.10.tar.gz", "has_sig": false, "md5_digest": "2fe3e3be74a55ac5b4db41dc65d412ec", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2931, "upload_time": "2019-09-09T08:36:46", "url": "https://files.pythonhosted.org/packages/c5/15/1c1f65b88ef1bce836fac212e5817a5f3e394963f5d1d432cad156b783ee/S3ToRedshift-0.1.10.tar.gz" } ], "0.1.11": [ { "comment_text": "", "digests": { "md5": "8eaf7f765502b097472af37a846cf1e4", "sha256": "2b5998c146a1925189729eccb18fc7baeade5f816cf339f0c4445d6512247336" }, "downloads": -1, "filename": "S3ToRedshift-0.1.11.tar.gz", "has_sig": false, "md5_digest": "8eaf7f765502b097472af37a846cf1e4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2970, "upload_time": "2019-09-12T13:11:35", "url": "https://files.pythonhosted.org/packages/5d/7a/7d3d08c068bae1a2de07109730b51b93135da5fec76d8143cf64092f0c0a/S3ToRedshift-0.1.11.tar.gz" } ], "0.1.12": [ { "comment_text": "", "digests": { "md5": "0f1266ba6d857c73c50b5594b31925b6", "sha256": "433ae1be6be759d606777179286fc79c1e7bbbd2179b759a16f8b722610e2345" }, "downloads": -1, "filename": "S3ToRedshift-0.1.12.tar.gz", "has_sig": false, "md5_digest": "0f1266ba6d857c73c50b5594b31925b6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2972, "upload_time": "2019-09-16T11:45:29", "url": "https://files.pythonhosted.org/packages/52/1d/f78a55fc29582014ab60bc52723bf27b98dc2ffa4f5a12391bf15cb8b71f/S3ToRedshift-0.1.12.tar.gz" } ], "0.1.13": [ { "comment_text": "", "digests": { "md5": "3de95fd90d9a1d22b34338642a8ab4fc", "sha256": "e4dccd77c3fd29402e46406a4fdb63a0e1792d034d9ddda59f0e232cf6ce6dd4" }, "downloads": -1, "filename": "S3ToRedshift-0.1.13.tar.gz", "has_sig": false, "md5_digest": "3de95fd90d9a1d22b34338642a8ab4fc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2962, "upload_time": "2019-10-08T06:12:30", "url": "https://files.pythonhosted.org/packages/1c/26/05ba9eb0880e452179429ef807e495f7b361547e3090d13723bdbb5b7470/S3ToRedshift-0.1.13.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "0d81bf9fbf9c5a45c16ae9fc3fe5884d", "sha256": "04529eb2dee23032b2f823dedb6203cd3dc039094121f41a330f4c23d2075fd6" }, "downloads": -1, "filename": "S3ToRedshift-0.1.2.tar.gz", "has_sig": false, "md5_digest": "0d81bf9fbf9c5a45c16ae9fc3fe5884d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3520, "upload_time": "2019-08-27T05:43:23", "url": "https://files.pythonhosted.org/packages/b5/bc/3b52a37b42cd97440323231f7f639beb07d59ab522bcd3ac87fe2febfff5/S3ToRedshift-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "e1eb3643bc0b8c79951569ddddbc0a7a", "sha256": "10127ba10574334ec1dfe03da1234005b48bbafcfbd6292045cd6d0a16afc96c" }, "downloads": -1, "filename": "S3ToRedshift-0.1.3.tar.gz", "has_sig": false, "md5_digest": "e1eb3643bc0b8c79951569ddddbc0a7a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3539, "upload_time": "2019-08-27T06:30:30", "url": "https://files.pythonhosted.org/packages/00/1c/49ab6076056588cb851178896bd39de4c4399e28ab09d91bb6ac046fd39a/S3ToRedshift-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "3877d3752e8fc35c3c3aa6dfe515f427", "sha256": "36dc2b44cf12335922da4afc2811426498648a3bcb794fb3f61427072ccab0da" }, "downloads": -1, "filename": "S3ToRedshift-0.1.4.tar.gz", "has_sig": false, "md5_digest": "3877d3752e8fc35c3c3aa6dfe515f427", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3523, "upload_time": "2019-08-27T07:10:18", "url": "https://files.pythonhosted.org/packages/4b/73/a3bb13d1201a24644e823c570a8c513a24749490e40d1f3182ad9e3c071e/S3ToRedshift-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "6aeec9e685bb63d7784e7ba4aecdc950", "sha256": "658b3037aac8537a7d98a76732a4febe5a3495cc598e06965f4995f02d6dcc71" }, "downloads": -1, "filename": "S3ToRedshift-0.1.5.tar.gz", "has_sig": false, "md5_digest": "6aeec9e685bb63d7784e7ba4aecdc950", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3527, "upload_time": "2019-08-27T07:19:33", "url": "https://files.pythonhosted.org/packages/4b/6c/2f1cd032a7c8879b17d8482cbbca3e6f85d5885a89b159656bc4a3f1a136/S3ToRedshift-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "a1bda469267d53f9adefcbf5d7c5f1bc", "sha256": "b12770b3cb9c4c5471d69e70f900c610927b57b4622aa065000b38c2d9afb77a" }, "downloads": -1, "filename": "S3ToRedshift-0.1.6.tar.gz", "has_sig": false, "md5_digest": "a1bda469267d53f9adefcbf5d7c5f1bc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2882, "upload_time": "2019-08-29T18:15:12", "url": "https://files.pythonhosted.org/packages/78/30/84f9db00b558dde3693b60f2985da2008feadc6a988ad43d5207a9fc1722/S3ToRedshift-0.1.6.tar.gz" } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "69238c8f2af2e3b785f225f074ae0d74", "sha256": "c7f07020de7c977bcf9a8fe90a81179c4cbc8202e857e04b9d36cbb1df0abac2" }, "downloads": -1, "filename": "S3ToRedshift-0.1.7.tar.gz", "has_sig": false, "md5_digest": "69238c8f2af2e3b785f225f074ae0d74", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2922, "upload_time": "2019-08-30T06:04:32", "url": "https://files.pythonhosted.org/packages/2c/a4/bb69e61967abc2b8fc22e85423d85493e3d8a7aea160c4d4fe9ee82fa6db/S3ToRedshift-0.1.7.tar.gz" } ], "0.1.8": [ { "comment_text": "", "digests": { "md5": "b342040b5b1b3e9c5809d6835c6988ed", "sha256": "1e18cc45d465249a59bf41cf150c81f5308cc44af92bc524e7de69ac77077644" }, "downloads": -1, "filename": "S3ToRedshift-0.1.8.tar.gz", "has_sig": false, "md5_digest": "b342040b5b1b3e9c5809d6835c6988ed", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2921, "upload_time": "2019-08-30T06:10:05", "url": "https://files.pythonhosted.org/packages/f6/b9/66d38ad67ec226369ad8711f683c84c6f080634d05a0fd5ccc49067f18a9/S3ToRedshift-0.1.8.tar.gz" } ], "0.1.9": [ { "comment_text": "", "digests": { "md5": "e62d075bec92731655d66e9d6683f322", "sha256": "46a11c2f631a360401a4496d30972b78788f9f5ad37a2bb9d38c15bc67ff1d55" }, "downloads": -1, "filename": "S3ToRedshift-0.1.9.tar.gz", "has_sig": false, "md5_digest": "e62d075bec92731655d66e9d6683f322", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2925, "upload_time": "2019-09-04T06:35:46", "url": "https://files.pythonhosted.org/packages/f1/43/c2a4d4ff557967b0dbde30e2cb7a820170beb6e94b355d655468d8a5de6e/S3ToRedshift-0.1.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3de95fd90d9a1d22b34338642a8ab4fc", "sha256": "e4dccd77c3fd29402e46406a4fdb63a0e1792d034d9ddda59f0e232cf6ce6dd4" }, "downloads": -1, "filename": "S3ToRedshift-0.1.13.tar.gz", "has_sig": false, "md5_digest": "3de95fd90d9a1d22b34338642a8ab4fc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2962, "upload_time": "2019-10-08T06:12:30", "url": "https://files.pythonhosted.org/packages/1c/26/05ba9eb0880e452179429ef807e495f7b361547e3090d13723bdbb5b7470/S3ToRedshift-0.1.13.tar.gz" } ] }