Bug: Shallow Clone `create or replace` causing [TABLE_OR_VIEW_NOT_FOUND]
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 02:24 AM
I am having an issue where when I do a shallow clone using :
create or replace table `catalog_a_test`.`schema_a`.`table_a` shallow clone `catalog_a`.`schema_a`.`table_a`
I get:
[TABLE_OR_VIEW_NOT_FOUND] The table or view catalog_a_test.schema_a.table_a cannot be found. Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01
As you can see it's throwing an error related to the new cloned table. The weird bit is, the command does create the table.
