Skip to main content

Data Warehouse Connector - Live

Written by Ashley Ware

Data Warehouse Connector (DWC) - Live provides near real-time access to curated, governed TeleTracking datasets in Snowflake. The data can be used in analytics tools, applications, data warehouses, and operational workflows.

Functionality

  • Provides direct access to curated TeleTracking datasets in Snowflake.

  • Makes data available with minimal latency for near real-time use cases.

  • Uses the same governed datasets available for reporting.

  • Supports integration with:

    • External data warehouses

    • Business intelligence tools

    • Analytics platforms

    • Operational applications and workflows

  • Enables users to query current data continuously or at frequent intervals.

  • Supports operational decision-making and time-sensitive analytics.

  • Can be accessed using database tools such as TablePlus.

  • Requires technical resources familiar with Snowflake connections, data querying, and data integration.

  • Should be used according to applicable data governance, security, and contractual requirements.

  • Differs from other platform data options:

    • Data IQ® provides dashboards and reporting.

    • DWC Standard provides historical data with approximately six-hour latency.

    • DWC Live provides near real-time external data access.

    • Conversational Analytics provides natural-language insights.

Workflows

Connect to DWC Live Using TablePlus

  1. Install TablePlus from tableplus.com/download.

  2. Open TablePlus and select Create a new connection.

  3. Select Snowflake, and then click Create.

  4. Configure the Snowflake connection using the connection details for DWC Live.

    1. The connection screen may look different on Windows.

  5. Click Test to verify that the connection is successful.

  6. To view the DWC Live data, use either of the following options:

    1. Select a view from the left pane.

    2. Open SQL Editor and run a query using the DWC_LIVE schema.

Select the Appropriate Data Access Option

  1. Use Data IQ when dashboards or standard reporting are required.

  2. Use DWC Standard when historical analysis or batch-based data extraction is required.

  3. Use DWC Live when near real-time data access or operational integration is required.

  4. Use Conversational Analytics when natural-language insights are required.

Related Articles
Did this answer your question?