Skip to main content
Version: v4

Airflow

This chapter shows how to connect from Airflow to Canner Enterprise to retrieve data.

Step 1: Add a connection in Airflow​

Click Connection in the Admin menu at the top to open the connections page, then click the ＋ button on the left to add a connection.

Step 2: Configure the connection​

Configure the connection in the following window.

First, copy the connection information from the Canner Enterprise workspace you want to retrieve data from (see the steps in Canner Protocol Overview), then fill it in on the Airflow settings screen.

  • Connection Id: A name for this connection in Airflow
  • Connection Type: Select Postgres
  • Host: The host or IP address of Canner Enterprise
  • Schema: Corresponds to Database (SQL Name) in Canner Enterprise; enter the SQL Name of this workspace
  • Login: Corresponds to User in Canner Enterprise; enter canner
  • Password: Enter a Personal Access Token. See Get a Personal Access Token
  • Port: Use the port shown under the Share button in Canner Enterprise; the default is 7432

Step 3: Connection complete​

Once connected, the new connection appears in the list below, and you can use this data for any downstream work in Airflow.