Recent Articles

  • Secure Domo-Snowflake Connection: Service Accounts Guide

    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 password Read more

  • Efficiently Load Excel Files to Snowflake Without ETL Tools

    Efficiently Load Excel Files to Snowflake Without ETL Tools

    Data professionals often face challenges when transferring data from Excel to database systems. However, leveraging Python libraries pre-loaded into Snowflake enables efficient loading of Excel files with a few simple steps, bypassing traditional ETL complexity. This process involves confirming file location, capturing sheet names, reading Excel data, and writing it to Snowflake. Read more

  • Leveraging Domo’s Data Connectors for Seamless Snowflake Integration

    Leveraging Domo’s Data Connectors for Seamless Snowflake Integration

    The Domo/Snowflake Cloud Amplifier series explores connecting Snowflake to Domo for data transfer. Use Domo’s Atom RSS Feed connector to capture a feed and drop it into Snowflake. Set up the RSS feed URL in Domo, then configure Domo to write data directly to Snowflake. This integration simplifies data ingestion and enables advanced processing in… Read more

  • From Domo to Snowflake: Setting Up Write Access

    From Domo to Snowflake: Setting Up Write Access

    In the first article in this series, we configured the Snowflake environment for connecting Domo to Snowflake using Cloud Amplifier. Next, we setup read access to Snowflake. This article will cover writeback with Cloud Amplifier. Connect Domo Cloud Amplifier As in the last article, this walkthrough assumes you have at least demo Snowflake and Domo Read more

  • From Snowflake to Domo: Setting Up Seamless Read Access

    From Snowflake to Domo: Setting Up Seamless Read Access

    This article guides the setup of Domo for reading Snowflake data using Cloud Amplifier. The process includes integrating Snowflake in the Domo account, configuring essential settings, optimizing performance, and selecting tables to create datasets. The setup enables dynamic data visualization and analysis, with future articles focusing on writeback capabilities. Read more

  • Integrating Domo with Snowflake: Role Setup and Environment Preparation

    Integrating Domo with Snowflake: Role Setup and Environment Preparation

    Domo revolutionizes business intelligence with real-time analytics, integrating seamlessly with existing systems. This article focuses on setting up the Snowflake environment for Domo integration, including creating specific roles, warehouses, and service accounts. Sample data is loaded to simulate a production environment. Stay tuned for the next article on connecting Domo to Snowflake and leveraging sample… Read more