Connection

Settings to connect Data Warehouses and manage metadata of tables

Connection is used to manage access for Data Warehouses. It includes authentication credentials uploaded by users to execute queries and retrieve table information.

Key Features

• Run queries:

  • Issue queries with authentication in Notebooks , Reports and Queries

    • A caching function works to prevent unncessary job execution. For more information, please check (Appendix) Query Execution and Cache

• Aggregate metadata:

  • Aggregate schema metadata using Table Sync to maintain up-to-date and comprehensive data records.

• Access control:

  • Manage access control to restrict which users and groups can execute queries and retrieve the results of the execution. See details in Access Control for Connection.

How to Set Up

• Create and configure the settings, including uploading authentication information. Please refer to the setup guide for each warehouse.

  • Supported Warehouses

• Trigger synching to retrieve and save the metadata of tables.

  • Sync Table Metadata