Systems | Development | Analytics | API | Testing

Latest Posts

Data Lake Export Public Preview Is Now Available on Snowflake

Public preview of the data lake export feature is now available. Snowflake announced a private preview of data lake export at the Snowflake virtual summit in June 2020. Data lake export is one of the key features of the data lake workload in the Snowflake Data Cloud. The feature makes Snowflake data accessible to the external data lake, and it enables customers to take advantage of Snowflake’s reliable and performant processing capabilities.

Extending Snowflake's External Functions with Serverless-Adding Driving Times from Mapbox to SQL

Data engineers love to use SQL to solve all kinds of data problems. For this and more, Snowflake is a perfect partner. Snowflake’s support for standard SQL and several SQL variations, combined with JavaScript stored procedures, has helped me solve complex data challenges. But sometimes you might have the need for custom code.

Better Listening Through Customer Experience Insights

Snowflake connected with Margaret Sherman of Sonos at Data Cloud Summit 2020 to hear how the company is using the Data Cloud to understand customer preferences and enhance listening experiences. In a world where people are surrounded by a lot of noise, purity of sound in music and other content we seek out in the comfort of our homes can offer a welcome respite. There are lessons to be learned from a company reinventing home audio for today and tomorrow—and using the Data Cloud to do it.

Snowflake + Fivetran + dbt: Turn Your Marketing Data Silos into Marketing Insights

The 2020 Marketing LUMAscape showcases more than 8,000 tools marketers can use to generate leads, drive brand awareness, and measure all their marketing efforts. But with all those tools, comes a lot of disparate and siloed data. How do you bring them all together in a consistent, reliable, and fast way to understand your ROI, determine attribution, and see which of your marketing efforts are working?

Support for Calling External Functions via Azure API Management Now in Public Preview

In June, Snowflake announced the public preview of the external functions feature with support for calling external APIs via AWS API Gateway. With external functions, you can easily extend your data pipelines by calling out to external services, third-party libraries, or even your own custom logic, enabling exciting new use cases. For example, you can use external functions for external tokenization, geocoding, scoring data using pre-trained machine learning models, and much more.

10 Best Practices Every Snowflake Admin Can Do to Optimize Resources

As we covered in part 1 of this blog series, Snowflake’s platform is architecturally different from almost every traditional database system and cloud data warehouse. Snowflake has completely separate compute and storage, and both tiers of the platform are near instantly elastic. The need to do advanced resource planning, agonize over workload schedules, and prevent new workloads on the system due to the fear of disk and CPU limitations just go away with Snowflake.

The New Face of Secure Data Collaboration: Transforming Government with the Data Cloud

The push to embrace cloud-based technologies has undoubtedly transformed IT infrastructures at every level of government. Federal, state, and local agencies have made significant strides in modernizing how data is collected, stored, and analyzed, all in service of their mission and in fulfillment of strategic IT mandates.

Understanding Snowflake's Resource Optimization Capabilities

The only certainty in today’s world is change. And nowhere is that more apparent than in the way organizations consume data. A typical company might have thousands of analysts and business users accessing dashboards daily, hundreds of data scientists building and training models, and a large team of data engineers designing and running data pipelines. Each of these workloads has distinct compute and storage needs, and those needs can change significantly from hour to hour and day to day.

What Grocers and CPG Companies Need to Know About Post-Pandemic Shopping

The COVID-19 pandemic has changed nearly everything. It’s affected nearly all Americans, and as such, it’s impacted every organization they interact with, both B2C and B2B. One industry that has had its operations turned upside down is the grocery industry. Grocery stores and their consumer packaged goods (CPG) suppliers and partners had to improvise and adapt nearly overnight to accommodate the changing demands of shoppers.