Data selection from adls2 in Serverless Warehouse
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2025 07:08 AM
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:
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)
- Is creating an external table in UC a better approach? Something like:
CREATE EXTERNAL TABLE xxx
and what config should be made for this to work Thanks.
USING DELTA
LOCATION 'abfss://container@xxx.dfs.core.windows.net/xxx'