SNOW-928897: Calling SPROC throws error module has no attribute

[cedric-ejara]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

   Python 3.10.7 (main, May 29 2023, 13:51:48) [GCC 12.2.0]

2. What operating system and processor architecture are you using?

Linux-5.19.0-46-generic-x86_64-with-glibc2.36

3. What are the component versions in the environment (pip freeze)?

aiohttp==3.8.5 aiosignal==1.3.1 alembic==1.12.0 amqp==5.1.1 anyio==4.0.0 apache-airflow==2.7.0 apache-airflow-providers-celery==3.3.3 apache-airflow-providers-common-sql==1.7.1 apache-airflow-providers-ftp==3.5.1 apache-airflow-providers-http==4.5.1 apache-airflow-providers-imap==3.3.1 apache-airflow-providers-slack==8.0.0 apache-airflow-providers-snowflake==5.0.0 apache-airflow-providers-sqlite==3.4.3 apispec==6.3.0 argcomplete==3.1.1 asgiref==3.7.2 asn1crypto==1.5.1 async-timeout==4.0.3 attrs==23.1.0 Babel==2.12.1 backoff==2.2.1 bcrypt==4.0.1 billiard==4.1.0 blinker==1.6.2 boto3==1.28.40 botocore==1.31.40 cachelib==0.9.0 cattrs==23.1.2 celery==5.3.4 certifi==2023.7.22 cffi==1.15.1 charset-normalizer==3.2.0 click==8.1.7 click-didyoumean==0.3.0 click-plugins==1.1.1 click-repl==0.3.0 clickclick==20.10.2 cloudpickle==2.0.0 colorama==0.4.6 colorlog==4.8.0 ConfigUpdater==3.1.1 connexion==2.14.2 cron-descriptor==1.4.0 croniter==1.4.1 cryptography==41.0.3 Deprecated==1.2.14 dill==0.3.7 dnspython==2.4.2 docutils==0.20.1 email-validator==1.3.1 exceptiongroup==1.1.3 filelock==3.12.3 Flask==2.2.5 Flask-AppBuilder==4.3.3 Flask-Babel==2.0.0 Flask-Caching==2.0.2 Flask-JWT-Extended==4.5.2 Flask-Limiter==3.5.0 Flask-Login==0.6.2 Flask-Session==0.5.0 Flask-SQLAlchemy==2.5.1 Flask-WTF==1.1.1 flower==2.0.1 frozenlist==1.4.0 google-re2==1.1 googleapis-common-protos==1.60.0 graphviz==0.20.1 greenlet==2.0.2 grpcio==1.57.0 gunicorn==21.2.0 h11==0.14.0 httpcore==0.17.3 httpx==0.24.1 humanize==4.8.0 idna==3.4 importlib-resources==6.0.1 inflection==0.5.1 iniconfig==2.0.0 itsdangerous==2.1.2 Jinja2==3.1.2 jmespath==1.0.1 jsonschema==4.19.0 jsonschema-specifications==2023.7.1 kombu==5.3.2 lazy-object-proxy==1.9.0 limits==3.6.0 linkify-it-py==2.0.2 lockfile==0.12.2 Mako==1.2.4 Markdown==3.4.4 markdown-it-py==3.0.0 MarkupSafe==2.1.3 marshmallow==3.20.1 marshmallow-oneofschema==3.0.1 marshmallow-sqlalchemy==0.26.1 mdit-py-plugins==0.4.0 mdurl==0.1.2 multidict==6.0.4 mysqlclient==2.2.0 numpy==1.25.2 openlineage-airflow==1.1.0 openlineage-integration-common==1.1.0 openlineage-python==1.1.0 openlineage_sql==1.1.0 opentelemetry-api==1.15.0 opentelemetry-exporter-otlp==1.15.0 opentelemetry-exporter-otlp-proto-grpc==1.15.0 opentelemetry-exporter-otlp-proto-http==1.15.0 opentelemetry-proto==1.15.0 opentelemetry-sdk==1.15.0 opentelemetry-semantic-conventions==0.36b0 ordered-set==4.1.0 oscrypto==1.3.0 packaging==23.1 paramiko==3.3.1 pathspec==0.11.2 pendulum==2.1.2 platformdirs==3.8.1 pluggy==1.3.0 prison==0.2.1 prometheus-client==0.17.1 prompt-toolkit==3.0.39 protobuf==4.24.2 psutil==5.9.5 psycopg2==2.9.7 pyarrow==13.0.0 pycparser==2.21 pycryptodomex==3.18.0 pydantic==1.10.12 Pygments==2.16.1 PyJWT==2.8.0 PyMySQL==1.1.0 PyNaCl==1.5.0 pyOpenSSL==23.2.0 pytest==7.4.1 python-daemon==3.0.1 python-dateutil==2.8.2 python-nvd3==0.15.0 python-slugify==8.0.1 pytz==2023.3 pytzdata==2020.1 PyYAML==6.0.1 redis==5.0.0 referencing==0.30.2 requests==2.31.0 requests-toolbelt==1.0.0 rfc3339-validator==0.1.4 rich==13.5.2 rich-argparse==1.3.0 rpds-py==0.10.0 s3transfer==0.6.2 setproctitle==1.3.2 six==1.16.0 slack-sdk==3.21.3 sniffio==1.3.0 snowflake-connector-python==3.2.0 snowflake-snowpark-python==1.8.0 snowflake-sqlalchemy==1.5.0 sortedcontainers==2.4.0 SQLAlchemy==1.4.49 SQLAlchemy-JSONField==1.0.1.post0 SQLAlchemy-Utils==0.41.1 sqlparse==0.4.4 tabulate==0.9.0 tenacity==8.2.3 termcolor==2.3.0 text-unidecode==1.3 tomli==2.0.1 tomlkit==0.12.1 tornado==6.3.3 typing_extensions==4.7.1 tzdata==2023.3 uc-micro-py==1.0.2 unicodecsv==0.14.1 urllib3==1.26.16 vine==5.0.0 wcwidth==0.2.6 Werkzeug==2.2.3 wrapt==1.15.0 WTForms==3.0.1 yarl==1.9.2

4. What did you do?

   
   ================================
   sproc.py file
   def main(session: snowpark.Session) -> int:
   print(session)
   print("testing " + str("testing"))
   return 1
   ===============================

sproc_file_path = os.path.join(transform_sproc_path, table["schema_table"].replace(".", "/"), "sproc.py") sproc_name: str = 'sproc'

session.add_packages('snowflake-snowpark-python')

create temp stage and put file

session.sql(f"CREATE TEMPORARY STAGE IF NOT EXISTS sproc_store").collect() session.file.put(sproc_file_path, "@sproc_store", auto_compress=False)

my_sproc: StoredProcedure = session.sproc.register_from_file( file_path=f"@sproc_store/sproc.py", func_name=sproc_name, return_type=T.IntegerType(), input_types=[], name=sproc_name, replace=True,

stage_location="@sproc_store",

is_permanent=False

)

self.snowpark_session.call(f'@sproc_store/{sproc_name}')

my_sproc()

6. What did you expect to see?

   I am expecting snowflake to run the sproc function and give me result.

7. Can you set logging to DEBUG and collect the logs?

snowflake.snowpark.exceptions.SnowparkSQLException: (1304): 01af60bf-0302-dc21-0001-330e0198d13a: 100357 (P0000): 01af60bf-0302-dc21-0001-330e0198d13a: Python Interpreter Error:
AttributeError: module 'sproc' has no attribute 'sproc' in function SPROC with handler sproc.sproc

[sfc-gh-stan]

Hi @cedric-ejara , the function name is the name of the handler function defined in sproc.py. The error message here means it is trying to find a handler function called sproc in sproc.py.

[cedric-ejara]

@sfc-gh-stan thank you.