Options

Deployment table: rm_mdm_locations

SaschaITPLSaschaITPL Member Posts: 7 Contributor I
Hey, may someone tell me the column names and types of the "rm_mdm_locations" table in his Rapidmine AI Hub Database? I deleted mine, need to create it again i think

Best Answer

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted
    Oh, I didn't read your question well. It's a deployment database.

    Here's the table definition:


    CREATE TABLE public.rm_mdm_locations
    (
        name text COLLATE pg_catalog."default",
        id text COLLATE pg_catalog."default" NOT NULL,
        CONSTRAINT rm_mdm_locations_pkey PRIMARY KEY (id)
    )

    In my environment it has one row, the name is the one I entered, the id seems to be a generated unique ID. You might be able to find the ID in one of the other tables if you already have deployed models.

    Next time, have a backup of your database ready before dropping tables! ;-)

    Best regards,

    Balázs

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Hi @SaschaITPL,

    my 9.8.1 AI Hub database doesn't have such a table. 
    Which version are you using? Can you write some other table names that still exist here? 

    Regards,

    Balázs
  • Options
    SaschaITPLSaschaITPL Member Posts: 7 Contributor I
    thx it worked
Sign In or Register to comment.