Describe table to show columns/properties

Follow

Naren Parimi

• July 29, 2020 04:02

I am trying to get table schema using desc or describe using SQL for which I am not able find an example. I see there are keywords reserved though in the documentation. Can anyone point me in right direction, please? Thanks

1

• 

  Shawn Yarbrough

  • July 29, 2020 04:08

  try: SHOW CREATE TABLE tablename;

  0

  Comment actions Permalink
• 

  Naren Parimi

  • July 29, 2020 04:17

  This worked but not in a way we wanted it :slight_smile: -

  1. Can we use Describe?
  2. What is the equivalent of information schema in OmniSci?

  0

  Comment actions Permalink
• 

  anon23740792

  • July 29, 2020 04:49

  Currently we dont have an information schema - can you discuss what you are trying to do that requires it specifically?

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • July 29, 2020 05:17

  hi @narenparimi,

  do you want output with the column name and other attributes without the create statement?

  right now we haven't a command to support it, but it's not too difficult to implement.

  0

  Comment actions Permalink
• 

  Naren Parimi

  • July 29, 2020 06:38

  Sure, We are trying to create a POC to build a data (catloging + profiler). The end user will have the ability to select a table and columns and profile them through UI.

  0

  Comment actions Permalink
• 

  Naren Parimi

  • July 29, 2020 06:42

  Yes - that is what we are trying to get to as well as give the end users ability to lookup a column/table by like name search.

  0

  Comment actions Permalink
• 

  Jagpreet Singh

  • August 03, 2020 12:53

  You can use \d tablename For Help \h

  0

  Comment actions Permalink
• 

  Ranjan

  • August 04, 2020 18:11

  Is there anyway to get measures and dimensions list ?

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • August 04, 2020 19:12

  HI @Ranjan653,

  There isn't any metadata's attribute to mark a field as measure or dimension; what do you exactly need?

  0

  Comment actions Permalink
• 

  Ranjan

  • August 04, 2020 19:17

  I want to create two dropdowns (select fields) one populated with dimensions and other with measures. Is there any way to achieve this ?

  Thanks

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • August 04, 2020 20:07

  There isn't any easy way to achieve this with any language or any API except on a multidimensional database that has the cubes built with fixed dimensions and measures.

  You should try to make your program guess the fields that are dimensions and the ones that could be a measure; a rule of thumb is that generally, the dimension fields are text data types, while the measures are numeric ones. Anyway a numeric field that could be used as a measure into a query could become a dimension in another one (e.g. used to build the dimension of a histogram). S there isn't anything that magically can guess for your use. the best you can do is to use a naming convention to know in advance which filed are dimension and which ones are measures

  0

  Comment actions Permalink

Please sign in to leave a comment.