Tag Archives: cloud

Streamlit in Snowflake: Building a Dynamic Pivot Query App with Selectable Criteria

This article describes how to create a Streamlit app within Snowflake that builds on a previous dynamic pivot query tutorial. It covers creating a view from a Common Table Expression, setting up select boxes for user input, and executing a dynamic SQL query to display results in a data frame for easy visualization.

Dynamic Pivot Queries in Snowflake: A Practical Example and Benefits

This post explores dynamic pivoting in Snowflake, showcasing its query example for simplifying data manipulation and reporting. It explains the step-by-step breakdown of a query that filters sales data by region and dynamically generates pivot columns based on unique nation names, enhancing adaptability, scalability, and efficiency in reporting.

Secure Domo-Snowflake Connection: Service Accounts Guide

In previous articles, I showed how to seamlessly connect Domo to Snowflake using Cloud Amplifier for both read and write access. In those examples, I set up a “service” account that still had a username and password. Since I wrote that article, Snowflake has enhanced user accounts to provide a true service account option. This account does not have a passwordContinue reading “Secure Domo-Snowflake Connection: Service Accounts Guide”