topic Re: Save output of show table extended to table? in Get Started Discussions

Save output of show table extended to table?

dplaut — Mon, 04 Dec 2023 20:57:09 GMT

I want to save the output of

show table extended in catalogName like 'mysearchtext*';

to a table.

How do I do that?

dplaut — Tue, 05 Dec 2023 15:15:24 GMT

I can't get this to work. I get the error:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'SHOW'.line 2, pos 0

insert into my_target_table (database, tablename, istemporary, information) SHOW TABLE EXTENDED LIKE 'mytable';

dplaut — Wed, 06 Dec 2023 11:51:34 GMT

I would not have expected that to work as it violates rules I know about SQL and the purpose of the semicolon. And it does not work.

[PARSE_SYNTAX_ERROR] Syntax error at or near end of input.line 1, pos 75

njoyb — Sat, 19 Apr 2025 06:51:04 GMT

Use DESCRIBE EXTENDED customer AS JSON
this returns as a json data . This you can load

Applicable to databricks 16.2 and above