Tag: Use

Feed: Recent Announcements. The Amazon EMR runtime for Apache Spark is a performance optimized runtime environment for Apache Spark, available and turned on by default on Amazon EMR clusters 5.28 onward. Amazon EMR runtime for Spark is up to 3x faster with 100% API compatibility with open source Spark. Today, we are excited to announce Result Fragment Caching, a new feature available in Amazon EMR runtime for Apache Spark to help speed up queries that target a static subset of data. In our internal tests derived from the TPC-H benchmark, when using Result Fragment Caching, queries that employ rolling and ... Read More

Feed: AWS Big Data Blog. Amazon Athena now provides you more flexibility to use parameterized queries, and we recommend you use them as the best practice for your Athena queries moving forward so you benefit from the security, reusability, and simplicity they offer. In a previous post, Improve reusability and security using Amazon Athena parameterized queries, we explained how parameterized queries with prepared statements provide reusability of queries, protection against SQL injection, and masking of query strings from AWS CloudTrail events. In this post, we explain how you can run Athena parameterized queries using the ExecutionParameters property in your StartQueryExecution ... Read More

Feed: R-bloggers. Author: RStudio | Open source & professional software for data science teams on RStudio. Want to keep people awake at data presentations? Try sharing your findings backwards. You’ve worked it. Now put your chart down, flip it and reverse it. The first time I put someone to sleep with a data presentation was in 2003. I was a school psychologist in a public school in the United States. That meant, among other things, that I tested elementary school students for learning disabilities. Then I’d share the results at meetings with parents and school staff so we could all ... Read More

Feed: Cloudwards. Author: Andrej Hadji-Vasilev; If you’ve ever played online games, you have probably noticed that communication plays a huge part. Jason Citron certainly noticed back in 2014 when he came up with the idea for Discord, and released the app a year later. We cover the basics of this social network in our What is Discord? article. However, as useful as the platform is for text and voice chat, not everyone knows how to use Discord.  Key Takeaways: Discord is a complete text, voice and video communication platform, but it takes some getting used to. Adding friends and talking to ... Read More

Feed: AWS Big Data Blog. Amazon Redshift is a fast, scalable, secure, and fully-managed cloud data warehouse that makes it simple and cost-effective to analyze all of your data using standard SQL. Amazon Redshift has comprehensive security capabilities to satisfy the most demanding requirements. To help you to monitor the database for security and troubleshooting purposes, Amazon Redshift logs information about connections and user activities in your database. This process is called database auditing. Amazon Redshift Audit Logging is good for troubleshooting, monitoring, and security purposes, making it possible to determine suspicious queries by checking the connections and user logs ... Read More

Feed: AWS Compute Blog. Author: Sheila Busser. This blog post is written by, Jeff Wisman, Principal Solutions Architect and Andrew Lee, Solutions Architect. Introduction Many organizations have sensitive datasets that they do not want to share with others because of stringent security and compliance requirements. However, they would still like to use each other’s data to perform processing and aggregation. For example, B2B (business to business) companies often want to augment their customer information dataset with additional demographic or psychographic signals. This enrichment of data is often done by one party sending customer information to be matched against another party’s ... Read More

Feed: Cloudwards. Author: Dan Ginn; YouTube Premium offers several perks you can’t access on a standard account. It removes the annoying ads, and it lets you download videos and run them in the background while you use other apps. Of course, these added features aren’t free, but there’s a simple hack you can use to get a cheap YouTube Premium account. Key Takeaways: YouTube Premium unlocks an ad-free YouTube experience, as well as download videos and watch them in background while using other apps. U.S. users normally pay $11.99 per month for the service.With the use of a VPN, you ... Read More

Feed: Planet PostgreSQL. How to use autocomplete in Query ToolTo use autocomplete, begin typing your query; when you would like the query editor to suggest object names or commands that might be next in your query, press the Control + Space key combination. For example, type "SELECT * FROM " (without quotes, but with a trailing space), and then press the Control + Space key combination to select from a popup menu of autocomplete options. Autocompletion for keywords For keywords just type a few characters and press the Control + Space key combination. Autocompletion of schema and schema objects To ... Read More

Feed: AWS Big Data Blog. Nowadays, many customers have built their data lakes as the core of their data analytic systems. In a typical use case of data lakes, many concurrent queries run to retrieve consistent snapshots of business insights by aggregating query results. A large volume of data constantly comes from different data sources into the data lakes. There is also a common demand to reflect the changes occurring in the data sources into the data lakes. This means that not only inserts but also updates and deletes need to be replicated into the data lakes. Apache Iceberg provides ... Read More

Feed: Workato. Author: Alex Lamascus; A comprehensive enterprise automation platform delivers a multitude of capabilities—from application and data integration to process automation to API publishing to IoT integration. Unlocking this broad functionality, however, likely requires you to adopt more than one type of technology.  So, out of the 10 types of technology platforms you can leverage as part of your enterprise automation strategy, which should you use?  While there’s no answer that’s one-size-fits-all, the current and predicted spending in the integration and automation market point to a few technology platforms that IT buyers are primarily interested in: iPaaS, RPA, and ... Read More