PinnedPublished inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Sciencedbt Constraints: Automatic Primary Keys, Unique Keys, and Foreign Keys for Snowflakedbt Constraints is a new package that generates database constraints based on the tests in a dbt project. Based on the very positive…May 3, 20221May 3, 20221
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceGenerating Private and Public Keys using Streamlit in SnowflakeThis article provides a Streamlit in Snowflake application with a very simple user interface for generating public / private keys and…Jul 8, 2024Jul 8, 2024
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceGenerating Private and Public Keys using Snowflake SnowparkUsing Snowflake key pair authentication instead of passwords is one of the best and easiest ways to improve the security of your service…Jul 2, 20241Jul 2, 20241
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceLLM hallucinations can actually be a feature: Using Snowflake Cortex and Streamlit to generate…In my conversations at this year’s Snowflake Summit, many companies are concerned about utilizing LLM because they have a habit of…Jun 5, 2024Jun 5, 2024
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceHow to run and edit run dbt projects entirely in the cloud using Github and Azure DevOpsOne of the more challenging steps for new users of dbt Core can be setting up a local development environment and an environment for…Jun 5, 2024Jun 5, 2024
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceLoading CSV as Semi-Structured Files in SnowflakeOne of Snowflake’s interesting capabilities is being able to load semi-structured files into a column with the VARIANT data-type…Sep 26, 20224Sep 26, 20224
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceParsing embedded HTML tables in Snowflake Using a Java User Defined Table FunctionIn this article, I will demonstrate how we can extend the text parsing capabilities of the Snowflake Data Cloud using a Java User Defined…Dec 9, 2021Dec 9, 2021
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceUsing DSN-less ODBC Connections from Alteryx and other software to the Snowflake Data CloudThis article demonstrates how to create DSN-less connections from Alteryx and R to SnowflakeDec 8, 2021Dec 8, 2021
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceUsing Rclone to Migrate Data from Oracle into SnowflakeLearn how to use rclone with SnowflakeApr 9, 20211Apr 9, 20211
Published inSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceConnecting Oracle BI to the Snowflake Data CloudWhy use Oracle BI with Snowflake?Apr 2, 20213Apr 2, 20213