![snowflake pro automatic save snowflake pro automatic save](https://www.mssqltips.com/tutorialimages/9293_querying-snowflake-power-bi.002.png)
This post will neither explain APIs and how they work, nor will it expect any knowledge of this kind. Enter at your own risk ?ĪPI Knowledge Disclaimer: If you are unfamiliar with APIs and how they work, don’t worry. Be prepared-this process can take some time to set up, and this post is quite lengthy, so you may wish to approach it in stages instead of consuming it all at once.
SNOWFLAKE PRO AUTOMATIC SAVE HOW TO
This post assumes you already have an AWS environment and a basic understanding of how to navigate it. In this blog, we will walk through how to set up some simple Python functions in AWS Lambda to execute as external functions in Snowflake. Their Python model can be set up in an AWS Lambda function and called directly by Snowflake with variables fed directly from Snowflake objects. This is just one example of where an external function could be leveraged to meet the user’s goal. However, not everybody has access to these fantastic tools, or they may have other reasons to want to apply the functionality directly within Snowflake itself. Please note that this is not necessarily a bad thing, and Snowflake have formed strong partnerships with technologies such as Dataiku and DataRobot to provide a heap of powerful functionality and integration. Previously, Snowflake would have been used as the engine to feed data into another tool to allow these statistical models to be applied.
Unlocking More Snowflake Potential with Pythonįor example, many data scientists regularly leverage the advanced capabilities of Python to create statistical models. This is because Snowflake’s standard functionality is supported by ANSI-SQL, which can perform incredible feats of data manipulation on its own however, it cannot achieve the advanced functionality that is possible with languages such as Python. This has unlocked a whole new realm of possibility and flexibility for the Snowflake data platform and allows users to apply complex business functions to their data directly within Snowflake. Among several other capabilities is the ability to create AWS Lambda functions and call them within Snowflake. Recently, Snowflake implemented a new feature that allows its standard functionality to be extended through the use of external functions.
SNOWFLAKE PRO AUTOMATIC SAVE SERIES
This series takes you from zero to hero with the latest and greatest cloud data warehousing platform, Snowflake.