Survey banner
Share your feedback on the Dataiku documentation with this 5 min survey. Thanks! TAKE THE SURVEY

Maintain case of SQL table name when creating SQL datasets

Currently, when a SQL dataset is created, the name of the associated SQL table is set to PROJECTKEY_tablename regardless of the case of the SQL dataset name.

It would be great if either the case of the dataset name was maintained in the SQL table name (so dataset ABC would result in a SQL table name of PROJECTKEY_ABC rather than PROJECTKEY_abc) or there was a project or instance option to force SQL table names to be all of one case (upper or lower case). 

In some databases, this mixed case table name means that references to tables must be surrounded by double quotes. For example, one must write SELECT * FROM "PROJECTKEY_datasetname". We'd much prefer to be able to write SELECT * FROM PROJECTKEY_DATASETNAME. This becomes an issue when referencing SQL tables in SQL recipes and outside of DSS.

Additionally, the same case names just look better. 

Currently most of the users in our company go into dataset settings after a dataset is created to change the table name to all upper case. We'd love to not have to do this.

6 Comments
AshleyW
Dataiker

Hi @Marlan ,

Thanks for the suggestion; this idea has been added to the backlog alongside similar requests about being able to specify the default case of table names.

Ashley

Status changed to: In Backlog

Hi @Marlan ,

Thanks for the suggestion; this idea has been added to the backlog alongside similar requests about being able to specify the default case of table names.

Ashley

That's great @AshleyW , thank you!

Marlan

That's great @AshleyW , thank you!

Marlan

Hope The solution would work for Snowflake as well..

Hope The solution would work for Snowflake as well..

bumping this as it is particularly annoying in snowflake, and seems DSS auto caps Snowflake instead of maintaining case

bumping this as it is particularly annoying in snowflake, and seems DSS auto caps Snowflake instead of maintaining case

johntarr
Level 3

Bumping this idea. This is a real pain point and applies to column names as well. When our report writers pull their data into a viz tool, they have to rename everything so it isn’t screaming at end users. 

Bumping this idea. This is a real pain point and applies to column names as well. When our report writers pull their data into a viz tool, they have to rename everything so it isn’t screaming at end users. 

MichaelG
Community Manager
Community Manager
 
I hope I helped! Do you Know that if I was Useful to you or Did something Outstanding you can Show your appreciation by giving me a KUDOS?

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
Status changed to: In the Backlog