Maintain case of SQL table name when creating SQL datasets

Marlan
Marlan Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 332 Neuron

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.

12
12 votes

In the Backlog · Last Updated

Comments

  • Ashley
    Ashley Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 166 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

  • Marlan
    Marlan Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 332 Neuron

    That's great @AshleyW
    , thank you!

    Marlan

  • NN
    NN Neuron, Registered, Neuron 2022, Neuron 2023, Circle Member Posts: 150 Neuron

    Hope The solution would work for Snowflake as well..

  • importthepandas
    importthepandas Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 115 Neuron

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

  • johntarr
    johntarr Registered Posts: 7 ✭✭✭✭✭

    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.

  • aburkh
    aburkh Registered Posts: 10 ✭✭✭✭

    We just hit a bug when creating a partitioned SQL dataset on Databricks.

    While the SQL recipe contains lowercase characters, Dataiku transforms the column names to uppercase. Dataiku seems to be unable to resolve the dimension name (because it changed from MyPartitionKey to MYPARTITIONKEY). Very strange behavior, why does Dataiku changes the case instead of preserving it?

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,721 Neuron

    "Unity Catalog stores all object names as lowercase":

    https://docs.databricks.com/en/sql/language-manual/sql-ref-names.html

Setup Info
    Tags
      Help me…