CREATE TABLE test.delete_me (bignumeric BIGNUMERIC (37, 2));
INSERT INTO test.delete_me VALUES (12.78);
Now When I try to use the CTAS (Create Table As Select) query, Then the newly created table loses the precision and scale information for the column.
CREATE TABLE test.delete_me_2 AS SELECT * FROM test.delete_me;
I tried creating VIEW as well and the same issue is happening. Is this the issue expected?