Adding the pushdown parameter to a Snowflake connection - Cloud

Adding the pushdown parameter enables the Talend Trust Score™ calculation on the entire dataset, not only a sample.

1. In Talend Cloud Data Inventory, click Connections.
2. Hover over the connection name and click the Edit connection icon.
   
3. To enable the calculation of the Talend Trust Score™, in the JDBC URL field, add &runProfile=sql to the URL.
   

   Here is an example of the URL structure containing the pushdown parameter:

   jdbc:snowflake://account.snowflakecomputing.com/?db=MY_DB&schema=PUBLIC&warehouse=MY_WAREHOUSE_WH&runProfile=sql 

4. To calculate the Talend Trust Score™, temporary data must be written into a database. If you do not know whether your role has the write rights on the connection database, add &tmp_db= followed by another database name.
   Important: When you do not have the correct rights and do not add this parameter, the sample cannot be fetched.

   

   Here is an example of the URL structure containing the database and pushdown parameters:

   jdbc:snowflake://account.snowflakecomputing.com/?db=MY_DB&tmp_db=anotherDB&schema=PUBLIC&warehouse=MY_WAREHOUSE_WH&runProfile=sql 

   The data can be read from the connection database and temporary data can be written in the other database.

5. Click Validate.