Custom Database extension - SQL Server Data source

[tvannamuthu]

Trying to migrate queries from Custom DB queries to Custom Database Extension. Created an extension for a query.

During execution, the extension provides the following warning - Connection exists but no metrics have been produced for endpoints: But I know data is available at the endpoint as the same query when run separately provides the desired output. What might be causing this error? Appreciate any insights.

[Miguel_RinconG]

Hi @tvannamuthu ,

Please shared your extension code. This is a query example:

  - group: User
    featureSet: User
    interval:
      minutes: 5
    query: >
      SELECT count(CustomerID) as UserCount,
      Region
      FROM Customers    
      where Region is not Null
      Group by Region
    dimensions:
      - key: custom.customquery.region
        value: col:Region
    metrics:
      - key: custom.customquery.sql.user
        value: col:UserCount

[tvannamuthu · Accepted solution]

Hello Miguel_RinconG,

I was able to fix the issue by adding the database name in the monitoring configuration. It was mentioned as optional so did not add that initially but after adding the Database name extension started to fetch metrics.

Thanks for your reply.