SNOWFLAKE JSON QUERY CODE

External Function values are computed using external resources, and the results are returned via HTTP.įor example, if you had access to an external service that mapped zip codes to cities, the typical approach to leveraging this service without external functions would be to import the keys and values of cities and zip-codes to a table and then query that table. When making a call to a function, the value is computed using Snowflake's compute resources. Instead, they are hosted elsewhere, accessed via an HTTP endpoint, and computed using third-party compute resources. External Functions are similar, except they are not hosted on Snowflake, and do not execute within the context of your data warehouse.

SNOWFLAKE JSON QUERY CODE

The code itself is written by developers and is intended to add features and functionality to your data warehouse, beyond the traditional SQL commands that Snowflake already offers. What does this mean? Let's break it down.įunctions are pieces of Javascript or SQL code that execute in your data warehouse.

External FunctionsĮxternal Functions in Snowflake are functions hosted on a different platform. In this post, we're going to discuss one of those features, External Functions. Recently they announced a few new product features. In recent years they've dominating the cloud data-warehouse industry. They specialize in provisioning on-demand compute and elastic storage for data warehousing applications on a pay-per-use pricing model.

Snowflake is a cloud-based data warehousing company.

Snowflake json query