Efficiency of Snowflake snap

When using the Snowflake Insert snap, a call for getting the table metadata is done.
show /* JDBC:DatabaseMetaData.getColumns() */ columns in database “XXXX”
This is very inefficient, in our database this call alone takes 50 seconds because of the number of objects in the account.
Also, Snowflake will start charing for processing time on these calls from 2020. this will drive up the cost for Snowflake customers.
The correct way to do this is to filter on the schema and table in the getColumns() call.

1 Like