Tag: row

Feed: Planet PostgreSQL. In this blog post, I will give a brief introduction to the new PostgreSQL 15 feature of publication row filters. This feature was added by the Fujitsu OSS team in close collaboration with other members of the PostgreSQL Open-Source community. There are several reasons why a user might choose to define logical replication row filters, such as reducing network traffic, reducing noise or eliminating bad data, replicating only data relevant to subscriber, and hiding sensitive information. Before we start Typically, when using logical replication PUB/SUB, all data changes from the published tables will be replicated to the ... Read More

Feed: Planet PostgreSQL. Toulouse, 1 June 2022 psycopg is a PostgreSQL database adapter for the Python programming language. As such, one of its main goals is to automatically adapt PostgreSQL and Python types together when issuing queries and retrieving results. While this conversion applies fine for built-in types, psycopg also exposes a native way to handle domain-specific data types: row factories. These domain models are typically defined by application developers in the form of data classes in Python, mapped to one or more relations (usually tables) in PostgreSQL. This is often where ORMs come into play by providing an abstract ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2022The details of how view permissions are checked have long puzzled me. PostgreSQL v15 introduces “security invoker” views, which change how permissions are checked. The new security invoker views make it possible to use row-level security effectively. I’ll use this opportunity to explain how view permissions work and how you can benefit from the new feature.Why are view permissions checked in a special way?Fundamentally, a view is an SQL statement with a name and an owner. When PostgreSQL processes an SQL statement, it replaces views with their definition. The replacement happens during the query ... Read More

Feed: What's New. Author: Sanjeev Verma. In my previous blog post, I discussed a new content type introduced in Tableau Data Management with our 2021.4 release: virtual connections. In addition to the sharing and management benefits, virtual connections now provide a centralized point of access to your data through which all queries flow–which makes them the perfect place to enforce your data security rules. Data Policies for Row-Level Security, a feature also added in 2021.4, lets you control who can see what data anywhere in Tableau. Row-level security (RLS) in Tableau refers to restricting the rows of data a certain ... Read More

Feed: Recent Announcements. AWS Lake Formation is excited to announce the general availability of three new capabilities that simplify building, securing, and managing data lakes. First, Lake Formation Governed Tables, a new type of table on Amazon S3, that simplifies building resilient data pipelines with multi-table transaction support. As data is added or changed, Lake Formation automatically manages conflicts and errors to ensure that all users see a consistent view of the data. This eliminates the need for customers to create custom error handling code or batch their updates. Second, Governed Tables monitor and automatically optimize how data is stored so ... Read More

Feed: Recent Announcements. Amazon QuickSight now supports larger SPICE datasets on the Enterprise Edition. Earlier each SPICE dataset could hold up to 250 million rows and 500GB of data. Now, all new SPICE datasets can accommodate up to 500 million rows (or 500GB) of data in the Enterprise Edition and 25 million rows (or 25GB) for Standard Edition. This raises the limit for your datasets, letting you accelerate dashboards with more data. See here for details. If you have an existing dataset that you've filtered to stay below the prior 250M row maximum, you can use SPICE's new capacity by removing ... Read More

Feed: SAS Blogs. Author: Briana Ullman. 28 years ago, Seinfeld was a staple on our televisions and Doc Martens were as popular as the Nirvana CDs flying off shelves. While the 90s may be back again, some good things never left – like SAS fueling advanced & predictive analytics innovation for 28 years running. Advanced and predictive analytics software includes data mining and statistical software and uses techniques including machine learning, regression, neural networks, rule induction, and clustering to create, test, and execute statistical models. IDC measures advanced & predictive analytics in its annual Worldwide Business Intelligence and Analytics Software ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. If you haven’t, you should read this first. This is part two. Speedrunning is the… hrm… – sport? art? – of playing games from start to finish as fast as possible. Speedrunning requires an insane amount of knowledge of the game being played, as well as an enourmous amount of skill. Also, contrary to what you might think, it is a community effort. Players do speedrun the game alone, and it is a ferocious competition, each one of them aiming for the top spot on the leaderboards. But discovering the strategies that will ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. The past few weeks I have been exploring the speed of R. It started with this video in which I explained that R is not necessarily slower than any other interpreted language, as long as you’re using the built-in, optimized functions. However should you write your own implementation of an algorithm, especially if that algorithm requires the use of one (or more…) loops, it’ll run slowly. As I’ve also mentioned in two other videos, here and here there are many ways to avoid loops, and you should do so if possible. To continue ... Read More

Feed: AWS Big Data Blog. In any business intelligence system, securing and restricting access to the data is important. For example, you might want a particular dashboard to only be viewed by the users with whom the dashboard has been shared, yet customize the data displayed on that dashboard per user by implementing row-level security. With row-level security, you can grant and restrict access to only specific rows, all rows, or no rows of any dataset. Organizations typically want to display different data to users within different business units. To do this, we need to traverse the organizational hierarchy to ... Read More