When creating a new schema for Snowflake an error message was thrown that it could not create the schema.
Reason
This is happening because the PDO/ODBC implementation of Snowflake has some quirks with preparing a SQL query. Our intended workflow of all of our database implementations should be: Prepare data (escape/sanitises data) -> execute query. Only the default Snowflake ODBC implementation fires the query directly instead of preparing the query.
Solution
Within the ODBC driver configuration file we need to set the configuration `NoExecuteInSQLPrepare=true` re-enable the original intended functionality of the prepare statement of the PDO/ODBC. Checkout this documentation for help.
References:
– https://docs.snowflake.com/en/release-notes/2020-08.html#odbc-driver-2-21-6-changes-to-the-handling-of-ddl-statements-in-sqlprepare-and-sqlexecute
– https://appsfortableau.infotopics.com/support/documentation/write-back-extreme-installation-manual-linux/