PinnedPublished inSnowflake 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
PinnedPublished inSnowflake 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
PinnedPublished inSnowflake 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
PinnedPivoting 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
PinnedPublished inSnowflake 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
Great article.SnowBuilder is based on using IDENTIFIER, typically with a session variable.Feb 211Feb 211
Published inSnowflake 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
Published inSnowflake 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
Published inSnowflake 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
Published inSnowflake 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