Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future Consideration
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Oct 12, 2023

Snowflake connector Improvement

In the new version 2023.3, we started to use the new Snowflake connector.

When the current snowflake connector queries all meta data (e.g. table names, column names), the query is over ALL tables and columns in the Siemens Snowflake Account. This can take up to 8 minutes…

These are the SQL statements from Jedox to Snowflake (querying the meta data):
For tables:
show /* JDBC:DatabseMetadata.getTables() */ objects in account

For Columns:
Show //* JDBC:DatabseMetadata.getColumns() */ columns in account

According to the showflake documentation, this can be limited to columns of the selected table
https://docs.snowflake.com/en/sql-reference/sql/show-columns

An example for the syntax using the ShowColumns:
SHOW COLUMNS [ LIKE '<pattern>' ] [ IN { ACCOUNT | DATABASE [ <database_name> ] | SCHEMA [ <schema_name> ] | TABLE | [ TABLE ] <table_name> | VIEW | [ VIEW ] <view_name> } ]

In order to improve your connector, we would like to suggest an improvement and if possible to create the Showcolumn process inside the connector.

  • ADMIN RESPONSE
    Oct 13, 2023

    Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.