Forum Discussion

rhartop's avatar
rhartop
Frequent Visitor
1 year ago
Solved

Databricks VNet DM_GWPipeline_Gateway_MashupDataAccessError

We are getting the following error when trying to refresh data from databricks via a VNet gateway. We have checked everything we can think of in terms of what might be causing the error though so far...
  • Ni_BI_Żak's avatar
    Ni_BI_Żak
    1 year ago

    Walkaround is possible by native queries

    Value.NativeQuery(Databricks.Catalogs(
    "adb-xxxxxxxxx.azuredatabricks.net",
    "/sql/xx/xx/xx",
    [Catalog = "xxx", Database = null, EnableAutomaticProxyDiscovery = null]
    ){[Name = "xxx", Kind = "Database"]}[Data],

    "select * from Sample",
    null,
    [EnableFolding = true])