apache / apache/arrow-adbc

Clarification on GetObjects FOREIGN KEY

Open
#2,294 2 comments 0 reactions 0 assignees View on GitHub
Type: question
Dominant language
C#
Stars
627
Forks
217
Avg merge
17h
Merged PRs (30d)
57

Description

### What would you like help with?

Is the intent of the `FOREIGN KEY` constraints returned by `AdbcConnectionGetObjects` that they include relational constraints in both directions? That is, for a `CUSTOMER` table defined as in [TPC-H](https://docs.snowflake.com/en/user-guide/sample-data-tpch), should it return both `"ORDERS"."CUSTKEY"` (which references `"CUSTOMER"."CUSTKEY"`) and `"NATION"."NATIONKEY"` (which is referenced by `"CUSTOMER"."NATIONKEY"`)?

If so, the documentation could probably be improved by indicating this explicitly.

If not, if it only returns references in one direction then this is a feature gap with ODBC and JDBC.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.