This is an automated email from the ASF dual-hosted git repository. zeroshade pushed a commit to branch fixup-metadata-getobjects-snowflake in repository https://gitbox.apache.org/repos/asf/arrow-adbc.git
commit 39e1ed273e102aad8fc67afb76ec9a87c8968610 Author: Matt Topol <[email protected]> AuthorDate: Mon Oct 14 16:35:19 2024 -0400 trim whitespace --- go/adbc/driver/snowflake/queries/get_objects_dbschemas.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/go/adbc/driver/snowflake/queries/get_objects_dbschemas.sql b/go/adbc/driver/snowflake/queries/get_objects_dbschemas.sql index 627d11c32..bc454866a 100644 --- a/go/adbc/driver/snowflake/queries/get_objects_dbschemas.sql +++ b/go/adbc/driver/snowflake/queries/get_objects_dbschemas.sql @@ -16,17 +16,17 @@ -- under the License. WITH db_schemas AS ( - SELECT + SELECT "database_name" as "catalog_name", "name" as "schema_name" FROM table(RESULT_SCAN(:SHOW_SCHEMA_QUERY_ID)) WHERE "database_name" ILIKE :CATALOG ), db_info AS ( - SELECT "name" AS "database_name" + SELECT "name" AS "database_name" FROM table(RESULT_SCAN(:SHOW_DB_QUERY_ID)) WHERE "name" ILIKE :CATALOG ) -SELECT +SELECT { 'catalog_name': "database_name", 'catalog_db_schemas': ARRAY_AGG({ @@ -34,9 +34,9 @@ SELECT 'db_schema_tables': null }) } get_objects -FROM - db_info -LEFT JOIN db_schemas +FROM + db_info +LEFT JOIN db_schemas ON "database_name" = "catalog_name" WHERE "database_name" ILIKE :CATALOG GROUP BY "database_name";
