# I'm trying to reproduce the steps from the GR and Airflow tutorial with no success

**URL:** <https://discourse.greatexpectations.io/t/im-trying-to-reproduce-the-steps-from-the-gr-and-airflow-tutorial-with-no-success/1685>\
**Category:** GX Core Support\
**Created:** [March 29, 2024, 8:28am UTC](https://discourse.greatexpectations.io/t/im-trying-to-reproduce-the-steps-from-the-gr-and-airflow-tutorial-with-no-success/1685 "2024-03-29T08:28:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![greatskr](https://avatars.discourse-cdn.com/v4/letter/g/e68b1a/32.png) [@greatskr](https://discourse.greatexpectations.io/u/greatskr)\
**Post date:** [March 29, 2024, 8:28am UTC](https://discourse.greatexpectations.io/t/im-trying-to-reproduce-the-steps-from-the-gr-and-airflow-tutorial-with-no-success/1685/1 "2024-03-29T08:28:09Z")

</div>

I executed all steps from this tutorial [Orchestrate Great Expectations with Airflow | Astronomer Documentation](https://docs.astronomer.io/learn/airflow-great-expectations) but gx\_tutorial DAG is failing. Have somebody else experienced such problem and what might be the potential issues? It seems that the table cannot be created:

| 2024-03-29, 08:24:38 | None | graph\_data | None | admin | [(‘dag\_id’, ‘gx\_tutorial’)] |
| --- | --- | --- | --- | --- | --- |
| 2024-03-29, 07:39:52 | gx\_validate\_pg | task | 2024-03-29 07:23:29.407087+00:00 | admin | [(‘dag\_id’, ‘gx\_tutorial’), (‘task\_id’, ‘gx\_validate\_pg’), (‘execution\_date’, ‘2024-03-29T07:23:29.407087+00:00’), (‘map\_index’, ‘-1’)] |
| 2024-03-29, 07:39:43 | create\_table\_pg | failed | 2024-03-29 07:39:40.313904+00:00 | airflow | None |

If I run airflow test locally I have this issue:

During handling of the above exception, another exception occurred:

Traceback (most recent call last):  
File “”, line 198, in _run\_module\_as\_main  
File “”, line 88, in run\_code  
File "C:\Users\user\AppData\Local\Programs\Python\Python312\Scripts\airflow.exe\_main.py", line 4, in   
File "C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\_init_.py", line 52, in   
from airflow import configuration, settings  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\configuration.py”, line 2340, in   
secrets\_backend\_list = initialize\_secrets\_backends()  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\configuration.py”, line 2254, in initialize\_secrets\_backends  
secrets\_backend\_cls = import\_string(class\_name)  
^^^^^^^^^^^^^^^^^^^^^^^^^  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\utils\module\_loading.py”, line 37, in import\_string  
module = import\_module(module\_path)  
^^^^^^^^^^^^^^^^^^^^^^^^^^  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\importlib\__init_\_.py”, line 90, in import\_module  
return \_bootstrap.\_gcd\_import(name[level:], package, level)  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\secrets\metastore.py”, line 29, in   
from airflow.utils.session import NEW\_SESSION, provide\_session  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\utils\session.py”, line 24, in   
from airflow import settings  
File “C:\Users\user\AppData\Local\Programs\Python\Python312\Lib\site-packages\airflow\settings.py”, line 57, in   
TIMEZONE = pendulum.tz.timezone(“UTC”)  
TypeError: ‘module’ object is not callable

I have the latest python, airflow and pendulum versions. The example DAGs are working correctly. I guess it’s something related to the postgres connection but I can’t find out what it is.

---

<div class="post-metadata">

**Author:** ![greatskr](https://avatars.discourse-cdn.com/v4/letter/g/e68b1a/32.png) [@greatskr](https://discourse.greatexpectations.io/u/greatskr)\
**Post date:** [April 4, 2024, 8:38am UTC](https://discourse.greatexpectations.io/t/im-trying-to-reproduce-the-steps-from-the-gr-and-airflow-tutorial-with-no-success/1685/2 "2024-04-04T08:38:42Z")

</div>

Hi all. I finally resolved all issues and run the tutorial successfully. Actually i downgraded the astronomer version in the Docker file in order to avoid the deprecated PostgresOperator in apache ariflow.

This is what I put in the DockerFile  
to FROM [Quay](http://quay.io/astronomer/astro-runtime:6.10.0)

I had problems with the tcp connection as well. It turned out the host that should but put in the Airflow Connection should be postgres, not localhost or 127.0.0.1.

---

<div class="post-metadata">

**Author:** ![ToivoMattila](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/toivomattila/32/254_2.png) [@ToivoMattila](https://discourse.greatexpectations.io/u/ToivoMattila)\
**Post date:** [April 4, 2024, 2:49pm UTC](https://discourse.greatexpectations.io/t/im-trying-to-reproduce-the-steps-from-the-gr-and-airflow-tutorial-with-no-success/1685/3 "2024-04-04T14:49:56Z")

</div>

Good to hear that you got the problem solved!  
Feel free to also mark this issue as solved to help others with the same issue