New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

go/adbc/driver/snowflake: GetObjects API doesn't return table constraints #1319

Open

ryan-syed opened this issue Nov 21, 2023 · 0 comments

Contributor

ryan-syed commented Nov 21, 2023

GetObjects API for snowflake go driver doesn't return table constraints:

arrow-adbc/go/adbc/driver/snowflake/connection.go

Line 177 in cac2d83

// table_constraints | list<CONSTRAINT_SCHEMA>

as a part of TABLE_SCHEMA. Reference implementation can be found for the BigQuery driver:

arrow-adbc/csharp/src/Drivers/BigQuery/BigQueryConnection.cs

Line 526 in cc0c4e9

    
           string query = string.Format("SELECT * FROM `{0}`.`{1}`.INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name = '{2}'",

The goal would be:

Add table constraints implementation for GetObjects within getObjectsTables method
Add tests in https://github.com/ryan-syed/arrow-adbc/blob/main/csharp/test/Drivers/Snowflake/DriverTests.cs to check if the table constraints are returned
Add parsing of table constraints in https://github.com/apache/arrow-adbc/blob/main/csharp/test/Apache.Arrow.Adbc.Tests/Metadata/GetObjectsParser.cs

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment