{"id":124465,"url":"https://github.com/kaarthik108/snowChat","last_synced_at":"2026-06-15T16:30:20.417Z","repository":{"id":161838779,"uuid":"626161045","full_name":"kaarthik108/snowChat","owner":"kaarthik108","description":"Chat snowflake - Text to SQL","archived":false,"fork":false,"pushed_at":"2025-02-16T19:23:23.000Z","size":212,"stargazers_count":553,"open_issues_count":9,"forks_count":285,"subscribers_count":13,"default_branch":"main","last_synced_at":"2026-06-10T14:04:47.914Z","etag":null,"topics":["agents","chatgpt","langchain","langgraph","llama","snowflake","snowpark","streamlit","supabase"],"latest_commit_sha":null,"homepage":"https://snowchat.streamlit.app/","language":"Python","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":null,"status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/kaarthik108.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":".github/FUNDING.yml","license":null,"code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null},"funding":{"github":["kaarthik108"]}},"created_at":"2023-04-10T23:31:01.000Z","updated_at":"2026-06-09T15:24:16.000Z","dependencies_parsed_at":"2024-04-18T23:35:14.902Z","dependency_job_id":"701a3cc2-0357-4d27-8137-d8934c14c807","html_url":"https://github.com/kaarthik108/snowChat","commit_stats":{"total_commits":130,"total_committers":1,"mean_commits":130.0,"dds":0.0,"last_synced_commit":"55015f9cd081b28e5ea34ca63ad96e9b1acada99"},"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/kaarthik108/snowChat","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kaarthik108","download_url":"https://codeload.github.com/kaarthik108/snowChat/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":34326240,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-05-26T15:22:16.424Z","status":"online","status_checked_at":"2026-06-14T02:00:07.365Z","response_time":62,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"}},"owner":{"login":"kaarthik108","name":"Kaarthik Andavar","uuid":"53030784","kind":"user","description":" Master | Data Analyst | Machine Learning \r\n    \r\n","email":"","website":null,"location":"New Zealand","twitter":"feetup_andy","company":null,"icon_url":"https://avatars.githubusercontent.com/u/53030784?u=828592a9a6d78896f1e6338fcc1686ebc87be7f2\u0026v=4","repositories_count":1,"last_synced_at":"2023-03-05T12:28:04.305Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/kaarthik108","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-15T16:21:27.341Z","updated_at":"2023-03-05T12:28:04.312Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kaarthik108","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/kaarthik108/repositories"},"packages":[],"commits":{"id":1639974,"full_name":"kaarthik108/snowChat","default_branch":"main","total_commits":135,"total_committers":2,"total_bot_commits":0,"total_bot_committers":0,"mean_commits":67.5,"dds":0.014814814814814836,"past_year_total_commits":0,"past_year_total_committers":0,"past_year_total_bot_commits":0,"past_year_total_bot_committers":0,"past_year_mean_commits":0.0,"past_year_dds":0.0,"last_synced_at":"2026-06-12T15:01:31.366Z","last_synced_commit":"d0c2520e5a785f3a0fe496630a510015ef04c342","created_at":"2024-07-25T15:32:59.276Z","updated_at":"2026-06-12T15:01:31.346Z","committers":[{"name":"kaarthik108","email":"kaarthikandavar@gmail.com","login":"kaarthik108","count":133},{"name":"kaarthik-tracksuit","email":"kaarthik.andavar@gotracksuit.com","login":"kaarthik-tracksuit","count":2}],"past_year_committers":[],"commits_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/commits","host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2026-06-14T00:00:10.507Z","repositories_count":6259209,"commits_count":882489130,"contributors_count":35084035,"owners_count":1166429,"icon_url":"https://github.com/github.png","host_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://commits.ecosyste.ms/api/v1/hosts/GitHub/repositories"}},"issues":{"table":{"full_name":"kaarthik108/snowChat","html_url":"https://github.com/kaarthik108/snowChat","last_synced_at":"2026-05-25T06:01:59.167Z","status":"error","issues_count":15,"pull_requests_count":5,"avg_time_to_close_issue":4546552.0,"avg_time_to_close_pull_request":20885.0,"issues_closed_count":7,"pull_requests_closed_count":4,"pull_request_authors_count":3,"issue_authors_count":13,"avg_comments_per_issue":1.2666666666666666,"avg_comments_per_pull_request":0.4,"merged_pull_requests_count":3,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":1,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"created_at":"2024-07-25T15:33:30.373Z","updated_at":"2026-05-25T06:01:59.168Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/kaarthik108%2FsnowChat/issues","issue_labels_count":{"table":{}},"pull_request_labels_count":{"table":{}},"issue_author_associations_count":{"table":{"NONE":15}},"pull_request_author_associations_count":{"table":{"OWNER":3,"NONE":2}},"issue_authors":{"table":{"ewosl":2,"sureshsinganamala":2,"LouisMonierSpark":1,"vansinhu":1,"kshitijyad":1,"TITC":1,"esanketkulkarni":1,"Ka7arotto":1,"erin-040702":1,"brianjking":1,"DeqianBai":1,"Arush04":1,"FaizelK":1}},"pull_request_authors":{"table":{"kaarthik108":3,"ishaan-jaff":1,"andmmenendez":1}},"host":{"table":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2026-06-08T00:00:18.161Z","repositories_count":14785708,"issues_count":33505542,"pull_requests_count":110273062,"authors_count":11295832,"icon_url":"https://github.com/github.png","host_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories","owners_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/owners","authors_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors"}},"past_year_issue_labels_count":{"table":{}},"past_year_pull_request_labels_count":{"table":{}},"past_year_issue_author_associations_count":{"table":{"NONE":1}},"past_year_pull_request_author_associations_count":{"table":{}},"past_year_issue_authors":{"table":{"Ka7arotto":1}},"past_year_pull_request_authors":{"table":{}},"maintainers":[{"table":{"login":"kaarthik108","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/kaarthik108"}}],"active_maintainers":[]}},"events":{"total":{"PullRequestEvent":2,"ForkEvent":49,"WatchEvent":103,"IssueCommentEvent":2,"PushEvent":14,"CreateEvent":1},"last_year":{"ForkEvent":9,"WatchEvent":20}},"keywords":["agents","chatgpt","langchain","langgraph","llama","snowflake","snowpark","streamlit","supabase"],"dependencies":[{"ecosystem":"actions","filepath":".github/workflows/lint.yml","sha":null,"kind":"manifest","created_at":"2023-07-25T20:16:23.445Z","updated_at":"2023-07-25T20:16:23.445Z","repository_link":"https://github.com/kaarthik108/snowChat/blob/main/.github/workflows/lint.yml","dependencies":[{"id":12015274926,"package_name":"actions/checkout","ecosystem":"actions","requirements":"v3","direct":true,"kind":"composite","optional":false},{"id":12015274927,"package_name":"actions/setup-python","ecosystem":"actions","requirements":"v2","direct":true,"kind":"composite","optional":false}]},{"ecosystem":"pypi","filepath":"requirements.txt","sha":null,"kind":"manifest","created_at":"2023-07-25T20:16:23.482Z","updated_at":"2023-07-25T20:16:23.482Z","repository_link":"https://github.com/kaarthik108/snowChat/blob/main/requirements.txt","dependencies":[{"id":12015274929,"package_name":"langchain","ecosystem":"pypi","requirements":"==0.0.220","direct":true,"kind":"runtime","optional":false},{"id":12015274930,"package_name":"pandas","ecosystem":"pypi","requirements":"==1.5.0","direct":true,"kind":"runtime","optional":false},{"id":12015274931,"package_name":"pydantic","ecosystem":"pypi","requirements":"==1.10.8","direct":true,"kind":"runtime","optional":false},{"id":12015274932,"package_name":"snowflake_snowpark_python","ecosystem":"pypi","requirements":"==1.5.0","direct":true,"kind":"runtime","optional":false},{"id":12015276845,"package_name":"snowflake-snowpark-python","ecosystem":"pypi","requirements":"*","direct":true,"kind":"runtime","optional":false},{"id":12015276846,"package_name":"streamlit","ecosystem":"pypi","requirements":"==1.24.0","direct":true,"kind":"runtime","optional":false},{"id":12015276847,"package_name":"supabase","ecosystem":"pypi","requirements":"==1.0.3","direct":true,"kind":"runtime","optional":false},{"id":12015276856,"package_name":"unstructured","ecosystem":"pypi","requirements":"==0.7.12","direct":true,"kind":"runtime","optional":false},{"id":12015276857,"package_name":"tiktoken","ecosystem":"pypi","requirements":"==0.4.0","direct":true,"kind":"runtime","optional":false},{"id":12015276858,"package_name":"openai","ecosystem":"pypi","requirements":"==0.27.8","direct":true,"kind":"runtime","optional":false},{"id":12015276859,"package_name":"black","ecosystem":"pypi","requirements":"==23.3.0","direct":true,"kind":"runtime","optional":false},{"id":12015276860,"package_name":"replicate","ecosystem":"pypi","requirements":"==0.8.4","direct":true,"kind":"runtime","optional":false}]}],"score":7.024649030453636,"created_at":"2024-07-25T15:26:10.901Z","updated_at":"2026-06-15T16:30:20.417Z","avatar_url":"https://github.com/kaarthik108.png","language":"Python","codemeta":null,"publiccode":null,"project_url":"https://summary.ecosyste.ms/api/v1/projects/124465","html_url":"https://summary.ecosyste.ms/projects/124465"}