PinnedJeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceReduce Your DBA’s Burden with SnowflakeToday’s DBA typically manages 10s, 100s or even 1000s of databases, often from multiple vendors, both on premise and in the cloud. These…Feb 11, 2021Feb 11, 2021
PinnedJeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceAgile Cost Management in Snowflake — Part 1, ComputeSnowflake’s revolutionary architecture brings new opportunities and approaches to managing the cost of running its cloud data warehouse…Feb 11, 2021Feb 11, 2021
PinnedJeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceAgile Cost Management in Snowflake — Part 2, StorageIn Agile Cost Management in Snowflake — Part 1, Compute, we discussed managing compute costs. Managing storage costs is much simpler, but…Feb 15, 2021Feb 15, 2021
PinnedJeffrey JacobsPivoting IIOT Data in SnowflakeIn this article, we discuss building an architecture for performing user friendly historical analysis of Industrial Internet of Things…Mar 3, 2021Mar 3, 2021
PinnedJeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceThe Elephant in the Data Lake and SnowflakeLet’s talk about the elephant in the data lake, Hadoop, and the constant evolution of technology.Feb 11, 2021Feb 11, 2021
Jeffrey JacobsGreat article.SnowBuilder is based on using IDENTIFIER, typically with a session variable.Feb 211Feb 211
Jeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data SciencePivot ANYTHING in Snowflake, Without the SQL PIVOT FunctionThe SQL PIVOT function has very limited functionality. It is only useful for numeric data, with very explicit, “hard coding” requirements…May 16, 2022May 16, 2022
Jeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake DBA-101; Deploying Standardized, Fully Functional DatabasesThis article provides both a guide and script for creating and deploying standardized, fully functional, Snowflake DATABASEs. A complete…Mar 20, 2022Mar 20, 2022
Jeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake and Duo Mobile, How to Lose Login Ability and MFA Across Multiple Accounts:ERROR: “USER…In working with multiple Snowflake accounts, I found a serious issue that I have not seen addressed elsewhere. NOTE: this issue applies…Jan 8, 2022Jan 8, 2022
Jeffrey JacobsinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake and ELVT vs [ELT|ETL] — Case Study Part 2, Real Time Availability for Single Row INSERTsIn my previous article, Snowflake and ELVT vs [ELT|ETL] — Case Study Part 1, The “No Data Model” Data Architecture, I described challenges…Jan 1, 2022Jan 1, 2022