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

[scholaschl]

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?

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

[JordanB]

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. 

Please let us know if you have any questions. 

Thanks,

Jordan