If location is specified while creating a table then its an external table, in this case it will not remove the data rather only metadata will be recreated. But if you drop and re create managed table with same name, the table id changes thus the managed location for table data changes. If you want the data back then, undrop the table.
great videos, thank you so much for the playlist, I have one question can't we create a managed table using a MANAGED LOCATION clause similar to how you create for catalog, schema in the external location for managed tables example: create table dev.bronze.sale_external ( id string, product_code string ) managed location 'path/to'
Never tried with MANGED LOCATION option, but can definitely try. But once you start adding location at table level it becomes an external table. If you like my content make sure to share with your network over LinkedIn ❤️
This is my first time watching one of your videos - you explain everything very clearly and concisely. Definitely subscribing! Keep up the good work 😊
Thank you ❤️ Please make sure to share with your network over LinkedIn 👍
When I go to my catalog in db workspace, I am not getting any delta sharing option or external location option. I am using premium tier. Please help
Please check the user you are using is also a metastore admin.
What happens if you drop and recreate a table with the same ddl i.e. location and names?
If location is specified while creating a table then its an external table, in this case it will not remove the data rather only metadata will be recreated.
But if you drop and re create managed table with same name, the table id changes thus the managed location for table data changes.
If you want the data back then, undrop the table.
great videos, thank you so much for the playlist,
I have one question
can't we create a managed table using a MANAGED LOCATION clause similar to how you create for catalog, schema in the external location for managed tables
example:
create table dev.bronze.sale_external (
id string,
product_code string
)
managed location 'path/to'
Never tried with MANGED LOCATION option, but can definitely try. But once you start adding location at table level it becomes an external table.
If you like my content make sure to share with your network over LinkedIn ❤️
@@easewithdata Ok, Thank you
❤
If you like my content, Please make sure to share with your network over LinkedIn 👍