- Your Alteryx deployment must be connected to a running instance of Redshift.
- The Redshift browser appears when:
- You select the Redshift connection to create a dataset. See Import Data Page.
- You choose to add a publishing location in Redshift. See Run Job Page.
When exporting results, you can choose to write to a Redshift database. See Publishing Dialog.
- For more information on interacting with Redshift, see Using Redshift.
Use the links and icons to browse for Redshift databases, schemas, and tables. When you select a Redshift database, you can select one of the available schema objects. Selecting a schema displays the tables and views that use that schema.
NOTE: Avoid using the Back button on your browser, which exits the Redshift browser without applying changes to your configuration.
|Schema||Click a schema link to display the tables and views that use the schema.|
Click the Plus icon to select this Redshift table as your source.
Click the Plus icon to select this view as your source.
NOTE: Previewing complex views may impact performance.
Use these links to navigate between pages of databases and tables.
NOTE: In some cases, subsequent pages of tables may be blank, and counts of tables may not match displayed figures. This is a known issue.
Click the links in the breadcrumb trail to navigate.
To filter the list of databases or tables, enter a string in the Search box. The filter is applied as you type and matches anywhere in the name of a currently displayed database or table name.
Preview Table Data
Database tables are displayed by name only. To preview the data in the table, click the Eye icon next to the name of the table.
Tip: Table previews include available metadata information, such as column headers and column and row counts.
Create Dataset with SQL
As needed, you can pre-filter the selected table or view inside the database. By entering a custom SQL statement, you can remove unnecessary data from the dataset that is extracted from the database, which enables faster and more meaningful imports of your database data. See Create Dataset with SQL.This feature may require enabling in your workspace. For more information, see Workspace Settings Page.
This page has no comments.