Skip to main content
Home

Secondary Menu

  • Community
  • Developer Help
  • Support

Main navigation

  • Release Notes
  • License and Activate
  • Download Products

Amazon Redshift

Version:
2019.3
Last modified: September 27, 2019

Load Metadata from an Amazon Redshift Database

Use the Redshift Loader to upload metadata to Alteryx Connect for a specified Amazon Redshift database.

2019.3
Product Reference
Connect

Review Loader Requirements

The Alteryx Connect Loaders must be installed on the machine where Alteryx Server is installed. To install the loaders:

  1. Download the loaders installer. For compatibility, the Loaders installer version must match the Alteryx Connect version.
  2. Run the installer as an administrator.

The ODBC Amazon Redshift driver must be installed. You can download it here.

Open The Loader

  1. Open Alteryx Designer.
  2. Click Help > Sample Workflows > Alteryx Connect Metadata Loaders > Redshift Loader > Redshift Loader.

Run The App

  1. Click Run as Analytic App .
  2. In the Redshift server tab:

    • Type the Redshift connection information, including server, port, database, and credentials.
    • In Schemas to load, optionally specify a comma-separated list of schemas. Leave blank to load all schemas.
    1. In the Alteryx Connect tab, type the URL for your Alteryx Connect instance and your credentials. 
      https://yourcompany.alteryxconnect.com

    2. Before running the app, click  and save the app configuration to the following directory: 
      C:\ProgramData\Alteryx\AlteryxConnect\Redshift_Loader\

      The .yxwv app values file is used for scheduling the loader to run in the Gallery. See Schedule Metadata Loaders.

  3. Click Finish to run the app.
    • If the run succeeds, "Success" appears in the App Results window.
    • If the run fails, a "There were Errors" message appears.

    Depending on how much metadata is being imported, the app can take a long time to run.

View Metadata

  1. Go to the Alteryx Connect URL and log in.
  2. From the main menu, click Data Sources > Databases.
  3. Select a folder to view its contents.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.

In this Metadata:

  • Review Loader Requirements
  • Open the Loader
  • Run the App
  • View Metadata

Main navigation

  • Release Notes
  • License and Activate
  • Download Products

Secondary Menu

  • Community
  • Developer Help
  • Support

Breadcrumb

  1. Home
Alteryx

Ask The Community

Post questions and get answers from our community of data science and analytic experts.
Ask Now

Contact Support

Contact

Product Menu

  • About
  • Credits
  • Usage Data

Footer Main Navigation

  • Release Notes
  • License and Activate
  • Download Products