Learn how to use Snowpark ML Model Registry libraries to manage HuggingFace Large Language Models (LLMs) in Snowflake. 2023–08–23: At the time of writing this article, Snowpark ML model registry is in Private Preview. …

Learn how to use Snowflake's zero-copy clones, stored procedures, and dbt macros to automate the creation of on-demand developer environments for better collaboration in dbt projects. — Authors: Fabian Hernandez, Ivaylo Boiadjiev Picture a dbt project where each developer can work on their code independently without disrupting the work of others. This guarantees that developers can program their dbt models without creating hindrances for others. Sounds convenient, doesn't it? …

Learn how to deploy pre-trained large language models from Hugging Face in Snowflake using Vectorized Python UDFs. — Disclaimer: The content of this article was initially published on Snowflake Medium publication. The link to the original article can be found here. Large Language Models (LLMs) like ChatGPT have gained popularity for their ability to generate human-like responses to text-based input. …

Learn how to deploy pre-trained large language models from Hugging Face in Snowflake using vectorized Python UDFs. — Large Language Models (LLMs) like ChatGPT have gained popularity for their ability to generate human-like responses to text-based input. However, ChatGPT is only one of many LLMs that has produced impressive results in recent years. Open-source LLMs like BERT (Bidirectional Encoder Representations from Transformers), created by Google researchers in 2018…

Let's learn how to delete Snowflake storage environments using good audit and fallback practices. Snowflake's low storage cost and zero-copy cloning functionality make it an ideal candidate for creating multiple storage environments. Storage environments allow data teams to build and test pipelines separated from where the end product will be…

Learn how to create a Data Science Quickstart project for Snowflake using Jupyter Notebooks, Snowpark, Snowflake connectors, Docker, and VSCode. — Snowflake provides two useful interfaces for developing Data Science projects, Snowpark, and Snowflake connectors. The Snowflake Python Connector provides an interface for developing Python applications that can connect to Snowflake and perform all standard operations. …

Let's learn how to deploy AWS API Gateway methods for OpenAI and Snowflake integrations. OpenAI (the company behind ChatGPT) has an amazing arsenal of pre-trained models to tackle a great variety of Machine Learning problems. Most of this pre-trained model can be consumed and fine-tuned using the companies' API. This…

Learn how to call the OpenAI REST API using Snowflake external functions. OpenAI is an AI research and development company committed to creating ML technology for the benefit of humanity. …

An Infostrux's Architecture approach to AutoML in Snowflake. Writing Credits: Fabian Hernandez, Milan Mosny, Augusto Kiniama Rosa Automated Machine Learning (AutoML) solutions can reduce time-demanding tasks (such as manual coding or model deployment) when creating ML products. Furthermore, these ML solutions can help standardize the organization's Machine Learning development cycle. …