Tableau Datasource Requires Uppercase Headers

Dremio University
1

I have a Oracle SQL data source which I want to run through Dremio, which has 110 Headers in this format:
image
Dremio’s Data Source defaults to lowercase:

image
image993×65 3.75 KB

Is there an easier way to change these than manually?

Note I made a query to change them using AS, but it will not run:
SELECT date_created AS DATE_CREATED, date_due AS DATE_DUE, date_closed AS DATE_CLOSED, id_dealer_program_phase AS ID_DEALER_PROGRAM_PHASE,

2

@jgreene

Is your only requirement to Alias them in UPPER CASE?

3

Yes, I’ve been in touch with a DBA here, I found out that the query sits on top of a couple of views with complex joins. So trying to optimize this.