Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Parameterizing Azure Databricks when using SELECT query

Hi,   I am trying to parameterize my Azure Databricks connection to create a deployment pipeline. I managed to set parameters for ServerName, HTTP path, and Catalog, but what about a native SELECT ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    = let
    DatabaseName = DatabaseNameParameter,
    SQLQuery = "SELECT accountName, mainAccount, entity, entityId, Status, channel,
    COUNT(messageId) AS totalMessagesCount, errorGroup, yyyy, mm, dd,
    countryName, countryPrefix, networkName, originalMCC, originalMNC, originalMCCMNC
    FROM " & DatabaseName & ".gds_slv_infobip.operation_messages
    GROUP BY accountName, mainAccount, entity, entityId, Status, channel, errorGroup,
    yyyy, mm, dd, countryName, countryPrefix, networkName, originalMCC,
    originalMNC, originalMCCMNC",

    Data = Value.NativeQuery(
    Databricks.Catalogs(ServerNameParameter, HTTPparameter,
    [Catalog=CatalogParameter, Database=null, EnableAutomaticProxyDiscovery=null]
    ){[Name=CatalogParameter,Kind="Database"]}[Data],
    SQLQuery,
    null,
    [EnableFolding=true]
    )
    in
    Data

Anonymous's avatar
Anonymous
Not applicable
1 year ago

= let
DatabaseName = DatabaseNameParameter,
SQLQuery = "SELECT accountName, mainAccount, entity, entityId, Status, channel,
COUNT(messageId) AS totalMessagesCount, errorGroup, yyyy, mm, dd,
countryName, countryPrefix, networkName, originalMCC, originalMNC, originalMCCMNC
FROM " & DatabaseName & ".gds_slv_infobip.operation_messages
GROUP BY accountName, mainAccount, entity, entityId, Status, channel, errorGroup,
yyyy, mm, dd, countryName, countryPrefix, networkName, originalMCC,
originalMNC, originalMCCMNC",

Data = Value.NativeQuery(
Databricks.Catalogs(ServerNameParameter, HTTPparameter,
[Catalog=CatalogParameter, Database=null, EnableAutomaticProxyDiscovery=null]
){[Name=CatalogParameter,Kind="Database"]}[Data],
SQLQuery,
null,
[EnableFolding=true]
)
in
Data