From the course: Databricks Certified Data Engineer Associate Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Table documentation

Table documentation

From the course: Databricks Certified Data Engineer Associate Cert Prep

Start my 1-month free trial Buy for my team

Table documentation

“

- [Instructor] Here we have Catalog Explorer, and what I'm going to do is add documentation to a table. There's a couple ways to do this. First, we can go look at a table and I'm going to take this height, weight table here and notice that it says this is a table comment. So let's go ahead and change that and just say that it is synthetic data. Right, so I've been able to enhance the table comment here, which is great, but a lot of times, you don't always want to point and click and change things. You want to be able to programmatically interact with a table. So what we can do is go to Create and go to SQL Query here. And we can actually manipulate this by doing a SQL Query. So what I can do is I can say let's go ahead and take this default SQL statement out and do an alter table here. So what I can do is I can say, "ALTER TABLE," and we're going to go ahead and select this one, which is the height weight here.…

Contents