{
    "info": {
        "author": "Arik Fraimovich, Oren Itamar",
        "author_email": "opensource@everything.me",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: Apache Software License",
            "Programming Language :: Python"
        ],
        "description": "# Redshift Console\n\n_Redshift Console_'s goal is to be the tool to monitor and manage a Redshift cluster. The first release has basic tools to monitor running queries, WLM queue and your tables/schemas.\n\nAfter over a year of managing our Redshift cluster with a collection of scripts and queries, we decided to bundle this into a more user friendly tool that can be used by a wider audience. This project also aims to uncover all the useful information hidden in [Redshift's Developer Guide](http://docs.aws.amazon.com/redshift/latest/dg/) (such as the [table design status](http://docs.aws.amazon.com/redshift/latest/dg/c_analyzing-table-design.html) query).\n\n![Screenshots](https://dl.dropboxusercontent.com/u/2186704/rdc_screenshots.gif)\n\n### Features\n\n* Inflight queries view with option to cancel any query and view related alerts (when available; from [STL_ALERT_EVENT_LOG](http://docs.aws.amazon.com/redshift/latest/dg/r_STL_ALERT_EVENT_LOG.html)).\n* WLM queue view.\n* Schemas view with additional information for each table including: total size (rows/MB), unsorted area size, is the table properly distributed and more.\n* Load errors (aggregated view) from the past 24h, based on [STL_LOAD_ERRORS](http://docs.aws.amazon.com/redshift/latest/dg/r_STL_LOAD_ERRORS.html)\n\n### Roadmap\n\nThis project is safe for usage, but still in its early stage (version 0.1). Future versions will include:\n\n* Loads - Progress of current operations and history of recent ones.\n* Vacuum status.\n* SNS/CloudWatch integration to show metrics and events from AWS' console.\n* Proactive notifications re. important events in the system: long running queries, problems, changes to the schema, dangerous levels of unsorted areas and more.\n\nWe are always happy to receive feedback and suggestions, especially if they are accompanied by a pull request.\n\n## Usage\n\nYou can either use the PyPI package or the docker image.\n\n#### PyPI\n\n1. The easiest way to install the project is from pypi:\n\n  ```bash\n  $ pip install redshift-console\n  ```\n\n2. Settings are set from environment variables. The main setting to set is the connection string to your Redshift cluster: (make sure the user has sufficient permissions)\n\n  ```bash\n  $ export REDSHIFT_CONNECTION_STRING='user= password= host= port= dbname='\n  ```\n\n3. Start the server:\n\n   ```bash\n   $ redshift-console runserver\n   Starting server on port 5000 (debug mode: False).\n   ```\n   \n#### Docker\n  ```bash\n   $ docker run -e REDSHIFT_CONNECTION_STRING=\"user= password= host= port=5439 dbname=\" -p 5000:5000 everythingme/redshift-console\n   Starting server on port 5000 (debug mode: False).\n   ```\n\n## Authors\n\n[Arik Fraimovich](http://github.com/arikfr) and [Oren Itamar](http://github.com/orenitamar).",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://github.com/EverythingMe/redshift_console/",
        "keywords": null,
        "license": "Apache",
        "maintainer": null,
        "maintainer_email": null,
        "name": "redshift-console",
        "package_url": "https://pypi.org/project/redshift-console/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/redshift-console/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "http://github.com/EverythingMe/redshift_console/"
        },
        "release_url": "https://pypi.org/project/redshift-console/0.1.3/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "Monitor and manage your Redshift cluster.",
        "version": "0.1.3"
    },
    "last_serial": 1646291,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c244d22d747ffb951f893e4f829496a1",
                    "sha256": "8387168e9a810e958617835a7b4926aedca0c6b1fb1333f9abcfa7b91d111f7e"
                },
                "downloads": -1,
                "filename": "redshift-console-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c244d22d747ffb951f893e4f829496a1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1439464,
                "upload_time": "2015-04-06T13:27:49",
                "url": "https://files.pythonhosted.org/packages/06/a2/875d0a9a77f0c0da4cc70b315e77b13f7b8438c1f06bcf0b1243fe3cc740/redshift-console-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "594b82a50efbcd37f1f6f892aad2c3cf",
                    "sha256": "04db228bf516d061f4e9c8c9c36f2efe50d8e01148e9e5742df5fb13c2e23f45"
                },
                "downloads": -1,
                "filename": "redshift-console-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "594b82a50efbcd37f1f6f892aad2c3cf",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1442979,
                "upload_time": "2015-04-14T12:47:11",
                "url": "https://files.pythonhosted.org/packages/8a/f9/59f551d38a89e50204abf1fdc565e1a9dc246ac283589e586526e7e464ff/redshift-console-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "234a463cc191a1598941f33cbeadf37d",
                    "sha256": "4680a92f1a5db97b1334d6ecf0357c27f783bde8be51a7f646082c43a38fd042"
                },
                "downloads": -1,
                "filename": "redshift-console-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "234a463cc191a1598941f33cbeadf37d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1445196,
                "upload_time": "2015-07-16T06:58:59",
                "url": "https://files.pythonhosted.org/packages/34/fc/b58bbca7f4d36b5ac748e7e47e6d06242446e968cf51c8163e806f4cfcbf/redshift-console-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "31bf04427123c71f8780988a77026de6",
                    "sha256": "ac2fe8f2d1baca67ff9c3555fa62e3cd32d894efb8d5736f679375f9b0bb736a"
                },
                "downloads": -1,
                "filename": "redshift-console-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "31bf04427123c71f8780988a77026de6",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1445313,
                "upload_time": "2015-07-23T08:48:25",
                "url": "https://files.pythonhosted.org/packages/94/18/ac98f85378f8785518df0059a381404268c54cccb71e1e483600a714eaad/redshift-console-0.1.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "31bf04427123c71f8780988a77026de6",
                "sha256": "ac2fe8f2d1baca67ff9c3555fa62e3cd32d894efb8d5736f679375f9b0bb736a"
            },
            "downloads": -1,
            "filename": "redshift-console-0.1.3.tar.gz",
            "has_sig": false,
            "md5_digest": "31bf04427123c71f8780988a77026de6",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 1445313,
            "upload_time": "2015-07-23T08:48:25",
            "url": "https://files.pythonhosted.org/packages/94/18/ac98f85378f8785518df0059a381404268c54cccb71e1e483600a714eaad/redshift-console-0.1.3.tar.gz"
        }
    ]
}