Systems | Development | Analytics | API | Testing

How to replicate SAP data in BigQuery

Are you interested in unlocking advanced analytics by replicating SAP data into BigQuery? In this video, Lucia Subatin, a Technical Lead in Solution Engineering, will demonstrate how to download and implement an ABAP enhancement built by Google Cloud to stream data directly into BigQuery. Watch, follow along, and ask questions in the comments below! Chapters: product: Cloud - General; fullname: Lucia Subatin;

Data Chief Live: External data: Your secret weapon in a cookie-less world

How do you get to know your customer in a cookie-less world? Join Rosemary Hua, Global Head of Retail & CPG GTM at Snowflake and Forbes 30 Under 30, Erik Mitchell, founder and principal at Seek Data, Nik Lampropoulos, Global Director of Data, Insights & Analytics, Hogarth Worldwide and Cindi Howson, ThoughtSpot CDSO, as they discuss questions like.

Talend acquires Gamma Soft

April 7, 2022, Talend, a global leader in data integration and management, announced today it has acquired Gamma Soft, a market innovator in change data capture (CDC). The addition of Gamma Soft’s highly complementary, enterprise-class change data capture technologies will help customers streamline their data modernization initiatives, including cloud migrations, and support advanced, real-time analytics use cases across hybrid and multi-cloud environments.

The World Beyond Test Automation: AI-Powered Intelligent Testing for Modern Applications

Web and mobile apps are now your primary connection with your customers. Staying relevant and winning market share requires that firms can make constant changes to these apps. But how can you deploy many more small changes - often many per day - with confidence and with managed risk? In the company of two software industry leaders, we take a closer look at how a modern testing toolchain combines production safety nets - from canaries, to feature flags, to error reporting - with AI-powered quality insights to engineer quality at speed for both developers and quality engineers.

SQL Puzzle Optimization: The UDTF Approach For A Decay Function

How do you implement a decay function in SQL? You can use window functions, which scale better than joins, or better yet, you can try what Felipe Hoffa did: use tabular UDFs. In this video, Felipe shows you how you can use a tabular UDF to write custom code that can analyze a table row by row while preserving state. Felipe wrote a table UDF in JavaScript that uses a low amount of memory to keep track of the decaying values. He was able to run it in 36 seconds, instead of the 46 seconds that the SQL with windows solution took; and then he optimized the JavaScript even further and ran it in just 9 seconds.