Option insert table name (in a sparksql query) adds the project name as prefix

Options
scholaschl
scholaschl Dataiku DSS Core Concepts, Registered Posts: 8 ✭✭✭

Hello,

For some time, in sparksql queries, when I use the INSERT option to the right of the table name in input, the name of the table appears with the table name as a prefix, but it is not the case all the time?

insert.PNG

Do you know why this happens? And why it doesn't happen all the time?

Tagged:

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Options

    Hi @scholaschl
    ,

    This has to do with how you configure "Naming rules for new datasets" within the connection settings. Any datasets created within DSS will be given the prefix that you have defined (as shown below). By default, the prefix is var ${projectKey}_ , however, this can be modified. When you import a dataset, you will not see the prefix - perhaps that is where the confusion comes from.

    Screen Shot 2022-10-06 at 5.42.25 PM.png

    Please let us know if you have any questions.

    Thanks,

    Jordan

Setup Info
    Tags
      Help me…