Let us know how we can make Jedox even better!
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.
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.