Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4658

Data scramble feature

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Unresolved
    • Major
    • Open To Community
    • None
    • Query Engine
    • None

    Description

      I have a customer asking for a feature to do data scramble.

      The need is change the production data to be used in another environments without the user know the original data.

      e.g:
      Give the person table:

      CREATE TABLE person (
        id INT PRIMARY KEY,
        name VARCHAR(256) NOT NULL,
        age INT,
        height INT,
        weight DOUBLE
      );
      
      SELECT * FROM TABLE PERSON WHERE ID=1;
      

      Result:
      The name is from row with ID#15, the age is from row with ID#3, the height is from row with ID#5.

      On this way the customer can work with consistent and natural data, but unreal.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hodrigohamalho Rodrigo Ramalho
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: