Athena

Connecting to Athena

For an overview of the connector, please refer to the following link.

• Connecting to DB/SaaS

• Dashboard
• Local Version

1

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.

2

Enter Athena Credentials

Select Athena and enter the authentication method.

After entering, press the Create button to complete the creation. If there are any errors in the parameters, an error will be displayed, so please check if the connection details are correct.

3

Connect to the Created Database

Once created successfully, you can obtain the connector name from the list display.

Enter the created connector name in the SQL or Python code to retrieve data.

SQL

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

1

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.

2

Enter Athena Credentials

Select Athena and enter the authentication method.

After entering, press the Create button to complete the creation. If there are any errors in the parameters, an error will be displayed, so please check if the connection details are correct.

3

Connect to the Created Database

Once created successfully, you can obtain the connector name from the list display.

Enter the created connector name in the SQL or Python code to retrieve data.

SQL

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

In the local version, you currently need to directly write the authentication information in ~/.morph/connections.yml. Please create it in the dashboard if you prefer other methods.

1

Edit connections.yml

If the file does not exist in ~/.morph/connections.yml, please create it beforehand and then edit it.

shell

mkdir ~/.morph
touch ~/.morph/connections.yml

connections:
  athena-connection: # Unique arbitrary name
    type: athena # Fixed
    access_key: str
    secret_key: str
    session_token: str
    region: str
    catalog: str
    database: str # Optional
    work_group: str # Optional

2

Retrieve Data Using the Connector in Code

Enter the created connector name in the SQL or Python code to retrieve data.

SQL

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

Refreshing the access token is a dashboard feature, so the one specified will always be used in the local environment.

When actually specifying and executing the file with the connector, the priority is as follows. Also, please note that only connectors created in the dashboard can be used in the environment where morph deploy is performed.

1. Connectors listed in ~/.morph/connections.yml on the local machine
2. Connectors registered in the cloud