Hi @Dhruv-22 , 

Based on the information you shared above, the "CREATE OR REPLACE" and "CREATE" commands in Databricks do have different behaviours, particularly when it comes to handling tables with specific target locations.

The "CREATE OR REPLACE" command is designed to either create a new table or replace an existing one. On the other hand, the "CREATE" command is used to create a new table. 

Please refer this documentation for more details: https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html

Hope this helps you and please leave a like if this helps, followups are appreciated.
Kudos
Ayushi