Skip to main content Skip to complementary content

Adding the pushdown parameter to a Snowflake connection

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
  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.
    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.
    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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!