Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

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

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

 

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?

0 Kudos
1 Reply
JordanB
Dataiker

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

0 Kudos