Data selection from adls2 in Serverless Warehouse

ogs
New Contributor II

Hi everyone,

I'm trying to query data from our adls2 delta lake using a serverless sql warehouse. We've already set up private connectivity via NCC, but hitting a snag when running queries like:

SELECT * FROM delta.`abfss://container@xxx.dfs.core.windows.net/delta_tbl`

"Invalid configuration value detected for fs.azure.account.key"

My questions:

  1. Where exactly should I configure this storage key in a Serverless setup? (It's not a traditional cluster where I'd use spark.conf.set)

  2. Is creating an external table in UC a better approach? Something like:
    CREATE EXTERNAL TABLE xxx
    USING DELTA
    LOCATION 'abfss://container@xxx.dfs.core.windows.net/xxx'
    and what config should be made for this to work Thanks.