# Adding the pushdown parameter to a Snowflake connection

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

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

## About this task

Information noteNote: Adding the pushdown parameter impacts the Talend Trust Score™ calculation only. You can use Talend Cloud Data Inventory normally.

## Procedure

1. In Talend Cloud Data Inventory, click Connections.
2. Hover over the connection name and click the Edit connection icon.

   ![Edit connection icon](https://help.qlik.com/talend/en-US/data-inventory-user-guide/Resources/images/inv-edit-connection.png)
3. To enable the calculation of the Talend Trust Score™, in the JDBC URL field, add &runProfile=sql to the URL.

   ![The JDBC URL field with the &runProfile=sql parameter.](https://help.qlik.com/talend/en-US/data-inventory-user-guide/Resources/images/inv-sf-param.png)

   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.

   Information noteImportant: When you do not have the correct rights and do not add this parameter, the sample cannot be fetched.

   ![The JDBC URL field with the &tmp_db= parameter.](https://help.qlik.com/talend/en-US/data-inventory-user-guide/Resources/images/inv-sf-add-tmp-db.png)

   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.