How to Change Oracle Data Storage Type

Options
jhiatt09
jhiatt09 Dataiku DSS Core Designer, Registered Posts: 4 ✭✭✭

I'm hoping to use the VARCHAR2 column storage type in Oracle rather than NVARCHAR2, which appears to be the default storage type used by Dataiku for strings in Dataiku-managed datasets stored in Oracle. What's the best way to do this?

Tagged:

Best Answer

  • pmasiphelps
    pmasiphelps Dataiker, Dataiku DSS Core Designer, Registered Posts: 33 Dataiker
    Answer ✓
    Options
    Hi,
    As a one-off workaround, in your output dataset (stored in Oracle), go to Settings -> Advanced -> Table creation mode -> Manually define
    image (8).png
    You can then manually change the column storage types in this field.
    You can find/replace all instances of "NVARCHAR2" with "VARCHAR2" by:
    1. Type "CTRL + OPTION + F" in your keyboard. A find/replace box will pop up. Enter "NVARCHAR2" here, then hit the enter key:

      image (9).png

    2. Write "VARCHAR2" in the "with" field, then hit the enter key:

      image (10).png

    3. Then choose replace "All":

      image (11).png

    Now your dataset should have column data types of "VARCHAR2".

    image (12).png

    Best,

    Pat

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options

    Hi,

    It's not possible to change this. We use NVARCHAR2 since it can accomodate all characters, which is not the case of VARCHAR or VARCHAR2.

    We'd be interested in hearing more about your use case for using VARCHAR2.

Setup Info
    Tags
      Help me…