Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Notebook CopyBusinessCentral.ipynb - Lakehouse parameter #228

Closed
StefaanVanDuyse opened this issue Jan 30, 2025 · 1 comment
Closed

Notebook CopyBusinessCentral.ipynb - Lakehouse parameter #228

StefaanVanDuyse opened this issue Jan 30, 2025 · 1 comment

Comments

@StefaanVanDuyse
Copy link

Hi Bert,

I ran against an error when running the notebook

Lakehouse = 'businessCentral'; #can also be a GUID

if you use a GUID the command
df = spark.sql("DROP TABLE IF EXISTS "+ Lakehouse + "." + table_name)
fails

because you use SQL maybe you need to use the SQL analythics endpoint here ?
But with the Lakehouse name it works fine
So the text #can also be a GUID is not correct here (at the moment)

@Bertverbeek4PS
Copy link
Owner

Thanks for the remark! ANd indeed that is right.
If you add back-quotes then is works fine. I have added this comment with the following PR:
#229

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants