CDP Operational Database expands support for SqlAlchemy APIs with Phoenix with support for the getPrimaryKeys and getIndexInfo from the JDBC API through PhoenixDB (along with the SQL Alchemy wrapper APIs).
- getPrimaryKeys API retrieves a description of a table's primary key columns ordered by COLUMN_NAME
- getIndexInfo API retrieves a description of a table's indices ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION
This capability is available in PhoenixDB 1.1.0 and is compatible with all CDP 7.x versions and all CDP Operational Database service versions.