I created a transient schema "Employee_Schema" in which I created a normal table "Employee"
create table Employee(Id Int, Name String, Salary Double)
data_retention_time_in_days=90;
Now because the schema was transient, the table also became transient as well. Problem is the retention period of 90 days got attached to it where as Snowflake documentation shows transient tables cannot have retention period more than 1 day.
To validate the same I create a normal schema within which I created a transient table with retention period of 90 days which threw an error.
