Experian Data Quality Community

Learn, collaborate and solve problems with like-minded data quality enthusiasts.

Data Management User Group - 20 November
It's time again for our popular Data Management User Group to get customers and users of Aperture Data Studio together to learn about new developments and plans for the product and give direct feedback to the product team. Get exclusive insights into the latest plans, hear how leading organisations are tackling real world…
PRODUCT ADVISOR UPDATES – MAKE SURE YOUR OPINION IS HEARD 📢
Hi all, I hope you have had a great start to the week. Thank you to everyone who has signed up as a Product Advisor; your contribution is invaluable to us. The community of Advisors has grown massively from 20 to over 120 members in just over a year, but we are always striving to further diversify the opinions and voices…
Customizing your Dashboard with the Custom content widget
Data Studio Dashboards can be configured by adding, ordering and resizing different widgets including Views and Charts. One of these widgets is the Custom content widget: https://docs.experianaperture.io/data-quality/hosted-aperture-data-studio/data-studio-objects/dashboards/#custom-content~customizing-dashboards Firstly…
Connecting to an Amazon RDS MySQL Database
A user recently asked about connecting Data Studio to their AWS RDS MySQL Database. The first thing to note is that MySQL on RDS uses the MySQL community edition, which is not supported by Data Studio's native JDBC driver. When attempting to connect, you'll receive this error: "Connections to MySQL Community Server are not…
🔔 Follow what you're interested in
When you navigate into any of our categories you will see a Follow button in the sidebar. This will allow you to subscribe to getting email notifications and notifications in the community about that topic. So for example if you want to be notified of new releases, navigate to the release and downloads section and click…
Pushdown Processing Advanced Function Mapping
Evening all, We're looking at implementing pushdown with Snowflake and have hit a couple of functions where we've had to workaround to avoid blocking the pushdown process. However, this advanced function mapping (as per documentation screenshot below) may help us fill some of those gaps and keep our workflows simpler. 3…
How to send a notification email to the assigned individuals for each issue in the issue list?"
Hello All, I need send a notification email to the assigned individuals for each issue in the issue list. Is that possible to achieve this within Experian itself. Can anyone explain me , how to do this? also please let me any specific access i need for this? currently i posses Designer role.
How to export dataset through API from Aperture Data studio?
Hello All I want to export one dataset in Experian through API and save it as csv file in my one drive. Dataset exists in space which created by me, let say space name is "To_Test". In this space i enabled the "Allow publishing OData" option. I generated the API key and tested the API in swagger UI and tested on "Retrive…
Validating Bank account details
Good morning, We know that Aperture already has built-in functions to check the format of bank account details. What we’re wondering is if there's an additional feature or method we can use to verify whether a bank account is actually a real account beyond just format validation. Basically, do we have a tool in Aperture…
Add additional dataset source - dropzone naming
Hi, I really like the capability to have multiple dataset sources, I have used it numerous times - good upgrade. However, I notice that when adding a new source (such as External System), if I select 'Enable external system dropzone' the only name option I get is 'Starts with file pattern' whereas if this was the default…
Trash Bin?
What problem are you facing? Deleting of batches often after a failed run. It's nerve racking not to delete a batch as some are very much needed batchs. We track data quality month on month, so accidentially deleting a needed month could happen. What impact does this problem have on you/your business? Huge impact on the…
Sticky Notes attached to Workflow step
Just a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I always provide decisions or descriptions of steps as part of knowledge transfer). That way if I move my workflow step the Sticky note comment moves with it (or worse, someone hits the auto-arrange button and now my Sticky notes…
Automation - only writing to last batch to dataset
Hi, I have a multi-batch dataset (lets say DS1) that is configured for an external dropzone. When new data gets dropped and loaded into the dataset DS1 an automation then fires off a workflow. The workflow then gets that dataset DS1, and does some transformations, grabs metadata etc and then writes that dataset as a whole…
A way to "execute workflow with all batches in the Dataset" when a new batch triggers the execution
What problem are you facing? A common setup in automated end-to-end automation in Data Studio is: when a new batch is added to a multi-batch snapshot, the "dataset refresh" triggers an automation which executes a workflow using that same Dataset as the source. Despite the workflow's source step being configured to use all…
ℹ How to track DQ issues with Issue lists
Issue lists allow you to capture problematic records, assign them to stakeholders and collaborate on a resolution. Records that have been fixed will automatically be resolved. Setting up your Issues list Go to Issue lists in left nav bar and create a new list to track related issues Create a Workflow to write issues to the…
Pushdown Processing on a pivot
Hi, In testing Pushdown Processing today, I hit a couple of errors. The first is simple to workaround by removing it (but would be awesome if the generation understood to omit) - the dataset query had a semi-colon at the end, which pushdown processing then put it's "as R0" after: The second I'm still at a bit of a loss. I…
Power BI OData connections are significantly slowing down Aperture, how to configure to prevent?
Hi, Our self-service users are using Odata connections to fetch data from Aperture DS to Power BI but that seems to slow down Aperture a lot. During some report executions, it can even prevent logging into Aperture because the log-in window cannot be opened (without any error message). I can also see several Api Key…
External system drop zone stopped working
Hi, The drop zones that I have set up for several subfolders for many files has stopped working, and even after a restart continues to not work. The log contains a lot (a lot!) of these messages: INFO c.e.d.d.ExternalDirectoryWatcher [ExternalDirectoryWatcher-e3649cf8-de9f-42e2-8eec-edee6e98c157 1369857878] Error fetching…
Find Duplicates no connecting
Hi there, I am having problems making the duplicate stores connect to the server. I checked the server is running normally but when I am on the ads ui the connection is failing, can anyone help please?
Administration Space containing info on all objects
George_Stephen - December 11 "Please create a Administration Space that contains information of all objects in all spaces" This discussion was created from comments split from: Having an issue managing too many objects.
Search and replace of multiple values.
Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a field, the other column is the value I should replace if its a match. How can I achieve this without creating a function with lots of steps for each string I need to search and replace. ORIGINAL STRING NEW STRINGTEXTO NUEVO -|…
Suggested approaches for manipulating JSON values
My data includes a column containing JSON values - I've made a dummy example below: https://us.v-cdn.net/6031645/uploads/CNP6XDWHH24R/color.csv Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a":…
Create a function that compares the date open to todays date
how would i create a function that compares the date open to today's date
Find Duplicates Issue
Hi there, I'm having this issue with the find duplicates step, can anyone help?
Schema-Flexible Configuration with JDBC (Apache Hive 6.0) External System
We've successfully configured an external system using Connection type: JDBC and DBMS: Apache Hive 6.0. I’m looking for guidance on how to set up a Schema-Flexible configuration. Specifically: Is it possible to use Schema-Flexible JDBC connections to support workflows that export data to multiple schemas? For example,…
A default value for "automatically delete data after N days"
What problem are you facing? Almost all the data loaded into my Data Studio instance has a mandated 90 day retention period. 90 days after load we want to delete any batches that remain. Most data is loaded into new Datasets (in new Spaces) because we are working typically on short-term, one-off projects. There are…
Improved Driver support for Teradata data warehouse platform.
What problem are you facing? Improved Driver support for Teradata data warehouse platform. We currently have to use the JDBC driver supplied by Teradata, which is not native to ADS and it generally works, but we do encounter many issues like data type conversion issues. Would be nice to have an alternative Teradata ODBC…
Useful Function: Distance between two coordinates
Recently developed a function based on the Haversine Formula to generate the distance between two coordinates (in meters). It's useful for comparing distance approximations between different address points. Simply copy the below text into the function script editor: param Point 1: Latitude; param Point 2: Latitude; param…
Workflow option to Refresh Sources doesn't apply to Contains Match
Hi, I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here? Thanks
Data Governance Masterclass - 9th October
Hi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thursday 9th October, featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance governance strategies, hear real-world success stories, and connect with peers…
Date column recognized as "alphanumeric" while profiling
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
Distinct count aggregation
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
♻ Reusable workflow example – calculate word frequency
Today I’d like to share with you a reusable workflow that I built a little while ago not only as a downloadable .dmx file (see below) for you to explore/use as you wish, but also as a means of demonstrating one of the key themes of Data Studio…reusability. If you find that there are duplicate tasks being executed on your…
How to explore Workflow script (preview) functionality
Recently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i unable to find those feature. Can anyone please help me with this?
Manually reviewing clusters of duplicate records (Stewardship)
What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and change clusters of records where I think the rules have matched records incorrectly e.g. I've got a husband and wife in my data, both called M. Smith and they share the same postal address, email address and loyalty card…
Find Duplicates: handling of Gmail email modifiers
What problem are you facing? The Email and Email_Local elements in Find Duplicates Standardization currently retain all characters by default, including dots (.) and plus-aliases (+alias) in the local part of email addresses. This means that emails like johnsmith@email .com, john.smith@email .com, and john+alias@email .com…
Word Frequency
Every now and then a scenario crops up where it'd handy to know how often a given word occurs within a given dataset. For example you're profiling a reasonably standardised list of values (e.g. job titles) and you want to identify unusually common terms (like 'manager' 'executive' etc) or infrequent ones (like 'test123').…
Address Elements, how does the Duplicate Store determine which element a field is?
Hi all, Does anyone know where I can find some detailed documentation on how the duplicate store determines which elements are applicable to a text entry in an address field. I'm fine tuning our rules sets at the moment and know how this step of the process works will be super helpful so that I don't inadvertently cause…
Automation Email Trigger Works for Individuals, Not Distribution List(DL)
Hi Aperture team, I’m currently using the Automation feature to trigger email notifications. Since our team uses a distribution list (DL) to keep the recipient list up to date, I tried adding the DL as the recipient. However, emails are not being triggered when using the DL, whereas they work fine when listing individual…
Is there a way to generate Univeral Unique ID for each row?
I want to create a new column that has Univeral Unique ID for each row. Is there a way in ADS to generate it?
Whatsapp Validation as replacement for Email validation
What problem are you facing? An Indonesian based financial services company is looking to replace Experian's Mobile Validation with Whatsapp Validation as Whatsapp validation is the main method of communication there as its cheaper than calling or texting mobile numbers. Curious to know if this has been requested by other…
Dataset API - External System DropZone
What problem are you facing? The dataset API only shows if the "server dropzone" is enabled or not, the "external system dropzone" is not included in the return data. What impact does this problem have on you/your business? The API does not include all dropzone metadata associated with the dataset. This makes validating a…
Dataset API - Dropzone
Hi, When using the dataset API, the value for "Enableddropzone" is FALSE even though the dataset is set up for "Enable external system dropzone". Does the API only show "Enable server dropzone"? Thanks
Re usable workflow, with different source
i have created the workflow(Let say workflow_1 with source as dataset_1) and make it as reusable. created another workflow(Let say wrokflow_2 as parent workflow) with workflow_1 as child workflow and changed the source as dataset_2. dataset_1 & dataset_2 are exactly same, the only difference is that the dataset_1 has one…
Push down processing connection to Big Query
What problem are you facing? Comparing bank transactions at the bank is a major issue and time consuming exercise when trying to review large volumes of data. Some data points include types of offerings a customer may have for further loan/services approval ie. Mortgage, current account, personal loan, credit card…
Synthethic Data - Asks from clients
What problem are you facing? Long project timelines replicating data from production and masking PII information What impact does this problem have on you/your business? Time to project timelines as well as security risk by managing large volumes of PII information ie, credit card details, bank account numbers. Do you have…
Salesforce import fails
Hi, This is one of the error messages. In some cases there is no error message in the log file although no rows have been imported. "Caused by: com.experian.aperturedatastudio.jdbc.sforce.phoenix.sql.ae: Socket Error: Read timed out Caused by: java.net.SocketTimeoutException: Read timed out" Do you know what can cause…
Bringing Data Together
Knowing the best path for working with multiple datasets can be confusing sometimes, understanding which approach is appropriate for what your wanting to achieve is key to getting the outcome you want. Here's a straight forward breakdown of 4 out-of-the-box Aperture Data Studio operations which will allow you to bring your…
connect to Snowflake external system with OAuth 2.0 authentication method
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
Strengthening Data Quality with ABN Validation
Hi DQ Community, I wanted to share some insights into the powerful custom workflow step for ABN (Australian Business Number Validation) within Experian’s Aperture Data Studio. Built using our SDK, this workflow step enables users to validate ABNs with a real-time API lookup against the ABR database. It not only confirms…
Email and Telephone numbers Validation
Hi Everyone, We are currently reviewing the email and telephone validation functionalities within Aperture and would appreciate further clarity on the business logic behind these rules. Email Validation: Aperture offers two types of validation; Format Check and Domain-Level Validation. While Format Check verifies if the…
How can I rename the values in a RAG column while keeping the colour styling using SetCellStyle?
Hi everyone, I’ve created a RAG-style column in my Aperture workflow using SetCellStyle, and it’s working well in terms of applying colours (Red, Amber, Green) based on a percentage field. However, the values currently display as True or False, and I’d like to rename them to custom labels like "Pass", "OK", or "Fail" —…
v2 to v3
do i need to do v 3.0.0 when i m going from ads v2 to v3, or i can go straigh tto latest ads v3.0.8? br, hs
Ability to List Automations (eg. API)
What problem are you facing? I need to ensure that automations have been created for specific tasks associated with specific entities. This allows validation for myself and my client that the work is complete, and no tasks are missing. What impact does this problem have on you/your business? With a large set of…
List Automations?
Hi - is there a way to list all automations? (i.e via SWAGGER). I see there is a way to see schedules, but an automations listing would be helpful. Thanks
Find Duplicates - Ignore a value
Hi, I am attempting to use the find duplicates module. In one of my unique data fields I have dfound that a dummy value has been used for cases where data is not easily obtainable. Is there a way to direct the matching criteria to ignore this value when trying to match rows? Column name in Data is 'UniqueID' TIA.
Best approach- to do profiling for large dataset (20 million records)
Hello , I need to do profiling for tables which have more than 20million records and also the table will get update with new records as every week. 1) Is that right to do profiling for such a large dataset, will i get any performance issue? 2) as the table gets updated with new record as weekly basis, is that possible that…
Cloud licensing
Hi team, We have deployed ADS production server and when we tried to apply the cloud license, we are getting the below below error. We have applied the SSL certifications and still the cloud license is not working. Error: Unable to find a valid certificate. Please ensure the Java installation has all certificates required…
QAS Vs Experian Aperture Address Validation
Hi, We currently use QAS for address validation and currently running POC for Aperture data Studio. Please can you share the benefits of using QAS over Aperture for address validation. Is there any difference in the way address is validated in QAS and Aperture. Thanks, Jencil
How can I create a custom RAG (Red-Amber-Green) status column in my Aperture workflow?
Hello! I’ve been using the built-in validation rules in Aperture (like validate telephone, email, and address), and I really like how they generate a RAG-style column to show data quality at a glance. I’m now looking to create my own custom RAG status based on specific business rules for example, combining multiple fields…
I just got a 3+ sign-ins in a month badge or a frequent flyer badge.
I see dont see any info about this or any other badges, or way to earn points.
Option to include Group Name in Validate All Result
What problem are you facing? Validate Step All Results - Duplicate Rule names used in different groups result in indistinguishable columns What impact does this problem have on you/your business? We have occasion where we need to group our results into various sub-populations, so we take the All Results output then apply…
Validate Datetime Datatype
i want to validate that the column datatype is "Datetime" Datatype. i found only "Is Date" function, but i want to ensure that column is Datetime by adding rule in validate step of workflow. Is there any function or work around to achieve this? Thanks
To be able to use groups and group permissions when using SAML and LDAP
What problem are you facing? Administrators are currently having to add individual users. This is a pain when a customer has more than 10 users to add. What impact does this problem have on you/your business? Not user friendly and time consuming to add users. Do you have any existing workarounds? If so, please describe…
Percentile calculation
Hi everyone, I created a reusable workflow that define wheter a column value is in the 'Percentile' value (for example 95%) or not and also creates a column indicating if you need to smooth a value when reach or surpass that percentile. It needs a column and a parameter to the percentile to calculate (1%, 5%, 25%, 50%,…
Combine Filter/Split step
Hi, I'm raising this on here as it's come up a few times with various users and I want to see what others' think of the idea to essentially combine the filter and split steps (which perform the same action, with the only difference being the split step allows users to view unfiltered results): vs I myself have found on…
Moved: Gen AI in Aperture Data Studio
This discussion has been moved.
Gen AI in Aperture Data Studio
Aperture Data Studio has functionality that uses several different machine learning and artificial intelligence techniques, including clustering, cosine similarity, deep learning, and more recently GenAI. Gen AI Actions [in v3.1] When exploring data in the grid you are able to describe what you want to calculate or how…
New Database Drivers
Are there any database drivers that people would like us to have access to? Please cast your vote below, or comment which driver you would like to see.
Workflow failure
Hi everyone, I am getting this error on one of my workflows. Can anyone help?
Hi, I'd like to add a column to my data that counts how many times a cell appears in a given column.
Ankita Singh: Senior DQ Delivery Consultant
I am a Senior Consultant at Experian Data Quality and is mainly responsible to support our ANZ clients to derive the most value from Aperture Data Studio implementation. My primary focus is from delivery perspective where I work with customers to help them achieve their data quality objectives using Data Studio in order to…
Missing Tables in "Table or Database View" but Accessible via "Database Query
Hi community, I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list. Interestingly, I am able to access and query those missing tables using…
Changing the External Source underlying the data set
Hi, We have developed several workflows using several data sets that are sourced from a particular External Data Source. Now the external data source is moved and renamed. Is there a way to point the Datasets to the new External source ? Many Thanks. Regards, Manoj Bhosle
Manual match cluster refinement - Update
I'd like to share some progress we're making with Data Stewardship or as we're calling it, "Cluster refinement" for data matching within Aperture Data Studio. We've been told by a few of you that it would be a very useful capability. The original post on the community ideas board can be read here. The improvements we're…
How to save profiling result as view for multiple table(50+ tables)
I have many tables, i need to run profiling on each of the tables and need to save the results as view. Since i have more number of tables, is there any way to do this altogether, rather then doing the same thing each table one by one.
How to resolve "No space left on device" errors
Hello, In the last few days we have been encountering the "An unexpected error has occurred during Workflow execution: 9003: An unexpected error has occurred during Workflow execution. No space left on device" error. We have gone through our installation and removed a lot of datasets that we no longer need which should…
View batch data as an action item under 'Show Batches'
What problem are you facing? When I take the option 'Show batches' for a dataset, I see the list of batches for that dataset, including all the helpful metadata. If I select 'Action' the only option I get is 'Delete'. It would be very helpful if 'View' was an option to see data for that selected batch. What impact does…
STS account - Reactivation
hi @Ian Hayden , Sent you an email regarding reactivation of STS acc. we have tried to contact service desk but still not have gotten the issue resolved. I ll be on leave soon and my colleague needs on acc , active so she can share logs with you in case of issues in next few weeks, Br, HS
How to Cancel an Ongoing Dataset Refresh?
Hi, We successfully triggered a data refresh on our dataset. However, we now need to stop or cancel the refresh in progress, but we’re unable to locate an option to do so. Could someone please guide us on how to cancel an ongoing refresh? Thanks in advance for your help!
Drop Zone Configuration - Occasionally dropped files are not picked up
Howdy, I have been dealing with a slight issue with a server drop zone setup we use for a specific workflow. Most times we have no issues… but then randomly a file will be dropped and it will just sit - it is not being read at all as it just stays in the root directory (doesnt trigger an error and create the error…
Add record limit to source step
What problem are you facing? Working with very large datasets, sometimes hundreds of millions of records, in order to debug a workflow, I often find myself adding a sample tool after each source so that I can preview results at different steps in the workflow. Otherwise it can take hours waiting for 'show step results'. It…
Route to live process & environments
Hi, I want to get a route to live process in place whereby only things which have been peer reviewed and signed off are promoted to live, and any other work just stays in the test environment. We already have 2 environments set up (default and test). The test environment isn't really used, so would be an ideal blank canvas…
Data Governance Masterclass 10th July
Hi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thursday, 10th July, featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance their governance strategies, gain insights from industry experts, and connect…
OData $top in Power BI
Hi, We are trying to pull a dataset into Power BI and limit to 1000 rows whilst we iterate to make refreshing snappier. However, we're getting an Error 400 that $top isn't supported, though the documentation seems to suggest otherwise. Should this work? It feels like the way Power BI structures the query, perhaps its the…
Address Validation Issue
Hey community, I have just updated to the new version of ADS, also updated the address validation, copy all the right files to the right folders but there is still an error on the Address Validation. Can anyone help with this?
Guidance Needed: Transitioning Data Sources from HD Insights to Databricks
Hi Team, We are anticipating changes in our datastore architecture, which will significantly impact datasets and views currently sourced from HD Insights. These sources will need to be repointed to Databricks as part of the transition. Could you please advise on the possible solutions or best practices for handling this…
OpenText Content server export
Hi All, I’d like to ask whether Aperture is capable of directly connecting to OpenText Content Server, without requiring any middleware or intermediate systems (such as Talend or external scripts). Is there a native connector or export integration available for pushing data directly from Aperture into Content Server?…
Group Step Sum of Nulls should return Null
What problem are you facing? When getting the Sum of a column via a Group Step, if all the values considered in the aggregation are Null, the Sum presently returns zero. This makes it impossible to distinguish whether all the values were Null or if the data contained numbers with a sum of zero. This distinction may matter.…
Determine the minimum numeric value when column contains null/string values
What problem are you facing? The "minimum" aggregate returns null() as the minimum if at least one of the values in a column are empty. What impact does this problem have on you/your business? This impacts data quality and returns incorrect results for aggregates when dealing with numeric values. Do you have any existing…
Auto discovery of keys (foreign, primary)
Logging this idea on behalf of @AlanB (feel free to add further commentary) What problem are you facing? We are starting a migration project from a largely undocumented system and need to identify how the various tables relate to one another (e.g. what are the foreign / primary keys, potential joins as well as conducting…
How to modify in aperture the header for Powercurve Collections interfaces
I am working on the input interfaces that PCC manages, which has the following nomenclature ProcessingDate|Row-count Here is an example: 20250603|5762202 1416|81178235||Vendor|| 6700|81380685||Sold-From Party|| but I can't get the columns to join correctly. as a result I have this 20250603|5762202||||||…
Fire event - if input has no rows
Hi All, I would like to fire an event (run a specific workflow) if NO rows in the input - but there is only an option to fire events if input has rows: Basically the goal is to only send correct data to an external system (Snowflake) if there are no errors (at all) in a dataset. Is there a way to set this? Many thanks!…
What is the cause of an error message that says "4058: Unable to rollback" and how can it be fixed?
This error occurs on the Export workflow step.
Column header in the second row
Hi All, is there a way to use the second row (instead of the first) as the column names when uploading dataset? Or is there a workaround? There is a dataset that we would like to drop into the DropZone but the header is always in the second row… Many thanks! Vera
Is there an easy way to do this partitioning?
Hi, I have seen previous posts on partitioning, and use that technique regularly. However, my need this time is slightly different. I have groupings of duplicates, but I would like to count incrementally when I come across a new identifier. I actually have this working now, but it took some Aperture kung-fu, so wondering…
fill down or propagate values to empty cells
Good morning, what's the best way to fill down or propagate values for fields like 'Year' and 'Submission Month Name' so that all rows in a dataset display these values consistently? Many thanks in advance
api key expiry notification
hi, can someone tell me simple steps to create alert on my api key, so that before it expires, i get an alert, email alert or something else? Br, hs
Your API key < API key name > will expire in 10 days'
can u help me set up this? i cannot find the right directives in below documentation. i need to know via email, before api keys expire. Br, HS i want to know before hand, https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/
Tagging as sensitive information
Hi All, As I'm reviewing the space settings, I noticed there is a section called "Potentially Sensitive Information." Could you please let me know how to tag specific columns in a dataset or view as sensitive data? In some cases, we need to create restricted views, so it would be helpful to have a clear way to identify…
Export views, datasets, schedules etc.
Dear All! Is there an easier way to extract all the views, datasets, schedules etc. information from a space or across different spaces? I mean what we have in this GRID for examples for the views: I need to create different reports and it would be time consuming to select and copy-paste. Many thanks! Kind regards, Vera
Our Data Management User Group is on 20 May 2025
Once again we would love you to join us for our next Data Management User Group taking place on 20 May 2025 between 10:00am – 4:00pm at our offices in Cardinal Place, Victoria, London. This will be a special User Group event as we have an opportunity to share a real milestone in our product innovation. Our ‘new generation’…
Sorting is better to do before Join?
Does sorting of the participating ids in the joining condition helps in better performance? i thought if I use a sort step before Join that will improve my performance but it is actually taking 15+seconds extra when I am using sort step before join, is there any other way to improve the performance time or it is not…
space issue in data folder.
we have space issue on our indexes, I believe in last 2 days, that has grown more than 600GB, how could it be, can you help us investigate? br, HS
character encoding mismatches
Hi, I'm having an issue when downloading a dataset in CSV format, some of the characters are been introduced on the download such as â€™s instead of " ' ". Is there a setting or function to prevent this issue? Best regards, Marco

Events

Data Management User Group
Join us for our upcoming Data Management User Group! Get exclusive insights into the latest plans, hear how leading organisations are tackling real world data challenges, join expert-led discussions on today’s most pressing data issues. We look forward to seeing you there.

Top contributors

Mahulima 293

James T Sidebotham 282

M.Lambert 148

Uma 87