Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Populate fields for DESCRIBE queries #304

Closed
jordanw-bq opened this issue Nov 26, 2019 · 2 comments
Closed

Populate fields for DESCRIBE queries #304

jordanw-bq opened this issue Nov 26, 2019 · 2 comments
Labels
BI integration Issues for integration with BI tools duplicate This issue or pull request already exists enhancement New feature or request

Comments

@jordanw-bq
Copy link
Contributor

Currently, DESCRIBE TABLES LIKE <table(s)> COLUMNS LIKE <column(s)> only returns basic/default metadata for columns (catalog name, table name, column name, and the name of the column's type ). If possible, we would like to see more information populated by this query, so we can have one source of truth for this column metadata, rather than having to maintain and synchronize it across implementations using it (like the Open Distro JDBC driver)

Details for these metadata columns can be found here: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlcolumns-function?view=sql-server-ver15#comments

@jordanw-bq
Copy link
Contributor Author

The most helpful fields for ODBC driver development at the moment would be DATA_TYPE and COLUMN_SIZE. We will update this issue if we discover other fields that might come in handy earlier than others.

@dai-chen dai-chen added BI integration Issues for integration with BI tools enhancement New feature or request labels Nov 27, 2019
@dai-chen
Copy link
Member

Duplicate as #325 which has more context there.

@dai-chen dai-chen added the duplicate This issue or pull request already exists label Jul 10, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
BI integration Issues for integration with BI tools duplicate This issue or pull request already exists enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants