PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Feb 11, 2021Reduce 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…
PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Feb 11, 2021Agile 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…
PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Feb 15, 2021Agile 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…
PinnedJeffrey Jacobs·Mar 3, 2021Pivoting IIOT Data in SnowflakeIn this article, we discuss building an architecture for performing user friendly historical analysis of Industrial Internet of Things…
PinnedInSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Feb 11, 2021The Elephant in the Data Lake and SnowflakeLet’s talk about the elephant in the data lake, Hadoop, and the constant evolution of technology.
InAltaSQL for SnowflakebyJeffrey Jacobs·May 25, 2025Column Alias Syntax vs Conventional SELECTWhy Column Alias Syntax with Object Aliases Should Be the Standard in SQL Development
Jeffrey Jacobs·Feb 21, 2024Great article.SnowBuilder is based on using IDENTIFIER, typically with a session variable.A response icon1A response icon1
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·May 16, 2022Pivot 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…
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Mar 20, 2022Snowflake 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…
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyJeffrey Jacobs·Jan 8, 2022Snowflake 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…