Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I'm noticing that in Dataiku's default table creation SQL statements (for Dataiku-managed datasets), quotes are used around column names by default. My organization is accustomed to not using double quotes around column names, so that in our external SQL tool, we may query columns without having to worry about case sensitivity. What's your recommendation so that our SQL developers can continue to query Dataiku-managed tables in a case-insensitive way?
Hi,
In order to guarantee compatibility with all systems and preserving your column names, we indeed use quoted characters, which means that the columns are created in the database truly as they are, and do not get mangled by the database.
However, since Oracle is a "uppercase default" database:
Hope this helps
Hi,
In order to guarantee compatibility with all systems and preserving your column names, we indeed use quoted characters, which means that the columns are created in the database truly as they are, and do not get mangled by the database.
However, since Oracle is a "uppercase default" database:
Hope this helps