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”
Author Archives: Eric Heilman
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.
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 Snowflake.
Eric Heilman 