--- title: Redshift Connector description: The Redshift connector allows data to be cataloged, queried, transformed and to create tables in Redshift. image: https://blog.promethium.ai/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-04-29-PM.png --- Mar 28, 2022 12:00:00 AM # Redshift Connector - Catalog, Transform, Query, Visualize ![Picture of Brett Arnott](https://blog.promethium.ai/hs-fs/hubfs/brett_hs.webp?width=50&name=brett_hs.webp) [ Brett Arnott ](https://blog.promethium.ai/author/brett-arnott) Share: [Share this page on LinkedIn ](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.promethium.ai/post/redshift-connector) [Share this page on Twitter ](https://twitter.com/intent/tweet?url=https://blog.promethium.ai/post/redshift-connector) [Send us an email ](mailto:?body=https://blog.promethium.ai/post/redshift-connector)   The Redshift connector allows data to be cataloged, queried, transformed and to create tables in Redshift. This can be used to quickly and easily join data between different systems like Redshift and Hive, or between different Redshift instances. The Redshift connector is available for the Promethium Enterprise edition. The Redshift connector is currently not available for the Free or Professional editions. ---  If you don't have a Promethium account, get your [free account now](https://onboarding.pm61data.cloud/user/register) [Jump to the how to video.](https://blog.promethium.ai/post/redshift-connector#video) --- ## **Connect **Redshift Connecting to Redshift is fast and easy. Simply click **Data Sources** from the menu, then click **+ New Data Source**. Select Redshift and enter the information for your Redshift. ![Image of Redshift connection in Promethium](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/35da03_1a1906087aa34961ba1b6fab01c9a4da~mv2.png?width=1476&height=1030&name=35da03_1a1906087aa34961ba1b6fab01c9a4da~mv2.png) ## Redshift Connection Redshift connection details can be case-sensitive. Ensure that data is entered with the correct case for your Redshift database. | **Field**   | **Description**   | | --- | --- | | Data Source Name   | Give the Redshift connection a unique name for easy identification.   | | Description   | Optional. A meaningful description for this connection.   | | Host Name   | Enter the host name for your Redshift database. For example: [db.company.com](http://db.company.com)   | | DB Port   | Enter the port number for your Redshift database.   | | User Name   | ​Enter the username associated with your Redshift account.   | | Password   | Enter the password associated with your Redshift account.   | | Database Name   | Enter the database containing the data you want to retrieve.   |   ## What Happens Next - Finish Redshift Connection  Click the **Connect** button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Redshift, then make the data easily searchable and usable   Click **Data Explorer** from the menu and begin exploring the data in your Redshift Data Cloud. ![Redshift Data Catalog Promethium Screenshot](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/35da03_5a81e3069318451596fbf13b0b73ee04~mv2.png?width=3050&height=1904&name=35da03_5a81e3069318451596fbf13b0b73ee04~mv2.png)     ## FAQs ### Is my data moved or copied out of Redshift? No. Your data stays in Redshift and isn't moved to Promethium.   ### What options are available for publishing datasets? Datasets can be published as a view, as a table in Redshift or as a dbt model.   ### Is this a Production-level connector? Yes. The Redshift connector is designed for all-sized Datasets.   ## Watch how to video           [Product Documentation](https://blog.promethium.ai/tag/product-documentation), [Data Discovery](https://blog.promethium.ai/tag/data-discovery), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## Related posts [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-40-59-14-PM.png?height=200&name=file-Apr-26-2022-04-40-59-14-PM.png) ](https://blog.promethium.ai/post/featured-job-opening-software-developer-react-redux) ## [Featured Job Opening | Software Developer React Redux](https://blog.promethium.ai/post/featured-job-opening-software-developer-react-redux) [Brett Arnott, VP Marketing](https://blog.promethium.ai/author/brett-arnott-vp-marketing) Apr 2, 2021 12:00:00 AM Promethium is committed to using the latest technologies to create products that help our customers... [ Read more ](https://blog.promethium.ai/post/featured-job-opening-software-developer-react-redux) [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-25-46-PM.png?height=200&name=file-Apr-26-2022-04-41-25-46-PM.png) ](https://blog.promethium.ai/post/why-the-industry-is-gonzos-over-augmented-data-management) ## [Why the Industry is Gonzo Over Augmented Data Management](https://blog.promethium.ai/post/why-the-industry-is-gonzos-over-augmented-data-management) [Kaycee Lai](https://blog.promethium.ai/author/kaycee-lai) Sep 16, 2019 12:00:00 AM Gartner projects that manual data management tasks will be reduced by 45 percent in the next three... [ Read more ](https://blog.promethium.ai/post/why-the-industry-is-gonzos-over-augmented-data-management) [![](https://blog.promethium.ai/hs-fs/hubfs/Imported_Blog_Media/file-Apr-26-2022-04-41-38-68-PM.png?height=200&name=file-Apr-26-2022-04-41-38-68-PM.png) ](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics) [Data Discovery](https://blog.promethium.ai/tag/data-discovery), [Data Catalog](https://blog.promethium.ai/tag/data-catalog) ## [5 Reasons Why You Need More Than a Data Catalog For Fast Data Analytics](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics) [Brett Arnott, VP Marketing](https://blog.promethium.ai/author/brett-arnott-vp-marketing) Sep 24, 2020 12:00:00 AM Ask many data teams about how they fulfill data requests for business analytics and they will say,... [ Read more ](https://blog.promethium.ai/post/5-reasons-why-you-need-more-than-a-data-catalog-for-fast-data-analytics)