PinnedSean FalconerinSnowflakeOne Snowflake, Multiple Vaults: A Solution to Data ResidencyData residency requirements, which govern where sensitive data can be stored or processed in the cloud (or in an on-prem server) are a…8 min read·Jun 16, 2023--2--2
Sean FalconerinSnowflakeMaking Batch API Calls in Snowflake with Vectorized UDFsRecently, I was working on a project that required me to use a User Defined Function (UDF) within a Snowflake database query. This function…8 min read·Mar 25, 2024--1--1
Sean FalconerinSnowflakeTransforming CSV Files During Data Loading in SnowflakeI was recently analyzing data from Salesforce to better understand our win/loss conversion rates depending on size of business, lead source…5 min read·Mar 5, 2024----
Sean FalconerinSnowflakeThe One Billion Row Challenge with SnowflakeI recently learned about the One Billion Row Challenge initiated by Gunnar Morling. The challenge is to create a Java program to process a…9 min read·Jan 9, 2024--4--4
Sean FalconerinSnowflakeUnlocking Snowflake Native App Potential with External API CallsSnowflake Native Apps are self-contained data applications that live within the Snowflake data platform. Instead of having to bring the…7 min read·Dec 13, 2023----
Sean FalconerinSnowflakeConnect the Dots: External APIs with Snowflake’s External Network AccessIn the not-so-distant past, specifically earlier this year, calling an external API from Snowflake entailed a somewhat cumbersome process…10 min read·Oct 31, 2023----
Sean FalconerinSnowflakeBuilding a Privacy-Preserving LLM-Based ChatbotAs Large Language Models (LLMs) and generative AI continue to grow more sophisticated and available, many organizations are starting to…11 min read·Aug 21, 2023----
Sean FalconerinSnowflakePrivacy-First AI: Harnessing Snowflake and Skyflow to Customize LLMsLarge Language Models (LLMs) like GPT are powering applications across a range of use cases, from software development to content creation…11 min read·Jun 26, 2023----
Sean FalconerinSnowflakePrivacy-Safe Analytics with Snowflake and SkyflowCompanies need to leverage customer information for their analytics, but how can they do this without risking PII exposure?7 min read·May 3, 2023----
Sean FalconerinSnowflakeKeeping sensitive customer data out of Snowflake with Skyflow and SnowpipeBusinesses need to use customer data to perform analytics and business intelligence. But how can companies analyze and report on detailed…8 min read·Mar 24, 2023--1--1