Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Deployment table: rm_mdm_locations

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

Find more posts tagged with

AI Studio

Server

Databases

Operationalization + Deployment

Accepted answers

BalazsBaranyRM

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

All comments

BalazsBaranyRM

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

BalazsBaranyRM

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)

)

SaschaITPL

thx it worked