Skip to main content

Amazon Redshift

Heimdall offers a direct connection to your Redshift workgroup/cluster, allowing you to import your tables for use in Heimdall ML and Heimdall Forecast. While selecting the data to use, you will be able to select Redshift as a data source. You will then be prompted to enter your Redshift connection parameters.

Connection Parameters​

  • Hostname(endpoint) - the endpoint url of your workgroup/cluster
important

Remove the ":port/database" at the end of the endpoint url

  • Port - the port of your database. If not provided, defaults to 5439.
  • Database - the database to access within your Redshift workgroup/cluster
  • Username - the username to log into your database with
  • Password - the password to log into your database with
note

Heimdall does not save the connection parameters for your Redshift workgroup/cluster.

Importing and Using your Data​

Once you've provided the connection parameters for your Redshift workgroup/cluster, you will be provided a list of tables to import data from.

tip

Only tables within schemas accessible to the user will be shown. If you cannot find a specific table, make sure the user associated with the username and password provided has permission to access the table.

Select the table you'd like to import data from and click Next. Heimdall will now select all rows from the table and continue the modeling or forecasting process.

Once the process is complete, you'll be provided some high level metrics for your model or forecaster, and can save it with a unique name. It will appear in your inventory, and you'll be able to select it to view more details.