topic Re: How to read sql file from a Repo to string in Data Engineering

How to read sql file from a Repo to string

pabloaus — Thu, 01 Dec 2022 08:58:44 GMT

I am trying to read a sql file in the repo to string. I have tried

with open("/Workspace/Repos/xx@***.com//file.sql","r") as queryFile:
   queryText = queryFile.read()

And I get following error.

[Errno 1] Operation not permitted: '/Workspace/Repos/***@***.com//file.sql'

Re: How to read sql file from a Repo to string

Senthil1 — Fri, 02 Dec 2022 03:26:18 GMT

Hi @pablous,

Make sure your REPOS is enabled by checking in Admin console and have full read/list privileges to do from workspace.

If all are perfect, then need to check whether there is anything blocks when we enable Unity Catalog, but i didn't feel anything related to this, since you r hitting GIT integrated repo acess, not the METASTORE repo access

Re: How to read sql file from a Repo to string

Senthil1 — Fri, 02 Dec 2022 03:27:04 GMT

I checked in my unity_catalog enabled cluster, i am able to access the @repos file to read and display