Skip to main content

PostgreSQL

Heimdall offers a direct connection to your PostgreSQL database, 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 PostgreSQL as a data source. You will then be prompted to enter your PostgreSQL connection parameters.

Connection Parameters​

  • Hostname - the hostname of your database
  • Port - the port of your database. If not provided, defaults to 5432.
  • Database - the database to access within your PostgreSQL DB
  • 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 PostgreSQL database.

Importing and Using your Data​

Once you've provided the connection parameters for your PostgreSQL database, 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.