Hello,
I am getting an error when trying to execute the register command.

When trying to run this command
$ modelstar register forecast:univariate_time_series_forecast
I get the error message below, as the last message in terminal:

snowflake.connector.errors.ProgrammingError: 001003 (42000): SQL compilation error:
syntax error line 1 at position 57 unexpected 'Drive'.
syntax error line 1 at position 62 unexpected '/'.
syntax error line 1 at position 71 unexpected 'Notebook'.
syntax error line 1 at position 79 unexpected '/'.
syntax error line 1 at position 96 unexpected '/'.
syntax error line 1 at position 107 unexpected '/'.
syntax error line 1 at position 112 unexpected '/'.
syntax error line 1 at position 126 unexpected '.'.
syntax error line 1 at position 131 unexpected '@DEV/univariate_time_series_forecast/V1'.

Any suggestions on how this can be fixed?

We should make sure tables created from our functions follow Snowflake naming convention. Otherwise, quotation marks are needed when writing SQL script, which is not convenient.

Environment:

Python version: 3.0

How to reproduce:

Cloned the master branch;
Installed the new version;
Run > modelstar init my_project;
See the following errors.

Error message:

Traceback (most recent call last):
File "/Users/helix/Library/Caches/pypoetry/virtualenvs/modelstar-DLhzjXZT-py3.9/bin/modelstar", line 3, in
from modelstar.cli import main
File "/Users/helix/Documents/modelstar/modelstar/src/modelstar/init.py", line 6, in
session_registry = SessionRegistry()
File "/Users/helix/Documents/modelstar/modelstar/src/modelstar/utils/logging.py", line 56, in init
self.load_registry()
File "/Users/helix/Documents/modelstar/modelstar/src/modelstar/utils/logging.py", line 63, in load_registry
with open(self.file_path, 'w') as doc:
FileNotFoundError: [Errno 2] No such file or directory: '/Users/helix/Documents/modelstar/.modelstar/session.registry.yaml'

When writing a DataFrame result from a CALL SPROC. The return DataFrame if it has a DateTIme column is not parsed properly and is written as a SQL Number type. This could possibly be solved by converting it first into a Snowflake_DF and then writing it to the Table.

# Convert the Pandas dataframe into a Snowflake dataframe
df_sf = snowpark_session.create_dataframe(df_pd)  
  
# Write the results of the dataframe into a target table
df_sf.write.mode("overwrite").save_as_table(destination_table)

See this error when running > modelstar register example.py add_func

To reproduce:

1. Clone the new repo, and update modelstar to 0.1.0 through > poetry install
2. Create a new modelstar proj: >modelstar init test_1/
3. Update project configs following the example on Notion: https://www.notion.so/modelstar/Vault-secrets-Do-NOT-share-41527185cb584244b7fe3bd035a856b7#061515bcdc2f4c40b877dc22ae9e8113
4. Register add() in example.py using command > modelstar register example.py add, successfully.
5. Rename add() to add_func() in example.py, run register command > modelstar register example.py add_func. It showed the following error:

(modelstar-py3.9) helix@PyWebIO test_1 % modelstar register example.py add_func
Registering `example.py` function... 
example.py check done.
/Users/helix/Documents/modelstar/modelstar/test_1/functions/example.py
("Python Interpreter Error:\nAttributeError: module 'example' has no attribute 'add_func' in function ADD_FUNC with handler example.add_func",)

6. If I do not rename add(), instead, just append a new func called add_func(), and run > modelstar register example.py add_func, no errors show up.