Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

dbt python model logging statement not able to put logs inside snowflake event table.

Model Name: Logging_test.py
Code:

import snowflake.snowpark as snowpark
import snowflake.snowpark.functions as f
from snowflake.snowpark.functions import *
import logging
logger = logging.getLogger("dbt_logger")
logger.info("******Inside Logging module.******")
def model(dbt, session):
    session.sql(f"""ALTER SESSION SET LOG_LEVEL = INFO""").collect()
    logger.info("******Logging start.******")
    df=session.sql(f"""select current_user() as session_user,current_role() as session_role""")
    logger.info("******Logging End.******")
    return df

Expected Behavior

dbt model should put log in event table

Steps To Reproduce

1. Set snowflake event table : https://docs.snowflake.com/en/developer-guide/logging-tracing/event-table-setting-up
2. Set connection param in dbt profile.yml file
3. run the dbt python model : dbt run -model logging_test
4. check event table in snowflake setup in step1

   SELECT
       RECORD['severity_text']::STRING log_level ,
       VALUE::STRING message ,
       RESOURCE_ATTRIBUTES['snow.query.id']::STRING query_id
   FROM
       DXRX_OPERATIONS.LOGGING.EVENTS
   WHERE
       SCOPE['name']::STRING = 'dbt_logger'
   ORDER BY
       "TIMESTAMP" DESC;

5. Check query history in snowsight and get the dbt generated store procedure (Sql query start with WITH logging_test__dbt_sp AS PROCEDURE ())
6. Execute the procedure from snowsight and wait for few minute
7. Execute the step 4 query again , it will show you logs generated by Snowsight query id
8. dbt generated query id logs missing from event table ----(it should be there )

Relevant log output

No response

Environment

- OS: window
- Python: 3.8
- dbt:1.7.2

Which database adapter are you using with dbt?

snowflake

Additional Context

While executing the dbt generated store procedure from snowsight, it's working fine and insert logs in event log table