@Jennifer i am not sure about this i have done through ADLS Gen2. For your approach managed role will be required i think. But if you can share some more details i think if you managed to expose in UC and not seeing data then i have recently done by creating a VIEW in UC where i am directly exposing my source files to UC. 

 

-- Replace with your actual catalog, schema, and view names
CREATE OR REPLACE VIEW Enviourment.Schema.tablename

AS
SELECT
Record_type,
ACCOUNT_NUMBER,
CUSTOMER_NUMBER,
MEMBERSHIP_TYPE_CODE,
POINTS_BALANCE,
POINTS_EARNED,
ACCOUNT_TERMINATED_DATE,
FROM parquet.`s3://your-bucket-name/path/to/parquet/files/`
-- Optional filter to ensure data integrity, if needed
WHERE ACCOUNT_NUMBER IS NOT NULL

I think simplest way to expose if you dont want to hold the anywhere in between. As per my understanding if you want to create a table its best practice to hold data somewhere in external location then register. 

Let me know if i correctly understood your issue  

harshit