This demo follows the storyline from Machine Learning Demo: Predicting Citibike Trips Using Snowflake & Facebook Prophet with one addition, it uses snowpark, instead of the snowflake python connector.

It works with citibike V4

Steps to install snowpark for python:

• Create Snowpark env with Python 3.8: conda create <env_name> python=3.8
• Activate new environment: conda activate <env_name>
• Download latest Snowpark https://drive.google.com/drive/folders/1clWwh6lvx3KNuT3TfPwdPG-u-phEtwab
• Install Snowpark wheel: pip install 'snowflake_snowpark_python-0.5.0-py3-none-any.whl[pandas]'

Create a new json credential file creds.json following this structure:

{
    "account": "",
    "user": "",
    "password": "",
    "warehouse": "",
    "database": "CITIBIKE",
    "schema": "DEMO"
  }