Azure Monitor

Azure Monitor is a tool for recording, pattern analysis, and diagnostics of log queries collected by Azure Monitor logs.

Through Fivetran's Azure Monitor service, you can connect and stream Fivetran log events to Azure Monitor, where you can flexibly manage them.

How to view Fivetran logs

You can view the logs in Azure Monitor Log Analytics workspaces.

To use filtering options in Azure Monitor:

• Select the workspace you provided in Fivetran's setup form.
• Locate the logs under Logs > Custom Logs.
• Log table is named fivetran_CL. _CL is the suffix added by Azure to custom tables.
• You can filter the table to see different logs.
  • To see logs for a specific connector, use the following KQL-based query:

    fivetran_CL
    | where Message contains "<schema_name>"
    

    Or alternatively:

    fivetran_CL
    | where Message["connector_name"] == "<schema_name>"
    

  • To see logs for the Dashboard activities, use the following KQL-based query:

    fivetran_CL
    | where Message contains "dashboard"
    

    Or alternatively:

    fivetran_CL
    | where Message["type"] == "dashboard"
    

  • To see Transformations for dbt Core* logs, use the following KQL-based query:

    fivetran_CL
    | where Message contains "<dbtModelName>"
    

    Or alternatively:

    fivetran_CL
    | where Message["dbtJobName"] == "<dbtModelName>"
    

For more information on queries in Azure Monitor, see Azure documentation:

• Get started with log queries in Azure Monitor
• Kusto Query Language (KQL) overview

Setup guide

Follow our step-by-step Azure Monitor setup guide to connect and stream Fivetran log events to Azure Monitor.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.