Data Lakes Daily

PrestoDB Last year we posted an introduction article on Presto . So what is new in the Presto world since then? A ton! PrestoDB moves to the Linux Foundation In September 2019, the official PrestoDB Foundation was started by Facebook, Uber, Twitter, and Alibaba. A formal, official foundation is what was needed for the Presto ecosystem to prosper. The formation and transition to a formal foundation under the Linux Foundation’s auspices was a significant first step to deal with confusion in the community. Kudos to Facebook, Uber, Twitter, and others in making this a reality. Having open, shared, and community-driven organization is critical to future success Presto. You can read more about these principles and roadmaps  here . Revisiting PrestoDB vs. PrestoSQL Why is a formal, independent foundation necessary? Presto Foundation established a set of much-needed guiding principles for the community. In the post last year, we highlighted some confusion about the tw...

Helping Seller Central FBA merchants keep selling in response to coronavirus Amazon service suspension Fulfillment by Amazon temporarily suspended for non-essential Seller Central products Amazon recently announced that they are prioritizing household staples and medical supplies into their fulfillment centers. Prioritizing certain products will negatively impact Seller Central users that rely on Fulfillment by Amazon (FBA). Fulfillment by Amazon (FBA) allows third-party sellers to ship and store their products at Amazon’s warehouses, allowing Amazon to handle the fulfillment of customer orders. Since Amazon has direct access to the product, they can quickly ship it to the customer. For now, this service is on hold for a large number of merchants. Here is a statement from Amazon: “We are seeing increased online shopping, and as a result, some products such as household staples and medical supplies are out of stock,” the company announced on its seller platform calle...

The highest-performing sellers on Amazon drive performance by taking advantage of an essential resource available to them, Amazon Advertising performance data . These leading sellers recognize that data is the key to unlocking insights that drive purchases, optimize Ad spend, target special offers, and promotions. With the Openbridge Amazon Advertising data pipeline, Looker users now have a fast, code-free data platform to tap into the performance information the pros are using. Our Amazon Advertising data pipeline delivers Looker users a zero administration, full automated feeds for reports and dashboards. Looker users can easily integrate with AMZ Advertising to create reports without the hassle of technical or ETL implementations. Amazon Advertising + Looker For data-driven advertisers using Looker, our service will supply data to measure the impact of advertising investments so they can plan with confidence, optimize spend, and measure marketing strategies. Our servic...

Amazon DMS AWS DMS is an easy to use, cost-effective database replication tool In August 2016, Amazon Web Services released Database Migration Service (DMS). DMS is database replication software focused on making it easier to migrate data from a source database to a target destination like a data warehouse or data lake (within AWS). What is AWS Database Migration Service? DMS supports migrations of data from multiple sources via a few different replication methods. Oracle to Oracle, Oracle, or Microsoft SQL Server to Amazon Aurora and Redshift. DMS also supports MySQL database replication as well as Postgres, and others. In addition to replication data from a database, AWS DMS allows you to continuously replicate your data with high availability and consolidate databases cloud warehouses like Amazon Redshift or object storage Amazon S3. For in-depth details on the supported source and target databases , AWS makes these details available on their site. Types ...

We are excited to announce Grow.com users can now leverage our Amazon Advertising data integration. This will unlock access to critical Amazon Advertising performance data within the Grow platform. Openbridge has unlocked the advertising performance data critical to optimizing sales and accelerating sales growth. Ready to tap into your data with Grow? Get started for free ! Why Grow users want to tap into Amazon Advertising data The highest-performing sellers on Amazon drive performance by taking advantage of a key resource available to them, Amazon Advertising performance business data. Leading sellers recognize data is the key to unlocking insights that drive purchases, optimize Ad spend, target special offers, and promotions. With the Openbridge Amazon Advertising data pipeline for Grow.com, users now have a fast, code-free opportunity to tap into the performance data the pros are using. Our Amazon Advertising data pipeline delivers metrics that matter to Gro...

Instagram Marketing and Amazon Advertising Using Instagram Ecommerce + Amazon Advertising To Drive Sales Using paid advertising on Instagram can add a needed boost to brand and product awareness. Why pair Instagram with Amazon Selling? Check out this  post . Advertising on Instagram and Amazon provides a cohesive and consistent catalyst for creating a sales engine for your e-commerce operation. Pairing Amazon Advertising with your Instagram efforts ensures people become aware of your offering on Instagram and get exposure and reinforcement on Amazon.com. Types of Instagram Ads What types of advertising options are available to you on Instagram? The best way to use Instagram for advertising would involve combinations of the following approaches: Photo Ads: Tell your story through a clean, simple, and beautiful creative canvas Video Ads: Get the same visually immersive quality as photo ads — with the added power of sight, sound, and motion Carousel Ads: B...

Supercharge your AWS data lake architecture with new query service extensions AWS recently released an updated called federated queries for Athena. This new capability brings Athena closer in abilities to its relative, Facebook Presto. What is Presto? It is the foundational technology behind Athena! Facebook describes Presto this way: “Presto is an open-source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto allows querying data where it lives, including Hive, Cassandra, relational databases, or even proprietary data stores. A single Presto query can combine data from multiple sources, allowing for analytics across your entire organization.” The ability to query multiple data sources is a welcome addition to Athena, providing new cost-effective paths to build a data lake efficiently. The new federated queries capability can open up new opportunities to extend your data lake ...

Our Tableau Data Prep tutorial closes the loop in your data workflows Tableau Prep Builder provides an easy to use interface to combine, shape, and clean “dirty data” so can get to analysis faster in Tableau desktop . The result is that Prep can support an ELT workflow, where data is extracted, loaded, and then transformed via Prep Builder. This can make it convenient for analysts and business users to make adjustments and refinements quickly and without traditional ETL tools. Unfortunately, if you wanted the outputs of your flow to get written back to a data lake or warehouse, it can be a challenge. While completing the data flow to a target database is a requested feature, it is not yet available within Prep. Does this mean you are stuck? NO! You can still automate the outputs from Tableau Prep to a target data lake or warehouse in a few simple steps. Adding a couple of steps to your workflow will allow you to get your workflow output loaded to a target data lake ...

Grow BI + Amazon Merchant Services We are excited to announce Grow users can now leverage our Amazon Seller Central MWS e-commerce data integration. The Openbridge MWS data integration is a code-free, fully automated data integration that unlocks critical seller central performance data within the Grow platform. Openbridge has unlocked the MWS performance data critical to optimizing sales and accelerating sales growth. Ready to tap into your data? Get started for free! Why Grow users want to tap into Amazon MWS data How are the leading Amazon sellers supercharging sales? They tap into performance data from a data source called Amazon Merchant Services (MWS). These “pro” sellers recognize data is the secret to unlocking e-commerce insights. They connect to Amazon MWS for this data. These pros know when customers may be more likely to purchase which means they can optimize ad spend, inform inventory management decisions, target special offers, promotion...

Instagram for Amazon Sellers How to sell on Instagram for Amazon Sellers Is Instagram a tool you can use to drive e-commerce sales? Yes! Are you interested in using Instagram to drive qualified opportunities into your e-commerce funnel? You should be! Are you unsure of the right way to use Instagram to help market your business, attract potential customers, and promote Amazon seller products? Read on. Instagram is one of the most popular online social media platforms. It has more than 100 million active Instagram accounts, and that number is expected to grow beyond 111 million by the end of this year. With numbers like that in mind, it’s no wonder many businesses have started to include Instagram as part of their e-commerce growth strategies. In addition to having a large number of daily active users, there are lots of other reasons why Instagram should be part of your e-commerce strategy. Instagram shopping strategies can help you with branding, prom...

Looker Amazon Seller Central We are excited to announce Looker users can now leverage our Amazon Seller Central MWS e-commerce data integration . The Openbridge MWS data integration is a code-free, fully automated data integration that unlocks critical seller central performance data within the Looker platform Why Looker users want to tap into Amazon MWS data How are the leading Amazon sellers supercharging sales? They tap into performance data from a data source called Amazon Merchant Services (MWS). These “pro” sellers recognize data is the secret to unlocking e-commerce insights. They connect to Amazon MWS for this data. These pros know when customers may be more likely to purchase which means they can optimize ad spend, inform inventory management decisions, target special offers, promotions, and other tactics. Email marketing, customer service, user experience, conversion rates, cross-selling…all get a boost when using your Amazon MWS data to optimize you...