dpc
Contributor III

‎01-23-2026 01:45 AM

It works but there's a scenario that causes an issue.

If I create a schema with defaultcollation UTF8_LCASE 

Then create a table, it marks all the string columns as UTF8_LCASE 

Which is fine and works

 

If I create the table, in the newly created UTF8_LCASE schema from an existing table using:

 

CREATE TABLE <destination> AS
SELECT *
FROM <source>
WHERE 1 = 2;
 
 
The table is UTF8_LCASE but all the columns aren't
So, when  I use it, it remains case sensitive
 
Any thoughts?
Am I doing something wrong here as I really want to create tables that are structurally the same with the exception of case
I am doing this as I land the data and the initial table is derived from the landed structure, before moving it.
 
Thanks
0 Kudos