Upload tool MYSQL query issue
I'm trying to upload from my MSQLD database with a query that changes the names of the columns to match my Zoho table.
The query I'm using in database_sql_queries.xml is:
- SELECT count_endtime AS DATE,
- REPLACE (customer_id, '514', 'OZ')AS SITE,
- count_in AS InCount,
- count_out AS OutCount,
- count_occupancy AS Occupancy
- FROM `zone_activity` where customer_id = '514'
- ORDER BY `zone_activity`.`count_endtime` DESC
This query fundamentally works, but it only changes the name of the customer_id column. The other columns in the resulting csv do not get renamed. Is this a limitation in the upload tool?