The meshlet uses SELECT statements to determine if a table you are trying to replicate exists in the Snowflake database as well as to get the table's columns to build the SQL statements to copy data into the database properly. However, if you see in Snowflake's history that there are SELECT * FROM <table_name> (i.e. SELECT * FROM incident) taking a long time to return, you can optimize it by updating the databaseConfig.json as follows: Change Code Block |
---|
| "selectAll":"SELECT * FROM %s", |
To Code Block |
---|
| "selectAll":"SELECT * FROM %s LIMIT 1", |
|